v0.14.0

0.14.0 - 2024-03-02

Fixed

• Fixed a bug that caused Clear-Worksheet to throw an exception.

v0.13.0

0.13.0 - 2024-02-27

Changed

• Improved the performance of Clear-Worksheet cmdlet.

v0.12.0

0.12.0 - 2024-02-27

Added

• Added a new cmdlet Clear-Worksheet, which can be used with a parameter -Area NonPrint to clear the cells in non-printing area.
• Added a new parameter -DisableMacro to Compress-Workbook. Specifying the parameter will automatically save workbooks as the format without macro in the archive.

Changed

• Export-Workbook cmdlet now saves each workbook in its original format by default. The output format can be changed with -As parameter.

v0.11.0

0.11.0 - 2024-02-06

Added

• Added a new cmdlet Hide-Worksheet to hide worksheets having the specified name.

Fixed

• Fixed a bug in Compress-Workbook cmdlet that causes broken paths of zip entries
  when the input files reside outside of the current directory.

Changed

• Remove-Worksheet cmdlet now accepts multiple names with -Name parameter.

v0.10.0

0.10.0 - 2024-02-04

Added

• Added Remove-Worksheet cmdlet for deleting worksheets having the specified name.
• Compress-Workbook cmdlet now receives the following new parameters.
  • -FileMode to specify the file mode of the archive file.
    See https://learn.microsoft.com/en-us/dotnet/api/system.io.filemode?view=netframework-4.8.1
  • -LastWriteTime to specify the date time of the archive entries.

Changed

• Compress-Workbook cmdlet now creates a new archive file by default.
  This behavior can be changed using -FileMode parameter.

v0.9.0

0.9.0 - 2024-01-21

Added

• Added a new cmdlet Remove-HiddenWorksheet.

v0.8.0

0.8.0 - 2024-01-08

Changed

• Updated .NET Framework to 4.8.

Added

• Added the following new parameters to Merge-Workbook cmdlet.
  • -RestartPageNumber
  • -PageNumberFormat

v0.7.0

0.7.0 - 2020-03-29

Changed

• Merge-Cell cmdlet was renamed to Merge-BorderedWorksheetRange.

Added

• Added SkipBooks parameter to the cmdlets processing workbooks.

Fixed

• Fix resolution of path passed to Destination parameter when the path is a UNC.

v0.6.0

0.6.0 - 2020-03-24

Added

• Merge-Cell cmdlet.

v0.5.0

0.5.0 - 2020-03-22

Added

• Compress-Workbook cmdlet for compressing input workbooks.
• Clear-DateCell cmdlet.

Changed

• Rename cmdlets Import-Excel/Export-Excel/Merge-Excel to
  Import-Workbook/Export-Workbook/Merge-Workbook respectively.
• -PageNumber parameter now takes left/center/right as its value.
• DLL name was shortened to Cellmate.dll.