ImportExcel

5.4.2

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.4.2

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name ImportExcel -Version 5.4.2

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

Owners

DougFinke

Copyright

Package Details

Author(s)

Douglas Finke

Functions

Import-Excel ConvertFrom-ExcelSheet Export-MultipleExcelSheets WorksheetArgumentCompleter Add-ConditionalFormatting DoChart BarChart PieChart LineChart ColumnChart ColorCompletion Convert-XlRangeToImage Compare-WorkSheet ConvertFrom-ExcelData ConvertFrom-ExcelToSQLInsert ConvertTo-ExcelXlsx Copy-ExcelWorkSheet Export-Excel Add-WorkSheet Select-Worksheet Add-ExcelName Add-ExcelTable Export-ExcelSheet Export-StocksToExcel 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 Add-ExcelChart New-PSItem Open-ExcelPackage Close-ExcelPackage Pivot Add-PivotTable New-PivotTableDefinition Send-SQLDataToExcel Set-CellStyle Set-ExcelColumn Set-ExcelRow Set-ExcelRange NumberFormatCompletion Expand-NumberFormat Import-USPS Import-UPS Update-FirstObjectProperties

Dependencies

This module has no dependencies.

FileList

ImportExcel.nuspec
AddConditionalFormatting.ps1
azure-pipelines.yml
Charting.ps1
ColorCompletion.ps1
compare-worksheet.ps1
ConvertExcelToImageFile.ps1
ConvertFromExcelData.ps1
ConvertFromExcelToSQLInsert.ps1
ConvertToExcelXlsx.ps1
Copy-ExcelWorkSheet.ps1
DoTests.ps1
EPPlus.dll
Export-charts.ps1
Export-Excel.ps1
Export-ExcelSheet.ps1
Export-StocksToExcel.ps1
filelist.txt
Get-ExcelColumnName.ps1
Get-ExcelSheetInfo.ps1
Get-ExcelWorkbookInfo.ps1
Get-HtmlTable.ps1
Get-Range.ps1
Get-XYRange.ps1
GetExcelTable.ps1
Import-Html.ps1
ImportExcel.psd1
ImportExcel.psm1
ImportExcel.Tests.ps1
InferData.ps1
Install.ps1
InstallModule.ps1
Invoke-Sum.ps1
Join-Worksheet.ps1
LICENSE.txt
LoadPSD1.ps1
Merge-worksheet.ps1
New-ConditionalFormattingIconSet.ps1
New-ConditionalText.ps1
New-ExcelChart.ps1
New-PSItem.ps1
Old_Export-Excel.Tests.ps1
Open-ExcelPackage.ps1
Pivot.ps1
PivotTable.ps1
plot.ps1
PublishToGallery.ps1
README.md
RemoveWorksheet.ps1
Send-SqlDataToExcel.ps1
Set-CellStyle.ps1
Set-Column.ps1
Set-Row.ps1
SetFormat.ps1
TrackingUtils.ps1
Update-FirstObjectProperties.ps1
__tests__\Compare-WorkSheet.tests.ps1
__tests__\ConvertFromExcelToSQLInsert.tests.ps1
__tests__\Copy-ExcelWorksheet.Tests.ps1
__tests__\Export-Excel.Tests.ps1
__tests__\ExtraLongCmd.tests.ps1
__tests__\First10Races.csv
__tests__\First10Races.tests.ps1
__tests__\FunctionAlias.tests.ps1
__tests__\ImportExcelFileList.tests.ps1
__tests__\Join-Worksheet.tests.ps1
__tests__\PasswordProtection.ps1
__tests__\RangePassing.ps1
__tests__\Set-Row_Set-Column-SetFormat.tests.ps1
__tests__\ImportExcelTests\LargerFile.xlsx
__tests__\ImportExcelTests\Simple.tests.ps1
__tests__\ImportExcelTests\Simple.xlsx

Version History

Version	Downloads	Last updated
7.8.10	15,838,854	10/21/2024
7.8.9	3,240,142	5/18/2024
7.8.8	56,170	5/13/2024
7.8.6	1,740,113	10/12/2023
7.8.5	686,927	6/14/2023
7.8.4	947,817	12/11/2022
7.8.3	95,285	11/20/2022
7.8.2	87,481	10/22/2022
7.8.1	177,928	9/3/2022
7.8.0	123,621	7/16/2022
7.7.0	24,215	7/4/2022
7.6.0	39,616	6/17/2022
7.5.3	55,824	5/30/2022
7.5.2	71,826	5/4/2022
7.5.1	3,796	5/3/2022
7.5.0	9,496	4/30/2022
7.4.2	32,040	4/19/2022
7.4.1	309,683	12/11/2021
7.4.0	42,073	11/20/2021
7.3.1	12,927	11/13/2021
7.3.0	107,984	9/14/2021
7.2.2	61,409	7/30/2021
7.2.1	7,440	7/24/2021
7.2.0	559	7/24/2021
7.1.2	120,116	5/8/2021
7.1.1	291,421	7/11/2020
7.1.0	173,945	3/21/2020
7.0.1	321,457	12/21/2019
7.0.0	11,379	12/7/2019
6.5.3	11,849	11/23/2019
6.5.2	12,122	11/2/2019
6.5.1	28,245	8/31/2019
6.5.0	1,510	8/28/2019
6.2.4	3,650	8/21/2019
6.2.3	12,418	7/24/2019
6.2.2	13,322	7/5/2019
6.2.1	7,741	6/18/2019
6.2.0	2,822	6/12/2019
6.1.0	17,972	5/26/2019
6.0.0	24,517	4/12/2019
5.4.5	21,685	3/2/2019
5.4.4	21,853	1/5/2019
5.4.3	1,980	12/30/2018
5.4.2 (current version)	18,264	12/8/2018
5.4.0	16,946	11/3/2018
5.3.4	18,557	10/4/2018
5.3.3	476	10/3/2018
5.3.2	3,920	9/20/2018
5.3.1	386	9/20/2018
5.3.0	442	9/19/2018
5.2.0	13,857	8/18/2018
5.1.1	8,537	8/2/2018
5.1.0	2,008	7/30/2018
5.0.1	20,901	6/27/2018
5.0.0	26,746	6/15/2018
4.0.13	13,207	4/22/2018
4.0.12	2,552	4/10/2018
4.0.11	2,304	3/31/2018
4.0.10	3,270	3/15/2018
4.0.9	29,043	1/25/2018
4.0.8	26,412	11/25/2017
4.0.7	242	11/24/2017
4.0.6	227	11/24/2017
4.0.5	275	11/23/2017
4.0.4	2,911	10/30/2017
4.0.3	1,295	10/20/2017
4.0.2	2,015	10/3/2017
4.0.1	463	9/30/2017
4.0.0	1,883	9/12/2017
3.0.1	6,628	7/3/2017
3.0.0	1,487	6/16/2017
2.4.0	8,838	2/22/2017
2.3.0	653	2/14/2017
2.2.10	2,339	12/22/2016
2.2.9	2,885	10/1/2016
2.2.8	1,149	9/1/2016
2.2.7	1,915	7/1/2016
2.2.6	237	7/1/2016
2.2.5	991	6/1/2016
2.2.4	958	4/30/2016
2.2.3	455	4/18/2016
2.2.2	522	3/31/2016
2.2.1	305	3/26/2016
2.2.0	310	3/18/2016
2.1.3	440	3/2/2016
2.1.2	336	2/24/2016
2.1.1	251	2/24/2016
2.1	300	2/22/2016
2.0.1	243	2/22/2016
2.0	333	2/21/2016
1.99	290	2/18/2016
1.98	469	1/29/2016
1.97	337	1/18/2016
1.96	243	1/15/2016
1.94	256	1/14/2016
1.92	304	1/6/2016
1.91	245	1/6/2016
1.90	874	10/20/2015
1.83	1,643	10/15/2015
1.82	302	10/1/2015
1.81	256	9/30/2015
1.8	261	9/25/2015
1.7	296	9/11/2015
1.6	289	8/21/2015
1.5	321	7/9/2015
1.4	300	6/18/2015
1.3	285	5/25/2015
1.2	258	5/18/2015
1.1	266	5/17/2015
1.0	487	5/4/2015

Show less