ImportExcel

6.5.3

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 6.5.3

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

Install-PSResource -Name ImportExcel -Version 6.5.3

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

Add-ConditionalFormatting Add-ExcelChart Add-ExcelDataValidationRule Add-ExcelName Add-ExcelTable Add-PivotTable Add-WorkSheet BarChart Close-ExcelPackage ColumnChart Compare-WorkSheet Convert-XlRangeToImage ConvertFrom-ExcelData ConvertFrom-ExcelSheet ConvertFrom-ExcelToSQLInsert ConvertTo-ExcelXlsx Copy-ExcelWorkSheet DoChart Expand-NumberFormat Export-Excel Export-ExcelSheet Export-MultipleExcelSheets Get-ExcelColumnName Get-ExcelSheetInfo Get-ExcelWorkbookInfo Get-HtmlTable Get-Range Get-XYRange Import-Excel Import-Html Import-UPS Import-USPS Invoke-AllTests Invoke-Sum Join-Worksheet LineChart Merge-MultipleSheets Merge-Worksheet New-ConditionalFormattingIconSet New-ConditionalText New-ExcelChartDefinition New-ExcelStyle New-PivotTableDefinition New-Plot New-PSItem NumberFormatCompletion Open-ExcelPackage PieChart Pivot Remove-WorkSheet Select-Worksheet Send-SQLDataToExcel Set-CellStyle Set-ExcelColumn Set-ExcelRange Set-ExcelRow Set-WorkSheetProtection Test-Boolean Test-Date Test-Integer Test-Number Test-String Update-FirstObjectProperties

Dependencies

This module has no dependencies.

FileList

ImportExcel.nuspec
AddConditionalFormatting.ps1
AddDataValidation.ps1
Charting.ps1
ColorCompletion.ps1
Compare-WorkSheet.ps1
ConvertExcelToImageFile.ps1
ConvertFromExcelData.ps1
ConvertFromExcelToSQLInsert.ps1
ConvertToExcelXlsx.ps1
Copy-ExcelWorkSheet.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
InferData.ps1
Install.ps1
InstallModule.ps1
Invoke-Sum.ps1
Join-Worksheet.ps1
LICENSE.txt
Merge-Worksheet.ps1
New-ConditionalFormattingIconSet.ps1
New-ConditionalText.ps1
New-ExcelChart.ps1
New-PSItem.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
Set-WorkSheetProtection.ps1
SetFormat.ps1
test.xlsx
TrackingUtils.ps1
Update-FirstObjectProperties.ps1
CI\CI.ps1
CI\InstallPowerShell.ps1
CI\Publish.ps1
images\CellFormatting.png
images\ChartTrendlines.png
images\ConditionalDates.gif
images\ConditionalText.gif
images\ConditionalText2.gif
images\CustomReport.png
images\ExportMultiple.gif
images\exportstockinfo.gif
images\FilterFreezeBold.gif
images\fluent.gif
images\Formatting.png
images\GetExcelSheetInfo.png
images\GroupingNumeric.png
images\GTConditional.png
images\ImportHtml.gif
images\ImportHtmlSecretaryOfState.gif
images\ImproveNowDefaults.png
images\MonthlyTemperaturesWithDatabar.png
images\MultiplePivotTables.png
images\MultiplePivotTablesInAWorkbook.png
images\MultiSeries.gif
images\MultiSeries.png
images\NewExcelStyle.png
images\PassThru.png
images\PivotAsColumns.png
images\PivotAsRows.png
images\PivotTableFilter.png
images\PivotTablesAndCharts.png
images\plot.gif
images\plotNew.gif
images\PSPlot.gif
images\SalesDataWithDatabar.png
images\ScriptAnalyzerReport.png
images\Sparklines.png
images\testimonial.png
images\Title.png
images\Tracking.gif
images\TryImportExcel.gif
images\XLToPesterForRestAPI.gif
images\XLToPesterForRestAPIAndOutput.gif
spikes\ConvertFrom-ExcelColumnName.ps1
Testimonials\t1.png
__tests__\AddTrendlinesToAChart.tests.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__\Get-ExcelColumnName.Test.ps1
__tests__\ImportExcelFileList.tests.ps1
__tests__\ImportExcelHeaderName.tests.ps1
__tests__\InputItemParameter.tests.ps1
__tests__\Join-Worksheet.tests.ps1
__tests__\PasswordProtection.tests.ps1
__tests__\Path.tests.ps1
__tests__\ProtectWorksheet.tests.ps1
__tests__\RangePassing.ps1
__tests__\Remove-WorkSheet.tests.ps1
__tests__\Set-Row_Set-Column-SetFormat.tests.ps1
__tests__\testRelative.xlsx
__tests__\Validation.tests.ps1
__tests__\ImportExcelTests\LargerFile.xlsx
__tests__\ImportExcelTests\Simple.tests.ps1
__tests__\ImportExcelTests\Simple.xlsx
__tests__\ImportExcelTests\TestData1.xlsx
__tests__\ImportExcelTests\TestData2.xlsx
__tests__\Samples\Get-CimInstanceDisk.xml
__tests__\Samples\Get-CimInstanceNetAdapter.xml
__tests__\Samples\Get-Process.xml
__tests__\Samples\Get-Service.xml
__tests__\Samples\Samples.ps1

Version History

Version	Downloads	Last updated
7.8.10	13,712,662	10/21/2024
7.8.9	3,103,305	5/18/2024
7.8.8	55,507	5/13/2024
7.8.6	1,721,406	10/12/2023
7.8.5	676,913	6/14/2023
7.8.4	942,800	12/11/2022
7.8.3	95,268	11/20/2022
7.8.2	87,333	10/22/2022
7.8.1	175,696	9/3/2022
7.8.0	123,501	7/16/2022
7.7.0	23,707	7/4/2022
7.6.0	39,589	6/17/2022
7.5.3	55,724	5/30/2022
7.5.2	71,751	5/4/2022
7.5.1	3,785	5/3/2022
7.5.0	9,488	4/30/2022
7.4.2	32,022	4/19/2022
7.4.1	308,727	12/11/2021
7.4.0	41,886	11/20/2021
7.3.1	12,916	11/13/2021
7.3.0	107,965	9/14/2021
7.2.2	61,350	7/30/2021
7.2.1	7,422	7/24/2021
7.2.0	549	7/24/2021
7.1.2	120,060	5/8/2021
7.1.1	291,066	7/11/2020
7.1.0	171,955	3/21/2020
7.0.1	320,834	12/21/2019
7.0.0	11,344	12/7/2019
6.5.3 (current version)	11,640	11/23/2019
6.5.2	12,043	11/2/2019
6.5.1	28,231	8/31/2019
6.5.0	1,497	8/28/2019
6.2.4	3,640	8/21/2019
6.2.3	12,407	7/24/2019
6.2.2	13,300	7/5/2019
6.2.1	7,730	6/18/2019
6.2.0	2,814	6/12/2019
6.1.0	17,963	5/26/2019
6.0.0	24,491	4/12/2019
5.4.5	21,599	3/2/2019
5.4.4	21,844	1/5/2019
5.4.3	1,973	12/30/2018
5.4.2	18,134	12/8/2018
5.4.0	16,931	11/3/2018
5.3.4	18,549	10/4/2018
5.3.3	469	10/3/2018
5.3.2	3,914	9/20/2018
5.3.1	379	9/20/2018
5.3.0	436	9/19/2018
5.2.0	13,850	8/18/2018
5.1.1	8,505	8/2/2018
5.1.0	1,991	7/30/2018
5.0.1	20,650	6/27/2018
5.0.0	25,656	6/15/2018
4.0.13	13,189	4/22/2018
4.0.12	2,545	4/10/2018
4.0.11	2,298	3/31/2018
4.0.10	3,263	3/15/2018
4.0.9	29,035	1/25/2018
4.0.8	26,389	11/25/2017
4.0.7	235	11/24/2017
4.0.6	220	11/24/2017
4.0.5	268	11/23/2017
4.0.4	2,902	10/30/2017
4.0.3	1,284	10/20/2017
4.0.2	2,008	10/3/2017
4.0.1	457	9/30/2017
4.0.0	1,875	9/12/2017
3.0.1	6,621	7/3/2017
3.0.0	1,477	6/16/2017
2.4.0	8,831	2/22/2017
2.3.0	647	2/14/2017
2.2.10	2,331	12/22/2016
2.2.9	2,879	10/1/2016
2.2.8	1,142	9/1/2016
2.2.7	1,908	7/1/2016
2.2.6	231	7/1/2016
2.2.5	984	6/1/2016
2.2.4	952	4/30/2016
2.2.3	448	4/18/2016
2.2.2	515	3/31/2016
2.2.1	299	3/26/2016
2.2.0	303	3/18/2016
2.1.3	432	3/2/2016
2.1.2	329	2/24/2016
2.1.1	245	2/24/2016
2.1	293	2/22/2016
2.0.1	235	2/22/2016
2.0	321	2/21/2016
1.99	283	2/18/2016
1.98	463	1/29/2016
1.97	330	1/18/2016
1.96	236	1/15/2016
1.94	250	1/14/2016
1.92	297	1/6/2016
1.91	238	1/6/2016
1.90	866	10/20/2015
1.83	1,405	10/15/2015
1.82	296	10/1/2015
1.81	249	9/30/2015
1.8	255	9/25/2015
1.7	289	9/11/2015
1.6	281	8/21/2015
1.5	315	7/9/2015
1.4	293	6/18/2015
1.3	278	5/25/2015
1.2	250	5/18/2015
1.1	258	5/17/2015
1.0	475	5/4/2015

Show less