Tag Archives: excel

Quick Hits: Finding all Hyperlinks in an Excel Workbook

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 , , | Leave a comment

Quick Hits: Adding a Hyperlink to Excel Spreadsheet

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

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

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

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