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

May 9, 2018
3
0

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
0
1

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