ImportExcel
5.4.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
Author(s)
Douglas Finke
Copyright
c 2015 All rights reserved.
Package Details
Owners
Tags
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 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
- 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
- test.csv
- 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.6.0 | 30,197 | 6/17/2022 |
7.5.3 | 53,936 | 5/30/2022 |
7.5.2 | 69,021 | 5/4/2022 |
7.5.1 | 3,616 | 5/3/2022 |
7.5.0 | 9,260 | 4/30/2022 |
7.4.2 | 31,626 | 4/19/2022 |
7.4.1 | 266,740 | 12/11/2021 |
7.4.0 | 36,080 | 11/20/2021 |
7.3.1 | 12,697 | 11/13/2021 |
7.3.0 | 105,138 | 9/14/2021 |
7.2.2 | 59,995 | 7/30/2021 |
7.2.1 | 7,052 | 7/24/2021 |
7.2.0 | 343 | 7/24/2021 |
7.1.2 | 117,253 | 5/8/2021 |
7.1.1 | 273,688 | 7/11/2020 |
7.1.0 | 139,004 | 3/21/2020 |
7.0.1 | 73,100 | 12/21/2019 |
7.0.0 | 10,246 | 12/7/2019 |
6.5.3 | 8,389 | 11/23/2019 |
6.5.2 | 10,451 | 11/2/2019 |
6.5.1 | 27,958 | 8/31/2019 |
6.5.0 | 1,342 | 8/28/2019 |
6.2.4 | 3,492 | 8/21/2019 |
6.2.3 | 12,199 | 7/24/2019 |
6.2.2 | 12,924 | 7/5/2019 |
6.2.1 | 7,555 | 6/18/2019 |
6.2.0 | 2,667 | 6/12/2019 |
6.1.0 | 17,752 | 5/26/2019 |
6.0.0 | 22,326 | 4/12/2019 |
5.4.5 | 19,891 | 3/2/2019 |
5.4.4 | 21,093 | 1/5/2019 |
5.4.3 | 1,830 | 12/30/2018 |
5.4.2 | 13,673 | 12/8/2018 |
5.4.0 (current version) | 15,794 | 11/3/2018 |
5.3.4 | 17,502 | 10/4/2018 |
5.3.3 | 316 | 10/3/2018 |
5.3.2 | 3,777 | 9/20/2018 |
5.3.1 | 173 | 9/20/2018 |
5.3.0 | 287 | 9/19/2018 |
5.2.0 | 13,578 | 8/18/2018 |
5.1.1 | 6,214 | 8/2/2018 |
5.1.0 | 1,399 | 7/30/2018 |
5.0.1 | 13,889 | 6/27/2018 |
5.0.0 | 8,250 | 6/15/2018 |
4.0.13 | 12,944 | 4/22/2018 |
4.0.12 | 2,377 | 4/10/2018 |
4.0.11 | 2,128 | 3/31/2018 |
4.0.10 | 3,088 | 3/15/2018 |
4.0.9 | 28,871 | 1/25/2018 |
4.0.8 | 16,280 | 11/25/2017 |
4.0.7 | 93 | 11/24/2017 |
4.0.6 | 69 | 11/24/2017 |
4.0.5 | 124 | 11/23/2017 |
4.0.4 | 2,724 | 10/30/2017 |
4.0.3 | 1,108 | 10/20/2017 |
4.0.2 | 1,831 | 10/3/2017 |
4.0.1 | 282 | 9/30/2017 |
4.0.0 | 1,645 | 9/12/2017 |
3.0.1 | 6,414 | 7/3/2017 |
3.0.0 | 1,274 | 6/16/2017 |
2.4.0 | 8,485 | 2/22/2017 |
2.3.0 | 479 | 2/14/2017 |
2.2.10 | 2,151 | 12/22/2016 |
2.2.9 | 2,704 | 10/1/2016 |
2.2.8 | 964 | 9/1/2016 |
2.2.7 | 1,731 | 7/1/2016 |
2.2.6 | 63 | 7/1/2016 |
2.2.5 | 810 | 6/1/2016 |
2.2.4 | 777 | 4/30/2016 |
2.2.3 | 277 | 4/18/2016 |
2.2.2 | 347 | 3/31/2016 |
2.2.1 | 132 | 3/26/2016 |
2.2.0 | 134 | 3/18/2016 |
2.1.3 | 260 | 3/2/2016 |
2.1.2 | 159 | 2/24/2016 |
2.1.1 | 71 | 2/24/2016 |
2.1 | 106 | 2/22/2016 |
2.0.1 | 67 | 2/22/2016 |
2.0 | 104 | 2/21/2016 |
1.99 | 99 | 2/18/2016 |
1.98 | 276 | 1/29/2016 |
1.97 | 161 | 1/18/2016 |
1.96 | 66 | 1/15/2016 |
1.94 | 80 | 1/14/2016 |
1.92 | 120 | 1/6/2016 |
1.91 | 58 | 1/6/2016 |
1.90 | 661 | 10/20/2015 |
1.83 | 74 | 10/15/2015 |
1.82 | 120 | 10/1/2015 |
1.81 | 63 | 9/30/2015 |
1.8 | 71 | 9/25/2015 |
1.7 | 105 | 9/11/2015 |
1.6 | 97 | 8/21/2015 |
1.5 | 132 | 7/9/2015 |
1.4 | 110 | 6/18/2015 |
1.3 | 90 | 5/25/2015 |
1.2 | 65 | 5/18/2015 |
1.1 | 70 | 5/17/2015 |
1.0 | 208 | 5/4/2015 |