Showing results for May 2018 - Page 2 of 2 - Scripting Blog [archived]

May 9, 2018
Post comments count3
Post likes count0

Get certificate info into a CSV by using PowerShell

Doctor Scripto
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 here, with...

Scripting Guy!Windows PowerShellguest blogger
May 8, 2018
Post comments count0
Post likes count1

Grabbing Excel (XLSX) values with PowerShell

Kory Thacher
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 workin...

Microsoft ExcelPowerShellkoryt