Tag Archives: excel

Quick Hits: Finding all Hyperlinks in an Excel Workbook

Posted on July 1, 2017 by Boe Prox

Recently, I had the need to pull out all of the hyperlinks from an excel worksheet that was given to me. While I could have gone the manual approach by looking through all of the cells in the worksheet and … Continue reading →

Posted in powershell | Tagged , , | 2 Comments

Quick Hits: Adding a Hyperlink to Excel Spreadsheet

Posted on October 2, 2015 by Boe Prox

I had a need a while back to add a few hyperlinks to a couple different excel cells that could be clicked on to take the user either to another portion of the excel spreadsheet or to open up a … Continue reading →

Posted in powershell | Tagged , , | Leave a comment

Trend Reporting using PowerShell and SQL on MCPMag.com

Posted on February 1, 2015 by Boe Prox

I have a new series of articles that will be focusing on trend reporting using PowerShell and SQL. Be sure to check them out and let me know what you think! PowerShell Trend Reporting, Part 1: Data Gathering PowerShell Trend … Continue reading →

Posted in powershell | Tagged , , , , | 4 Comments

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