Books

Translate This Blog
-
Recent Posts
Top Posts
- Querying UDP Ports with PowerShell
- Changing Ownership of File or Folder Using PowerShell
- Setting up Local Administrator Password Solution (LAPS)
- PowerShell and WPF: Writing Data to a UI From a Different Runspace
- PowerShell and Excel: Adding Some Formatting To Your Report
- Locating Mount Points Using PowerShell
- PowerShell and WPF: Introduction and Building Your First Window
- Querying UDP Ports with PowerShell: Part 2
- Converting CSV file or files into an Excel workbook
- Avoiding System.Object[] (or Similar Output) when using Export-Csv
Archives
Categories
- .net
- api
- array
- background jobs
- binary
- book
- c#
- clock
- codeplex
- com object
- convert
- CTP
- database
- deep dive
- excel
- Favorites
- function
- groups
- guest blog
- hash table
- Internet Explorer
- ise
- mcpmag
- module
- MVP
- network
- news
- parameter
- patches
- performance
- pinvoke
- podcast
- port
- PoshChat
- poshpaig
- PoshRSJob
- poshwsus
- powercli
- powerscripting
- Powershell
- printers
- quickhits
- reflection
- regex
- registry
- Regular Expressions
- report
- resolution
- runspace
- runspaces
- scripting games 2012
- scripting games 2013
- scripting guy
- scripts
- SMO
- Speaker
- speaking
- SQL
- tcp
- tips
- tsql
- updates
- user group
- V3
- V4
- v5
- weather
- widget
- win32API
- winter scriting games 2014
- wmi
- word
- WPF
- wsus
- xaml
Tag Archives: csv
Converting CSV file or files into an Excel workbook
Update 07SEPT2010: Updated script based on an excellent comment to use the Paste() method for converting CSV files into an excel workbook. Thanks Luc! While going through the Technet Powershell Forums and Scripting Guys Forums, I came across a question … Continue reading