Add Check, Warnings for Open-Excel-Package

Fixed throwing error when a Worksheet name collides with a method, or property name on the OfficeOpenXml.ExcelPackage package

Added Read-Clipboard

Read text from clipboard. It can read CSV or JSON. Plus, you can specify the delimiter and headers.

Add Get-ExcelFileSummary

Added Get-ExcelFileSummary - Gets summary information on an Excel file like number of rows, columns, and more

dir . -r *.xlsx | Get-ExcelFileSummary | ft

ExcelFile          WorksheetName Rows Columns Address Path
---------          ------------- ---- ------- ------- ----
Grades.xlsx        Sheet1          21       3 A1:C21  D:\temp\ExcelYouTube\Grades
GradesAverage.xlsx Sheet1          21       5 A1:E21  D:\temp\ExcelYouTube\Grades
AllShifts.xlsx     Sheet1          21       2 A1:B21  D:\temp\ExcelYouTube\SeparateData
Shift_1.xlsx       Sheet1          10       2 A1:B10  D:\temp\ExcelYouTube\SeparateData
Shift_2.xlsx       Sheet1           8       2 A1:B8   D:\temp\ExcelYouTube\SeparateData
Shift_3.xlsx       Sheet1           5       2 A1:B5   D:\temp\ExcelYouTube\SeparateData
Shifts.xlsx        Shift_1         10       2 A1:B10  D:\temp\ExcelYouTube\SeparateData
Shifts.xlsx        Shift_2          8       2 A1:B8   D:\temp\ExcelYouTube\SeparateData

Fixes, Updates and new Examples

What's new 7.1.0

Fixes, Updates and new Examples

Fixed

• Odd behavior on the return of Import-Excel function #792
• Export-Excel -FreezeTopRow with -Title #795
• Not importing when first row contains a 0 in a column #802

Updated

• Add -AsDate support to Import-Excel and ConvertFrom-ExcelSheet

New Examples

PS1	Description	Link
Pester-To-XLSx	Runs Pester, collects the results, enriches it, and exports it to Excel	Pester-To-XLSx.ps1
DSUM	Sums up the numbers in a field (column) of records in a list or database that match conditions that you specify.	DSUM.ps1
VLookup	Setups up a sheet, you enter the name of an item and the amount is looked up	VLOOKUP.ps1

More infrastructure improvements

• Refine pipeline script analysis
• Improve artifacts published
• Add manifest (psd1) checks

Refactor

• Remove all functions from the psm1
• Move functions into public subdirectory
• Align TDD and continuous integration workflow for this refactor
• Move help from functions to mdHelp and use PlatyPS to generate external help file

New Features

Thank you uSlackr

• Fixes Column order issue (plus tests) for Get-ExcelColumnName

Thank you jhoneill

• Linux. Now set an environment variable if the support needed for Autosize is present, and use that Environment variable to decide to skip autosize operations.
• Fixed tests which needed autosize to work so they skip of the environment variable is set.
• Fixed another break where on azure the module never loaded.
• Added -Force to Send-SQLDataToExcel so it sends something even if no rows are returned. (see #703)
• Added -asText to import-Excel see (#164)[https://github.com//issues/164] and multiple others
• Add a comment to ci.ps1 re better .NET version detection and left some commented out code.

Other

• Added the example ReadAllSheets.ps1 based on this thread #678

Improvements and Fixes

Thanks again to the community for making this module even better.

• Fix import excel headers
• Numerous improvements for DataTables and exporting it to Excel James O'Neill
  • Names, styles, proper appending
• Handles marking the empty row on an empty table as dummy row
• Re-work code based on linting recommendations
• Update existing tests and add more
• Support PipelineVariable thanks to Luc Dekens for reporting and Ili for the PR
• Fix quoting in ConvertFromExcelToSQLInsert beckerben

Publish correctly cased file names

v6.5.1

Updated appveyor badge

Lots of updates

This is now using the latest version of EPPlus. Unit tests are updated and passing, if you hit problems, please open an issue. You can rollback to an older version from the PowerShell Gallery if you are blocked.

Unit tests were updated and fixed
"Set-WorksheetProtection" is now switched on
Made a change to make Set-Excel range more friendly when Auto Sizing on non-windows platforms
Fixed - Windows only tests don't attempt to run on non-windows systems
Tests based on Get-Process don't attempt to run if <20 processes are returned
If $env:TEMP is not set (as will be the case on Linux)
Join-Path if used so paths are built with / or with \ as suits the OS where the test is running.
Excel Sparklines now supported, check out the examples SalesByQuarter and Sparklines.