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
Owners
Copyright
c 2019 All rights reserved.
Package Details
Author(s)
- Douglas Finke
Tags
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.6 | 1,499,790 | 10/12/2023 |
| 7.8.5 | 609,931 | 6/14/2023 |
| 7.8.4 | 877,661 | 12/11/2022 |
| 7.8.3 | 92,811 | 11/20/2022 |
| 7.8.2 | 86,232 | 10/22/2022 |
| 7.8.1 | 161,605 | 9/3/2022 |
| 7.8.0 | 122,718 | 7/16/2022 |
| 7.7.0 | 22,678 | 7/4/2022 |
| 7.6.0 | 39,345 | 6/17/2022 |
| 7.5.3 | 54,778 | 5/30/2022 |
| 7.5.2 | 70,967 | 5/4/2022 |
| 7.5.1 | 3,754 | 5/3/2022 |
| 7.5.0 | 9,428 | 4/30/2022 |
| 7.4.2 | 31,940 | 4/19/2022 |
| 7.4.1 | 293,981 | 12/11/2021 |
| 7.4.0 | 39,280 | 11/20/2021 |
| 7.3.1 | 12,857 | 11/13/2021 |
| 7.3.0 | 106,893 | 9/14/2021 |
| 7.2.2 | 60,724 | 7/30/2021 |
| 7.2.1 | 7,335 | 7/24/2021 |
| 7.2.0 | 490 | 7/24/2021 |
| 7.1.2 | 119,153 | 5/8/2021 |
| 7.1.1 | 281,757 | 7/11/2020 |
| 7.1.0 | 152,728 | 3/21/2020 |
| 7.0.1 | 170,325 | 12/21/2019 |
| 7.0.0 | 10,887 | 12/7/2019 |
| 6.5.3 (current version) | 9,835 | 11/23/2019 |
| 6.5.2 | 11,134 | 11/2/2019 |
| 6.5.1 | 28,178 | 8/31/2019 |
| 6.5.0 | 1,476 | 8/28/2019 |
| 6.2.4 | 3,625 | 8/21/2019 |
| 6.2.3 | 12,388 | 7/24/2019 |
| 6.2.2 | 13,279 | 7/5/2019 |
| 6.2.1 | 7,709 | 6/18/2019 |
| 6.2.0 | 2,799 | 6/12/2019 |
| 6.1.0 | 17,920 | 5/26/2019 |
| 6.0.0 | 23,311 | 4/12/2019 |
| 5.4.5 | 20,666 | 3/2/2019 |
| 5.4.4 | 21,375 | 1/5/2019 |
| 5.4.3 | 1,960 | 12/30/2018 |
| 5.4.2 | 15,789 | 12/8/2018 |
| 5.4.0 | 16,475 | 11/3/2018 |
| 5.3.4 | 18,523 | 10/4/2018 |
| 5.3.3 | 446 | 10/3/2018 |
| 5.3.2 | 3,904 | 9/20/2018 |
| 5.3.1 | 327 | 9/20/2018 |
| 5.3.0 | 424 | 9/19/2018 |
| 5.2.0 | 13,784 | 8/18/2018 |
| 5.1.1 | 8,267 | 8/2/2018 |
| 5.1.0 | 1,873 | 7/30/2018 |
| 5.0.1 | 16,598 | 6/27/2018 |
| 5.0.0 | 15,451 | 6/15/2018 |
| 4.0.13 | 13,135 | 4/22/2018 |
| 4.0.12 | 2,535 | 4/10/2018 |
| 4.0.11 | 2,284 | 3/31/2018 |
| 4.0.10 | 3,249 | 3/15/2018 |
| 4.0.9 | 29,013 | 1/25/2018 |
| 4.0.8 | 23,865 | 11/25/2017 |
| 4.0.7 | 227 | 11/24/2017 |
| 4.0.6 | 206 | 11/24/2017 |
| 4.0.5 | 257 | 11/23/2017 |
| 4.0.4 | 2,888 | 10/30/2017 |
| 4.0.3 | 1,268 | 10/20/2017 |
| 4.0.2 | 1,996 | 10/3/2017 |
| 4.0.1 | 440 | 9/30/2017 |
| 4.0.0 | 1,827 | 9/12/2017 |
| 3.0.1 | 6,597 | 7/3/2017 |
| 3.0.0 | 1,442 | 6/16/2017 |
| 2.4.0 | 8,778 | 2/22/2017 |
| 2.3.0 | 637 | 2/14/2017 |
| 2.2.10 | 2,319 | 12/22/2016 |
| 2.2.9 | 2,865 | 10/1/2016 |
| 2.2.8 | 1,129 | 9/1/2016 |
| 2.2.7 | 1,897 | 7/1/2016 |
| 2.2.6 | 223 | 7/1/2016 |
| 2.2.5 | 972 | 6/1/2016 |
| 2.2.4 | 937 | 4/30/2016 |
| 2.2.3 | 433 | 4/18/2016 |
| 2.2.2 | 506 | 3/31/2016 |
| 2.2.1 | 291 | 3/26/2016 |
| 2.2.0 | 293 | 3/18/2016 |
| 2.1.3 | 422 | 3/2/2016 |
| 2.1.2 | 321 | 2/24/2016 |
| 2.1.1 | 235 | 2/24/2016 |
| 2.1 | 270 | 2/22/2016 |
| 2.0.1 | 227 | 2/22/2016 |
| 2.0 | 290 | 2/21/2016 |
| 1.99 | 268 | 2/18/2016 |
| 1.98 | 450 | 1/29/2016 |
| 1.97 | 321 | 1/18/2016 |
| 1.96 | 226 | 1/15/2016 |
| 1.94 | 241 | 1/14/2016 |
| 1.92 | 285 | 1/6/2016 |
| 1.91 | 223 | 1/6/2016 |
| 1.90 | 836 | 10/20/2015 |
| 1.83 | 238 | 10/15/2015 |
| 1.82 | 287 | 10/1/2015 |
| 1.81 | 238 | 9/30/2015 |
| 1.8 | 243 | 9/25/2015 |
| 1.7 | 277 | 9/11/2015 |
| 1.6 | 273 | 8/21/2015 |
| 1.5 | 304 | 7/9/2015 |
| 1.4 | 280 | 6/18/2015 |
| 1.3 | 268 | 5/25/2015 |
| 1.2 | 237 | 5/18/2015 |
| 1.1 | 245 | 5/17/2015 |
| 1.0 | 422 | 5/4/2015 |