Scripting Blog

A place to learn about PowerShell and share stories of automation

Microsoft Excel - Scripting 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.  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 how I ...

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