Category Archives: Office

PowerShell and Excel: Adding a Chart and Header Filter to a Report

Posted on December 24, 2012 by Boe Prox

In the previous articles I have shown you how to use Excel with PowerShell to make a nice disk space report, complete with color coded rows for disks that are running low on space. I am now going to take … Continue reading →

Posted in Excel, Office, powershell | Tagged , , , | 13 Comments

PowerShell and Excel: Adding Some Formatting To Your Report

Posted on December 20, 2012 by Boe Prox

Continuing from my previous Excel article, I will now take the report that I created and make more pleasant to the eyes and really show why this is different from just piping the output into Export-CSV to a CSV file. … Continue reading →

Posted in Excel, Office, powershell | Tagged , , | 12 Comments

PowerShell and Excel: Creating Your Initial Report

Posted on December 16, 2012 by Boe Prox

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