Tag Archives: excel

PowerShell and Excel: Creating Your Initial Report

Posted on December 16, 2012 by

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 , , , , | 24 Comments

Converting CSV file or files into an Excel workbook

Posted on September 4, 2010 by

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 →

Posted in powershell, scripts | Tagged , , | 34 Comments