Improved parameter defaults for

Get-Process | select Company, Name, Handles | Export-Excel

Additions, refactoring and fixes

• Refactored copy sheet and added pipe support
• Add ClearAll to Set-ExcelRange
• Fix broken test & regression for passwords
  • Note: Passwords do not work on pwsh. The EPPlus library does not support these dotnet core APIs at this time.

Fix relative path

v6.2.2

Updated readme and bumped version

New Feature - Chart Trendlines

https://github.com/dfinke/ImportExcel/blob/master/Examples/Charts/NumberOfVisitors.ps1

New-ExcelStyle added and more

v6.2.0

Updated

Import-Excel can use an Excel Package

Instead of specifying a path provides an Excel Package object (from Open-ExcelPackage), using this avoids re-reading the whole file when importing multiple parts of it. To allow multiple read operations Import-Excel does NOT close the package, and you should use Close-ExcelPackage -noSave to close it.

~10x speed increase

Performance improvement to Export-Excel see #506 and #555.

New - feature Data Validation

This and other updates, check the readme.md

Add Remove-Worksheet

Merge pull request #514 from dfinke/AddRemoveWorksheet-dcf

Add Remove-Workseet

Fixes and updates

• Thank you to Conrad Agramont, Twitter: @AGramont for the AddMultiWorkSheet.ps1 example. Much appreciated!
• Fixed several more bugs where parameters were ignored if passed a zero value
• Fixed bug where chart series headers could not come form a cell reference (=Sheet1!Z10 now works as a header reference)
• Add-Chart will now allow a single X range, or as many X ranges as there are Y ranges.
• Merge-MultipleSheets is more robust.
• Set-ExcelRow and Set-ExcelColumn trap attempts to process a sheet with no rows/columns.