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

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