Learn to Automate Excel like a Pro with PowerShell

added by DotNetKicks
8/30/2019 3:09:56 PM

1 Kicks, 153 Views

Everyone wants to produce slick looking reports. Want to impress management? Use PowerShell and Install-Module -Name ImportExcel. Here's Get-Process, Get-Service and a directory listing all in one Excel spreadsheet format as a report, plus, it is interactive. The Export-Excel PowerShell function works on the same way you expect Out-GridView to work, except, you get an Excel worksheet when you're done.