ImportExcel
7.5.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
Author(s)
Douglas Finke
Copyright
c 2020 All rights reserved.
Package Details
Owners
Tags
Functions
Add-ConditionalFormatting Add-ExcelChart Add-ExcelDataValidationRule Add-ExcelName Add-ExcelTable Add-PivotTable Add-Worksheet BarChart Close-ExcelPackage ColumnChart Compare-Worksheet Convert-ExcelRangeToImage ConvertFrom-ExcelData ConvertFrom-ExcelSheet ConvertFrom-ExcelToSQLInsert ConvertTo-ExcelXlsx Copy-ExcelWorksheet DoChart Enable-ExcelAutoFilter Enable-ExcelAutofit Expand-NumberFormat Export-Excel Export-ExcelSheet Get-ExcelColumnName Get-ExcelFileSummary Get-ExcelSheetDimensionAddress Get-ExcelSheetInfo Get-ExcelWorkbookInfo Get-HtmlTable Get-Range Get-XYRange Import-Excel Import-Html Import-UPS Import-USPS Invoke-AllTests Invoke-ExcelQuery Invoke-Sum Join-Worksheet LineChart Merge-MultipleSheets Merge-Worksheet New-ConditionalFormattingIconSet New-ConditionalText New-ExcelChartDefinition New-ExcelStyle New-PivotTableDefinition New-Plot New-PSItem Open-ExcelPackage PieChart Pivot Read-Clipboard Read-OleDbData ReadClipboardImpl 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
- Examples\Index - Music.ps1
- changelog.md
- Examples\New-PSItem.ps1
- images\MonthlyTemperaturesWithDatabar.png
- InferData\test-boolean.md
- Public\Copy-ExcelWorksheet.ps1
- Public\New-ExcelChartDefinition.ps1
- Examples\Charts\ChartAndTrendlines.ps1
- Examples\ConditionalFormatting\Highlight-Yesterday.ps1
- Examples\FormatCellStyles\ApplyStyle.ps1
- Examples\JoinWorksheet\NorthSales.csv
- Examples\OpenExcelPackage\EnableFeatures.ps1
- Examples\SQL+FillColumns+Pivot\Example.ps1
- EPPlus.dll
- Examples\Pester-To-XLSx.ps1
- images\MultiplePivotTables.png
- InferData\test-date.md
- Public\Enable-ExcelAutoFilter.ps1
- Public\New-ExcelStyle.ps1
- Examples\Charts\Multiplecharts.png
- Examples\ConditionalFormatting\HighlightDuplicates.ps1
- Examples\FormatCellStyles\PassInScriptBlock.ps1
- Examples\JoinWorksheet\SouthSales.csv
- Examples\OutTabulator\demo.txt
- Examples\SQL+FillColumns+Pivot\Example2.ps1
- Export-charts.ps1
- Examples\PsGallery.ps1
- images\MultiplePivotTablesInAWorkbook.png
- InferData\test-integer.md
- Public\Enable-ExcelAutofit.ps1
- Public\New-PivotTableDefinition.ps1
- Examples\Charts\MultipleCharts.ps1
- Examples\ConditionalFormatting\MonthlyTemperatuesDatabar.ps1
- Examples\Freeze\FreezePane.ps1
- Examples\JoinWorksheet\WestSales.csv
- Examples\OutTabulator\start-demo.ps1
- Examples\Stocks\Get-StockInfo.ps1
- Export-StocksToExcel.ps1
- Examples\Subtotals.ps1
- images\MultiSeries.gif
- InferData\test-number.md
- Public\Expand-NumberFormat.ps1
- Public\New-PSItem.ps1
- Examples\Charts\MultiSeries.ps1
- Examples\ConditionalFormatting\RangeFormatting.ps1
- Examples\GenerateData\GenDataForCustomReport.ps1
- Examples\JustCharts\CentralLimitTheorem.ps1
- Examples\OutTabulator\targetout.html
- Examples\Stocks\GetStocksAvgTotVol.ps1
- GetExcelTable.ps1
- Examples\TryMultiplePivotTables.ps1
- images\MultiSeries.png
- InferData\test-string.md
- Public\Export-Excel.ps1
- Public\Open-ExcelPackage.ps1
- Examples\Charts\MultiSeries1.ps1
- Examples\ConditionalFormatting\SalesReportWithDatabar.ps1
- Examples\Grouping\First10Races.csv
- Examples\JustCharts\PieChartHandles.ps1
- Examples\OutTabulator\tryConvertFromExcel.ps1
- Examples\Styles\MultipleStyles.ps1
- Examples\TryMultiplePivotTablesFromOneSheet.ps1
- images\NewExcelStyle.png
- Pivot\pivot.md
- Public\Get-ExcelColumnName.ps1
- Public\Read-Clipboard.ps1
- Examples\Charts\NumberOfVisitors.ps1
- Examples\ConditionalFormatting\TextComparisons.ps1
- Examples\Grouping\GroupDate.ps1
- Examples\JustCharts\PieChartPM.ps1
- Examples\PassThru\sales.csv
- Examples\Styles\NewExcelStyle.ps1
- ImportExcel.psd1
- FAQ\How to Create an Empty Excel File.md
- images\PassThru.png
- Pivot\Pivot.ps1
- Public\Get-ExcelFileSummary.ps1
- Public\Read-OleDbData.ps1
- Examples\Charts\plot.ps1
- Examples\ConditionalFormatting\Top10-DataBar-TwoColorScale.ps1
- Examples\Grouping\GroupNumeric.ps1
- Examples\JustCharts\TargetData.csv
- Examples\PassThru\TryPassThru.ps1
- Examples\Tables\MultipleTables.ps1
- ImportExcel.psm1
- FAQ\How to Read an Existing Excel File.md
- images\PivotAsColumns.png
- Pivot\README.md
- Public\Get-ExcelSheetDimensionAddress.ps1
- Public\Remove-Worksheet.ps1
- Examples\CommunityContributions\MultipleWorksheets.ps1
- Examples\ConvertFrom\ConvertFrom.ps1
- Examples\Grouping\TimestampBucket.ps1
- Examples\JustCharts\TargetData.ps1
- Examples\PesterTestReport\Pester test report.ps1
- Examples\TestRestAPI\PSExcelPester.psm1
- LICENSE.txt
- FAQ\How to Write to an Existing Excel File.md
- images\PivotAsRows.png
- Private\ArgumentCompletion.ps1
- Public\Get-ExcelSheetInfo.ps1
- Public\Select-Worksheet.ps1
- Examples\ConditionalFormatting\CodeGenExamples.ps1
- Examples\ConvertFrom\testSQLGen.xlsx
- Examples\HyperLinks\First10Races.csv
- Examples\JustCharts\TryBarChart.ps1
- Examples\PesterTestReport\PesterConfiguration.json
- Examples\TestRestAPI\RunAndShowUnitTests.ps1
- Plot.ps1
- images\CellFormatting.png
- images\PivotTableFilter.png
- Private\Invoke-ExcelReZipFile.ps1
- Public\Get-ExcelWorkbookInfo.ps1
- Public\Send-SQLDataToExcel.ps1
- Examples\ConditionalFormatting\ConditionalText.ps1
- Examples\CustomizeExportExcel\Out-Excel.ps1
- Examples\HyperLinks\Hyperlinks.ps1
- Examples\JustCharts\TryColumnChart.ps1
- Examples\PivotTable\MultiplePivotTables.ps1
- Examples\TestRestAPI\ShowPesterResults.ps1
- PublishToGallery.ps1
- images\ConditionalDates.gif
- images\PivotTablesAndCharts.png
- Public\Add-ConditionalFormatting.ps1
- Public\Get-HtmlTable.ps1
- Public\Set-CellStyle.ps1
- Examples\ConditionalFormatting\ContainsBlanks.ps1
- Examples\CustomReporting\CustomReport.ps1
- Examples\HyperLinks\Races.ps1
- Examples\JustCharts\TryPieChart.ps1
- Examples\PivotTable\PivotTableWithName.ps1
- Examples\TestRestAPI\TestAPIReadXls.ps1
- README.md
- images\ConditionalText.gif
- images\plot.gif
- Public\Add-ExcelChart.ps1
- Public\Get-Range.ps1
- Public\Set-ExcelColumn.ps1
- Examples\ConditionalFormatting\Databar.ps1
- Examples\ExcelBuiltIns\DSUM.png
- Examples\Import-Excel\ImportMultipleSheetsAsArray.ps1
- Examples\MergeWorkSheet\MergeCSV.ps1
- Examples\PivotTable\TableAndPivotTable.ps1
- Examples\TestRestAPI\testlist.xlsx
- SUMMARY.md
- images\ConditionalText2.gif
- images\plotNew.gif
- Public\Add-ExcelDataValidationRule.ps1
- Public\Get-XYRange.ps1
- Public\Set-ExcelRange.ps1
- Examples\ConditionalFormatting\FormatCalculations.ps1
- Examples\ExcelBuiltIns\DSUM.ps1
- Examples\Import-Excel\ImportMultipleSheetsAsHashtable.ps1
- Examples\MergeWorkSheet\Merge_2_Servers_Services.ps1
- Examples\PivotTableFilters\testPivotFilter.ps1
- Examples\TestRestAPI\TryIt.ps1
- test.xlsx
- images\CustomReport.png
- images\PSPlot.gif
- Public\Add-ExcelName.ps1
- Public\Import-Excel.ps1
- Public\Set-ExcelRow.ps1
- Examples\ConditionalFormatting\GenDates.ps1
- Examples\ExcelBuiltIns\VLookUp.png
- Examples\Import-Excel\yearlySales.xlsx
- Examples\MergeWorkSheet\Merge_3_Servers_Services.ps1
- Examples\Plot\PlotCos.ps1
- Examples\VBA\AddModuleMultipleWorksheetVBA.ps1
- .github\stale.yml
- images\ExportMultiple.gif
- images\SalesDataWithDatabar.png
- Public\Add-ExcelTable.ps1
- Public\Import-Html.ps1
- Public\Set-WorksheetProtection.ps1
- Examples\ConditionalFormatting\GetProcess.ps1
- Examples\ExcelBuiltIns\VLOOKUP.ps1
- Examples\ImportColumns\ImportColumns.ps1
- Examples\MortgageCalculator\MortgageCalculator.ps1
- Examples\ReadAllSheets\GenerateXlsx.ps1
- Examples\VBA\AddWorksheetVBA.ps1
- Charting\barchart.md
- images\exportstockinfo.gif
- images\SQL-Spreadsheet.png
- Public\Add-PivotTable.ps1
- Public\Import-UPS.ps1
- Public\Update-FirstObjectProperties.ps1
- Examples\ConditionalFormatting\Highlight-Last7Days.ps1
- Examples\ExcelDataValidation\MutipleValidations.ps1
- Examples\ImportHtml\DemoGraphics.ps1
- Examples\MoveSheets\MoveSheets.ps1
- Examples\ReadAllSheets\Get-ExcelSheets.ps1
- Examples\VBA\HelloWorldVBA.ps1
- Charting\Charting.ps1
- images\FilterFreezeBold.gif
- images\testimonial.png
- Public\Add-Worksheet.ps1
- Public\Import-USPS.ps1
- spikes\ConvertFrom-ExcelColumnName.ps1
- Examples\ConditionalFormatting\Highlight-LastMonth.ps1
- Examples\ExcelToSQLInsert\DemoSQLInsert.ps1
- Examples\ImportHtml\PeriodicElements.ps1
- Examples\MultiplierTable\MultiplierTable.xlsx
- Examples\ReadAllSheets\ReadAllSheets.ps1
- Examples\XlRangeToImage\XlRangeToImage.ps1
- Charting\columnchart.md
- images\fluent.gif
- images\Title.png
- Public\Close-ExcelPackage.ps1
- Public\Invoke-ExcelQuery.ps1
- Testimonials\t1.png
- Examples\ConditionalFormatting\Highlight-LastWeek.ps1
- Examples\ExcelToSQLInsert\Movies.xlsx
- Examples\ImportHtml\StarTrek.ps1
- Examples\Nasa\FireBalls.ps1
- Examples\SetColumnBackgroundColor\SetColumnBackgroundColor.ps1
- images\FAQ_Images\DataStructureExcelPkg.png
- Charting\dochart.md
- images\Formatting.png
- images\Tracking.gif
- Public\Compare-Worksheet.ps1
- Public\Invoke-Sum.ps1
- Examples\AddImage\Add-ExcelImage.ps1
- Examples\ConditionalFormatting\Highlight-NextMonth.ps1
- Examples\Experimental\Export-MultipleExcelSheets.ps1
- Examples\InvokeExcelQuery\Examples.ps1
- Examples\NumberFormat\ColorizeNumbers.ps1
- Examples\Sparklines\SalesByQuarter.ps1
- images\FAQ_Images\ExcelFileContents.png
- Charting\linechart.md
- images\GetExcelSheetInfo.png
- images\TryImportExcel.gif
- Public\Convert-ExcelRangeToImage.ps1
- Public\Join-Worksheet.ps1
- Examples\AddImage\AddImage.ps1
- Examples\ConditionalFormatting\Highlight-NextWeek.ps1
- Examples\Experimental\testExport.xlsx
- Examples\InvokeExcelQuery\testOleDb.xlsx
- Examples\NumberFormat\CurrencyFormat.ps1
- Examples\Sparklines\Sparklines.ps1
- images\FAQ_Images\ExcelFileContentsPostAdd.png
- Charting\piechart.md
- images\GroupingNumeric.png
- images\XLToPesterForRestAPI.gif
- Public\ConvertFrom-ExcelData.ps1
- Public\Merge-MultipleSheets.ps1
- Examples\AddImage\Octocat.jpg
- Examples\ConditionalFormatting\Highlight-ThisMonth.ps1
- Examples\Experimental\tryExportMultipleExcelSheets.ps1
- Examples\JoinWorksheet\EastSales.csv
- Examples\NumberFormat\PercentagFormat.ps1
- Examples\SpreadsheetCells\CalculatedFields.ps1
- images\FAQ_Images\ExcelFileDebugImg.jpg
- Charting\README.md
- images\GTConditional.png
- images\XLToPesterForRestAPIAndOutput.gif
- Public\ConvertFrom-ExcelSheet.ps1
- Public\Merge-Worksheet.ps1
- Examples\AddImage\README.md
- Examples\ConditionalFormatting\Highlight-ThisWeek.ps1
- Examples\Extra\Get-ModuleStats.ps1
- Examples\JoinWorksheet\Join-worksheet-blocks.sample.ps1
- Examples\NumberFormat\PosNegNumbers.ps1
- Examples\SpreadsheetCells\ExcelFormulasUsingAddMember.ps1
- images\FAQ_Images\ValueAtIndexData.png
- en\ImportExcel-help.xml
- images\ImportHtml.gif
- InferData\InferData.ps1
- Public\ConvertFrom-ExcelToSQLInsert.ps1
- Public\New-ConditionalFormattingIconSet.ps1
- Examples\AddWorkSheet\AddMultiWorkSheet.ps1
- Examples\ConditionalFormatting\Highlight-Today.ps1
- Examples\Fibonacci\ShowFibonacci.ps1
- Examples\JoinWorksheet\Join-Worksheet.sample.ps1
- Examples\NumberFormat\Win32LogicalDisk.ps1
- Examples\SpreadsheetCells\ExcelFunctions.ps1
- Examples\InteractWithOtherModules\Pester\Analyze_that.ps1
- en\Strings.psd1
- images\ImportHtmlSecretaryOfState.gif
- InferData\invoke-alltests.md
- Public\ConvertTo-ExcelXlsx.ps1
- Public\New-ConditionalText.ps1
- Examples\AddWorkSheet\AddWorkSheet.ps1
- Examples\ConditionalFormatting\Highlight-Tomorrow.ps1
- Examples\FormatCellStyles\ApplyFormatInScriptBlock.ps1
- Examples\JoinWorksheet\JoinSalesData.ps1
- Examples\NumberFormat\Win32LogicalDiskFormatted.ps1
- Examples\SpreadsheetCells\HyperLink.ps1
- Examples\InteractWithOtherModules\ScriptAnalyzer\Analyze_this.ps1
- Examples\import-by-columns.ps1
- InferData\README.md
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 7.8.4 | 820,503 | 12/11/2022 |
| 7.8.3 | 74,317 | 11/20/2022 |
| 7.8.2 | 85,747 | 10/22/2022 |
| 7.8.1 | 159,585 | 9/3/2022 |
| 7.8.0 | 122,131 | 7/16/2022 |
| 7.7.0 | 22,647 | 7/4/2022 |
| 7.6.0 | 39,286 | 6/17/2022 |
| 7.5.3 | 54,463 | 5/30/2022 |
| 7.5.2 (current version) | 70,341 | 5/4/2022 |
| 7.5.1 | 3,750 | 5/3/2022 |
| 7.5.0 | 9,409 | 4/30/2022 |
| 7.4.2 | 31,863 | 4/19/2022 |
| 7.4.1 | 281,668 | 12/11/2021 |
| 7.4.0 | 38,406 | 11/20/2021 |
| 7.3.1 | 12,843 | 11/13/2021 |
| 7.3.0 | 106,113 | 9/14/2021 |
| 7.2.2 | 60,470 | 7/30/2021 |
| 7.2.1 | 7,247 | 7/24/2021 |
| 7.2.0 | 477 | 7/24/2021 |
| 7.1.2 | 118,637 | 5/8/2021 |
| 7.1.1 | 277,451 | 7/11/2020 |
| 7.1.0 | 146,335 | 3/21/2020 |
| 7.0.1 | 118,301 | 12/21/2019 |
| 7.0.0 | 10,665 | 12/7/2019 |
| 6.5.3 | 9,216 | 11/23/2019 |
| 6.5.2 | 10,862 | 11/2/2019 |
| 6.5.1 | 28,121 | 8/31/2019 |
| 6.5.0 | 1,473 | 8/28/2019 |
| 6.2.4 | 3,616 | 8/21/2019 |
| 6.2.3 | 12,373 | 7/24/2019 |
| 6.2.2 | 13,095 | 7/5/2019 |
| 6.2.1 | 7,702 | 6/18/2019 |
| 6.2.0 | 2,795 | 6/12/2019 |
| 6.1.0 | 17,889 | 5/26/2019 |
| 6.0.0 | 22,618 | 4/12/2019 |
| 5.4.5 | 20,405 | 3/2/2019 |
| 5.4.4 | 21,307 | 1/5/2019 |
| 5.4.3 | 1,956 | 12/30/2018 |
| 5.4.2 | 14,590 | 12/8/2018 |
| 5.4.0 | 16,226 | 11/3/2018 |
| 5.3.4 | 18,514 | 10/4/2018 |
| 5.3.3 | 441 | 10/3/2018 |
| 5.3.2 | 3,900 | 9/20/2018 |
| 5.3.1 | 309 | 9/20/2018 |
| 5.3.0 | 415 | 9/19/2018 |
| 5.2.0 | 13,749 | 8/18/2018 |
| 5.1.1 | 7,612 | 8/2/2018 |
| 5.1.0 | 1,821 | 7/30/2018 |
| 5.0.1 | 15,003 | 6/27/2018 |
| 5.0.0 | 11,093 | 6/15/2018 |
| 4.0.13 | 13,109 | 4/22/2018 |
| 4.0.12 | 2,532 | 4/10/2018 |
| 4.0.11 | 2,280 | 3/31/2018 |
| 4.0.10 | 3,243 | 3/15/2018 |
| 4.0.9 | 29,008 | 1/25/2018 |
| 4.0.8 | 17,443 | 11/25/2017 |
| 4.0.7 | 224 | 11/24/2017 |
| 4.0.6 | 203 | 11/24/2017 |
| 4.0.5 | 254 | 11/23/2017 |
| 4.0.4 | 2,881 | 10/30/2017 |
| 4.0.3 | 1,264 | 10/20/2017 |
| 4.0.2 | 1,989 | 10/3/2017 |
| 4.0.1 | 435 | 9/30/2017 |
| 4.0.0 | 1,805 | 9/12/2017 |
| 3.0.1 | 6,582 | 7/3/2017 |
| 3.0.0 | 1,428 | 6/16/2017 |
| 2.4.0 | 8,719 | 2/22/2017 |
| 2.3.0 | 633 | 2/14/2017 |
| 2.2.10 | 2,312 | 12/22/2016 |
| 2.2.9 | 2,862 | 10/1/2016 |
| 2.2.8 | 1,123 | 9/1/2016 |
| 2.2.7 | 1,890 | 7/1/2016 |
| 2.2.6 | 220 | 7/1/2016 |
| 2.2.5 | 966 | 6/1/2016 |
| 2.2.4 | 934 | 4/30/2016 |
| 2.2.3 | 430 | 4/18/2016 |
| 2.2.2 | 502 | 3/31/2016 |
| 2.2.1 | 288 | 3/26/2016 |
| 2.2.0 | 290 | 3/18/2016 |
| 2.1.3 | 419 | 3/2/2016 |
| 2.1.2 | 318 | 2/24/2016 |
| 2.1.1 | 230 | 2/24/2016 |
| 2.1 | 266 | 2/22/2016 |
| 2.0.1 | 224 | 2/22/2016 |
| 2.0 | 278 | 2/21/2016 |
| 1.99 | 265 | 2/18/2016 |
| 1.98 | 436 | 1/29/2016 |
| 1.97 | 318 | 1/18/2016 |
| 1.96 | 223 | 1/15/2016 |
| 1.94 | 238 | 1/14/2016 |
| 1.92 | 282 | 1/6/2016 |
| 1.91 | 220 | 1/6/2016 |
| 1.90 | 825 | 10/20/2015 |
| 1.83 | 234 | 10/15/2015 |
| 1.82 | 283 | 10/1/2015 |
| 1.81 | 225 | 9/30/2015 |
| 1.8 | 231 | 9/25/2015 |
| 1.7 | 265 | 9/11/2015 |
| 1.6 | 261 | 8/21/2015 |
| 1.5 | 293 | 7/9/2015 |
| 1.4 | 269 | 6/18/2015 |
| 1.3 | 256 | 5/25/2015 |
| 1.2 | 226 | 5/18/2015 |
| 1.1 | 234 | 5/17/2015 |
| 1.0 | 388 | 5/4/2015 |