ImportExcel

5.1.0

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

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name ImportExcel -RequiredVersion 5.1.0

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Author(s)

Douglas Finke

Copyright

Package Details

Owners

DougFinke

Functions

Import-Excel ConvertFrom-ExcelSheet Export-MultipleExcelSheets Add-ConditionalFormatting DoChart BarChart PieChart LineChart ColumnChart ColorCompletion Convert-XlRangeToImage Compare-WorkSheet ConvertFrom-ExcelData ConvertFrom-ExcelToSQLInsert ConvertTo-ExcelXlsx Copy-ExcelWorkSheet Export-Excel New-PivotTableDefinition Add-WorkSheet Add-PivotTable Add-ExcelChart Export-ExcelSheet Get-ExcelColumnName Get-ExcelSheetInfo Get-ExcelWorkbookInfo Get-HtmlTable Get-Range Get-XYRange Import-Html Test-String Test-Date Test-Boolean Test-Number Test-Integer Invoke-AllTests Invoke-Sum Join-Worksheet Merge-Worksheet Merge-MultipleSheets New-ConditionalFormattingIconSet New-ConditionalText New-ExcelChartDefinition New-PSItem Open-ExcelPackage Close-ExcelPackage Pivot Send-SQLDataToExcel Set-CellStyle Set-Column Set-Row Set-Format Import-USPS Import-UPS Update-FirstObjectProperties

Dependencies

This module has no dependencies.

FileList

Version History

Version	Downloads	Last updated
7.4.1	56,400	12/11/2021
7.4.0	34,758	11/20/2021
7.3.1	12,621	11/13/2021
7.3.0	104,801	9/14/2021
7.2.2	59,736	7/30/2021
7.2.1	6,993	7/24/2021
7.2.0	230	7/24/2021
7.1.2	116,267	5/8/2021
7.1.1	271,812	7/11/2020
7.1.0	135,209	3/21/2020
7.0.1	71,491	12/21/2019
7.0.0	10,087	12/7/2019
6.5.3	8,098	11/23/2019
6.5.2	10,340	11/2/2019
6.5.1	27,898	8/31/2019
6.5.0	1,299	8/28/2019
6.2.4	3,429	8/21/2019
6.2.3	12,139	7/24/2019
6.2.2	12,829	7/5/2019
6.2.1	7,509	6/18/2019
6.2.0	2,631	6/12/2019
6.1.0	17,713	5/26/2019
6.0.0	22,202	4/12/2019
5.4.5	19,341	3/2/2019
5.4.4	21,020	1/5/2019
5.4.3	1,797	12/30/2018
5.4.2	13,350	12/8/2018
5.4.0	15,575	11/3/2018
5.3.4	17,097	10/4/2018
5.3.3	276	10/3/2018
5.3.2	3,741	9/20/2018
5.3.1	135	9/20/2018
5.3.0	253	9/19/2018
5.2.0	13,353	8/18/2018
5.1.1	5,933	8/2/2018
5.1.0 (current version)	1,356	7/30/2018
5.0.1	13,126	6/27/2018
5.0.0	8,205	6/15/2018
4.0.13	12,900	4/22/2018
4.0.12	2,338	4/10/2018
4.0.11	2,084	3/31/2018
4.0.10	3,049	3/15/2018
4.0.9	28,829	1/25/2018
4.0.8	15,677	11/25/2017
4.0.7	57	11/24/2017
4.0.6	35	11/24/2017
4.0.5	90	11/23/2017
4.0.4	2,679	10/30/2017
4.0.3	1,071	10/20/2017
4.0.2	1,789	10/3/2017
4.0.1	244	9/30/2017
4.0.0	1,604	9/12/2017
3.0.1	6,372	7/3/2017
3.0.0	1,235	6/16/2017
2.4.0	8,418	2/22/2017
2.3.0	441	2/14/2017
2.2.10	2,111	12/22/2016
2.2.9	2,666	10/1/2016
2.2.8	925	9/1/2016
2.2.7	1,693	7/1/2016
2.2.6	24	7/1/2016
2.2.5	763	6/1/2016
2.2.4	734	4/30/2016
2.2.3	239	4/18/2016
2.2.2	309	3/31/2016
2.2.1	92	3/26/2016
2.2.0	95	3/18/2016
2.1.3	220	3/2/2016
2.1.2	120	2/24/2016
2.1.1	32	2/24/2016
2.1	66	2/22/2016
2.0.1	26	2/22/2016
2.0	63	2/21/2016
1.99	59	2/18/2016
1.98	236	1/29/2016
1.97	123	1/18/2016
1.96	26	1/15/2016
1.94	41	1/14/2016
1.92	81	1/6/2016
1.91	21	1/6/2016
1.90	620	10/20/2015
1.83	35	10/15/2015
1.82	81	10/1/2015
1.81	26	9/30/2015
1.8	32	9/25/2015
1.7	65	9/11/2015
1.6	59	8/21/2015
1.5	92	7/9/2015
1.4	72	6/18/2015
1.3	51	5/25/2015
1.2	27	5/18/2015
1.1	28	5/17/2015
1.0	163	5/4/2015

Show less