Scripting Blog [archived]

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

PowerShell - Scripting Blog [archived]

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

View passwords of wireless profiles without using netsh.exe

January 13, 2017 Jan 13, 2017 01/13/17
Doctor Scripto
Ever since the GUI lost the ability to view the password of a wireless profile, I wanted to provide this functionality in PowerShell. A search of the Internet for how to view the password of a Wi-Fi profile returns numerous examples of how to use netsh.exe to accomplish this. I wrote a previous blog post about how to view Wi-Fi profiles, and ...

Visual Studio Code editing features for PowerShell development – Part 2

January 12, 2017 Jan 12, 2017 01/12/17
Doctor Scripto
Summary: Editing features for Visual Studio Code that use the PowerShell extension. Welcome to Part 2 about editing features of Visual Studio Code. Everything that we  examined in Part 1 of this series is about Visual Studio Code editing features that are available without the PowerShell extension installed! They apply to your markdown, JSON...