Scripting Blog [archived]

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

Grabbing Excel (XLSX) values with PowerShell

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

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 a PowerShell Module to Easily Export Excel Data to CSV

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

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