Import Excel PowerShell Module
PowerShell module to import/export Excel spreadsheets, without Excel
PowerShell Gallery
Find-Module
Find-Module ImportExcel
or
Find-Module ImportExcel -AllVersions
Install-Module
Install-Module -Name ImportExcel
or
Find-Module ImportExcel | Install-Module
Find-Module ImportExcel | Install-Module
Get-Module
Get-Module -ListAvailable ImportExcel
or
Get-Module -ListAvailable ImportExcel | Format-List
Get-Command
Get-Command -Module ImportExcelGet 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)
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)
Useful Link