v24.5.0

What's Changed

• Add Enhanced Sheet Management Features by @fahadadeel in #16

Full Changelog: v24.4.0...v24.5.0

[v24.5.0] - 2024-05-10

New Features

• RenameSheet Method

  • Introduced the ability to rename existing sheets within the workbook.
  • Ensures synchronization of internal worksheet references after renaming.

• CopySheet Method

  • Added functionality to duplicate sheets within the workbook.
  • Clones worksheet content to create new sheets with specified names.

• ReorderSheets Method

  • Enabled changing the position of sheets within the workbook.
  • Moves sheets to new specified indexes efficiently.

• SetSheetVisibility Method

  • Implemented the capability to adjust the visibility of sheets (Visible, Hidden, VeryHidden).
  • Enhanced with exception handling for robust error management when sheets are not found or invalid visibility values are provided.

Improvements

• Error Handling
  • Improved error reporting across new methods, ensuring better handling of invalid operations and states.

Documentation

• Code Comments and API References
  • Added detailed inline comments and API references for all new methods to enhance code readability and maintainability.

Testing

• Comprehensive testing of all new methods, covering typical and edge cases.
• Validation to ensure workbook integrity and correct updating of sheet states post-operations.

Notes

• This release enhances the workbook manipulation capabilities, making sheet management more flexible and user-friendly.