ImportExcel
4.0.7
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 2015 All rights reserved.
Package Details
Author(s)
- Douglas Finke
Tags
Functions
Import-Excel Add-WorkSheet ConvertFrom-ExcelSheet Export-MultipleExcelSheets Add-ConditionalFormatting DoChart BarChart PieChart LineChart ColumnChart ColorCompletion ConvertFrom-ExcelData ConvertFrom-ExcelToSQLInsert ConvertTo-ExcelXlsx Copy-ExcelWorkSheet Export-Excel New-PivotTableDefinition 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 New-ConditionalFormattingIconSet New-ConditionalText New-ExcelChart New-PSItem Open-ExcelPackage Close-ExcelPackage Pivot Send-SQLDataToExcel Set-CellStyle Set-Column Set-Row Set-Format Import-USPS Import-UPS Update-FirstObjectProperties
Dependencies
This module has no dependencies.
FileList
- ImportExcel.nuspec
- AddConditionalFormatting.ps1
- Charting.ps1
- ColorCompletion.ps1
- ConvertFromExcelData.ps1
- ConvertFromExcelToSQLInsert.ps1
- ConvertToExcelXlsx.ps1
- Copy-ExcelWorkSheet.ps1
- EPPlus.dll
- Export-Charts.ps1
- Export-Excel.ps1
- Export-ExcelSheet.ps1
- formatting.ps1
- Get-ExcelColumnName.ps1
- Get-ExcelSheetInfo.ps1
- Get-ExcelWorkbookInfo.ps1
- Get-HtmlTable.ps1
- Get-Range.ps1
- Get-XYRange.ps1
- Import-Html.ps1
- ImportExcel.psd1
- ImportExcel.psm1
- InferData.ps1
- Invoke-Sum.ps1
- New-ConditionalFormattingIconSet.ps1
- New-ConditionalText.ps1
- New-ExcelChart.ps1
- New-PSItem.ps1
- Open-ExcelPackage.ps1
- Pivot.ps1
- Plot.ps1
- Send-SQLDataToExcel.ps1
- Set-CellStyle.ps1
- Set-Column.ps1
- Set-Row.ps1
- SetFormat.ps1
- TrackingUtils.ps1
- Update-FirstObjectProperties.ps1
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 7.8.10 | 8,979,240 | 10/21/2024 |
| 7.8.9 | 2,810,347 | 5/18/2024 |
| 7.8.8 | 53,757 | 5/13/2024 |
| 7.8.6 | 1,677,782 | 10/12/2023 |
| 7.8.5 | 660,509 | 6/14/2023 |
| 7.8.4 | 926,839 | 12/11/2022 |
| 7.8.3 | 95,250 | 11/20/2022 |
| 7.8.2 | 87,028 | 10/22/2022 |
| 7.8.1 | 170,624 | 9/3/2022 |
| 7.8.0 | 123,273 | 7/16/2022 |
| 7.7.0 | 23,178 | 7/4/2022 |
| 7.6.0 | 39,432 | 6/17/2022 |
| 7.5.3 | 55,488 | 5/30/2022 |
| 7.5.2 | 71,582 | 5/4/2022 |
| 7.5.1 | 3,776 | 5/3/2022 |
| 7.5.0 | 9,480 | 4/30/2022 |
| 7.4.2 | 32,006 | 4/19/2022 |
| 7.4.1 | 306,111 | 12/11/2021 |
| 7.4.0 | 40,772 | 11/20/2021 |
| 7.3.1 | 12,911 | 11/13/2021 |
| 7.3.0 | 107,915 | 9/14/2021 |
| 7.2.2 | 61,202 | 7/30/2021 |
| 7.2.1 | 7,406 | 7/24/2021 |
| 7.2.0 | 541 | 7/24/2021 |
| 7.1.2 | 119,968 | 5/8/2021 |
| 7.1.1 | 290,283 | 7/11/2020 |
| 7.1.0 | 168,027 | 3/21/2020 |
| 7.0.1 | 312,253 | 12/21/2019 |
| 7.0.0 | 11,139 | 12/7/2019 |
| 6.5.3 | 11,156 | 11/23/2019 |
| 6.5.2 | 11,832 | 11/2/2019 |
| 6.5.1 | 28,224 | 8/31/2019 |
| 6.5.0 | 1,494 | 8/28/2019 |
| 6.2.4 | 3,637 | 8/21/2019 |
| 6.2.3 | 12,405 | 7/24/2019 |
| 6.2.2 | 13,297 | 7/5/2019 |
| 6.2.1 | 7,726 | 6/18/2019 |
| 6.2.0 | 2,812 | 6/12/2019 |
| 6.1.0 | 17,960 | 5/26/2019 |
| 6.0.0 | 24,383 | 4/12/2019 |
| 5.4.5 | 21,374 | 3/2/2019 |
| 5.4.4 | 21,831 | 1/5/2019 |
| 5.4.3 | 1,969 | 12/30/2018 |
| 5.4.2 | 17,774 | 12/8/2018 |
| 5.4.0 | 16,799 | 11/3/2018 |
| 5.3.4 | 18,546 | 10/4/2018 |
| 5.3.3 | 466 | 10/3/2018 |
| 5.3.2 | 3,910 | 9/20/2018 |
| 5.3.1 | 369 | 9/20/2018 |
| 5.3.0 | 431 | 9/19/2018 |
| 5.2.0 | 13,840 | 8/18/2018 |
| 5.1.1 | 8,475 | 8/2/2018 |
| 5.1.0 | 1,966 | 7/30/2018 |
| 5.0.1 | 19,931 | 6/27/2018 |
| 5.0.0 | 23,271 | 6/15/2018 |
| 4.0.13 | 13,179 | 4/22/2018 |
| 4.0.12 | 2,542 | 4/10/2018 |
| 4.0.11 | 2,295 | 3/31/2018 |
| 4.0.10 | 3,260 | 3/15/2018 |
| 4.0.9 | 29,029 | 1/25/2018 |
| 4.0.8 | 25,715 | 11/25/2017 |
| 4.0.7 (current version) | 232 | 11/24/2017 |
| 4.0.6 | 217 | 11/24/2017 |
| 4.0.5 | 265 | 11/23/2017 |
| 4.0.4 | 2,900 | 10/30/2017 |
| 4.0.3 | 1,278 | 10/20/2017 |
| 4.0.2 | 2,006 | 10/3/2017 |
| 4.0.1 | 454 | 9/30/2017 |
| 4.0.0 | 1,865 | 9/12/2017 |
| 3.0.1 | 6,617 | 7/3/2017 |
| 3.0.0 | 1,472 | 6/16/2017 |
| 2.4.0 | 8,824 | 2/22/2017 |
| 2.3.0 | 644 | 2/14/2017 |
| 2.2.10 | 2,328 | 12/22/2016 |
| 2.2.9 | 2,875 | 10/1/2016 |
| 2.2.8 | 1,140 | 9/1/2016 |
| 2.2.7 | 1,902 | 7/1/2016 |
| 2.2.6 | 229 | 7/1/2016 |
| 2.2.5 | 981 | 6/1/2016 |
| 2.2.4 | 947 | 4/30/2016 |
| 2.2.3 | 446 | 4/18/2016 |
| 2.2.2 | 513 | 3/31/2016 |
| 2.2.1 | 297 | 3/26/2016 |
| 2.2.0 | 300 | 3/18/2016 |
| 2.1.3 | 429 | 3/2/2016 |
| 2.1.2 | 326 | 2/24/2016 |
| 2.1.1 | 243 | 2/24/2016 |
| 2.1 | 291 | 2/22/2016 |
| 2.0.1 | 233 | 2/22/2016 |
| 2.0 | 313 | 2/21/2016 |
| 1.99 | 279 | 2/18/2016 |
| 1.98 | 461 | 1/29/2016 |
| 1.97 | 328 | 1/18/2016 |
| 1.96 | 234 | 1/15/2016 |
| 1.94 | 247 | 1/14/2016 |
| 1.92 | 294 | 1/6/2016 |
| 1.91 | 236 | 1/6/2016 |
| 1.90 | 858 | 10/20/2015 |
| 1.83 | 744 | 10/15/2015 |
| 1.82 | 294 | 10/1/2015 |
| 1.81 | 246 | 9/30/2015 |
| 1.8 | 250 | 9/25/2015 |
| 1.7 | 284 | 9/11/2015 |
| 1.6 | 279 | 8/21/2015 |
| 1.5 | 311 | 7/9/2015 |
| 1.4 | 289 | 6/18/2015 |
| 1.3 | 275 | 5/25/2015 |
| 1.2 | 244 | 5/18/2015 |
| 1.1 | 254 | 5/17/2015 |
| 1.0 | 450 | 5/4/2015 |