ImportExcel

ImportExcel  6.2.1

This PowerShell Module allows you to read and write Excel files without installing MS Excel on your machine.

With this module we can create Tables, Pivot Tables, Charts and much more has just become a lot easier.

Search the latest Importexcel module in Powershellgallary, then install
PS C:\> Find-Module Importexcel | Install-Module

Install module
PS C:\> Install-Module -Name ImportExcel

Check installed module with path
PS C:\> Get-Module -ListAvailable Importexcel | Format-list

Get the command/function details
PS C:\> Get-Command -Module ImportExcel


Get the example of Export-Excel
PS C:\> help Export-Excel -Examples

Export the windows services in excel

PS C:\> Get-Service | Export-Excel C:\PS\service.xlsx -Show -AutoSize -AutoFilter

or

PS C:\> Get-Service | Select-Object Status, Name, DisplayName,StartType | Export-Excel -Path c:\ps\services.xlsx -Show -AutoSize -AutoFilter -FreezeTopRow -ConditionalText (New-ConditionalText stop)