PowerShell - 04. Excel

Work with Microsoft excel

PowerShell module to import/export Excel spreadsheets, without Excel. 

Install Module

PS C:\> Install-Module -Name ImportExcel

If you are using PowerShell 5.1 o and PowerShell 6.x, install in both

PowerShell 6.x

PS C:\> Get-Module -ListAvailable ImportExcel | fl

Name              : ImportExcel

Path              : C:\Users\anant.sharma\Documents\PowerShell\Modules\ImportExcel\6.0.0\ImportExcel.psd1

Description       : PowerShell module to import/export Excel spreadsheets, without Excel.

                    Check out the How To Videos

                    https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq

ModuleType        : Script

Version           : 6.0.0

NestedModules     : {}

ExportedFunctions : {Add-ConditionalFormatting, Add-ExcelChart, Add-ExcelDataValidationRule, Add-ExcelName…}

ExportedCmdlets   :

ExportedVariables :

ExportedAliases   : {New-ExcelChart, Set-Column, Set-Format, Set-Row…}

PowerShell 5.1

PS C:\> Get-Module -ListAvailable ImportExcel | fl

Name              : ImportExcel

Path              : C:\Program Files\WindowsPowerShell\Modules\ImportExcel\6.0.0\ImportExcel.psd1

Description       : PowerShell module to import/export Excel spreadsheets, without Excel.

                    Check out the How To Videos

                    https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq

ModuleType        : Script

Version           : 6.0.0

NestedModules     : {}

ExportedFunctions : {Add-ConditionalFormatting, Add-ExcelChart, Add-ExcelDataValidationRule, Add-ExcelName...}

ExportedCmdlets   :

ExportedVariables :

ExportedAliases   : {New-ExcelChart, Set-Column, Set-Format, Set-Row...}

For more details

https://www.powershellgallery.com/packages/ImportExcel/6.0.0