Scripting Blog [archived]

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

May 2018 - Page 2 of 2 - Scripting Blog [archived]

Get certificate info into a CSV by using PowerShell

May 9, 2018 May 9, 2018 05/9/18
Doctor Scripto
Summary: Certificate management is always challenging. Let’s explore how to use PowerShell to export local certificate information to a comma-separated values (CSV) file on Windows 7 (or later) computers. Q: Hey, Scripting Guy! How can I get all my certificate info into a CSV on my Windows computers? —SH A: Hello SH, Patrick Mercier ...

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