Awards
Omaha PowerShell Users Group
Books
2013 Powershell Scripting Games
Translate This Blog
-
Recent Posts
Top Posts
- Starting,Stopping and Restarting Remote Services with PowerShell
- Changing Ownership of File or Folder Using PowerShell
- Avoiding System.Object[] (or Similar Output) when using Export-Csv
- Quick Hits: Getting the Local Computer Name
- Quick Hits: Adding Items to an Array and a Look at Performance
- Querying UDP Ports with PowerShell
- Using PowerShell to Query Web Site Information
- Setting up Local Administrator Password Solution (LAPS)
- PowerShell and Excel: Adding Some Formatting To Your Report
- List All Files Regardless of 260 Character Path Restriction Using PowerShell and Robocopy
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: excel
PowerShell and Excel: Creating Your Initial Report
One of the most common methods to generating a report (at least for me) is to write out the data to a CSV file using Export-CSV. While this is a simple and effective method of getting most data out to … Continue reading
Posted in Excel, Office, powershell
Tagged com object, excel, office, Powershell, report
24 Comments
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
