The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Grabbing Excel (XLSX) values with PowerShell

May 8, 2018 May 8, 2018 05/8/18

Kory Thacher

The Goal: Import data from XLSX files conveniently like import-csv lets you do with simpler data. The preamble: Excel is a mainstay of the business world at this point, which means a lot of the data you might have to work with will come at you as an XLSX file or need to be one. This can be a bit annoying when scripting. If we're just ...

The Admin’s First Steps: Capacity Planning Part 3

November 18, 2013 Nov 18, 2013 11/18/13

Doctor Scripto

Summary: Richard Siddaway talks about using Windows PowerShell to create capacity planning reports. (image) Hey, Scripting Guy! I’ve just starting learning Windows PowerShell, and I understand how to use it as a scripting language and shell. I’ve been told to start performing capacity planning for my servers and was wondering...

Use PowerShell to Work with Pictures in Microsoft Excel

August 12, 2011 Aug 12, 2011 08/12/11

Doctor Scripto

Summary: Guest Blogger Robert Robelo shows how to use Windows PowerShell to work with images in Microsoft Excel. Microsoft Scripting Guy Ed Wilson here. Our guest blogger today is Robert Robelo. First, I want to give Robert a chance to tell us a little bit about himself. I live in Nicaragua. I have been an incomplete quadriplegic (...

Use a PowerShell Module to Easily Export Excel Data to CSV

July 21, 2011 Jul 21, 2011 07/21/11

Doctor Scripto

Summary: Learn how to use a Windows PowerShell module to easily import and export Excel data. Microsoft Scripting Guy Ed Wilson here. Jeremy Engel has joined us today to talk about using a Windows PowerShell module to easily import and export Excel data. Take it away, Jeremy! I started coding at the age of 10, writing games in ...

Copy CSV Columns to an Excel Spreadsheet by Using PowerShell

September 9, 2010 Sep 9, 2010 09/9/10

ScriptingGuy1

Summary: Join the Microsoft Scripting Guys as they show you how to copy CSV columns to a Microsoft Excel spreadsheet by using Windows PowerShell. (image) Hey, Scripting Guy! I love comma-separated value (CSV) files. To me, it seems as if that was the best way to store data. It is almost universally accepted and is still widely used...

Scripting Blog [archived]

Microsoft Excel - Scripting Blog [archived]