Commit graph

6 commits

Author SHA1 Message Date
Max
1cce634d24 feat: Add row reading and dimension retrieval functionalities for Excel sheets
- Implemented `excel.sheet.rows` to read specified rows from a sheet with pagination support.
- Added `excel.sheet.dimension` to retrieve the number of rows and columns in a sheet.
- Enhanced the Excel processing logic to handle new functionalities and updated related tests.
- Updated README with examples for the new features.
2025-05-15 12:56:28 +08:00
Max
cae4d06373 feat: Add sheet existence check to Excel module
- Implement processSheetExists function to verify if a specified sheet exists in the workbook.
- Update README.md with usage examples for the new sheet existence check feature.
- Add unit tests for SheetExists functionality to ensure accurate detection of existing and non-existent sheets.
2025-03-29 18:16:58 +08:00
Max
6e4b7cd59e feat: Add sheet management operations to Excel module
- Implement new process handlers for creating, reading, updating, copying, and deleting sheets in Excel files.
- Enhance the Open function to automatically create directories for file paths if they do not exist.
- Update README.md to include detailed documentation and examples for new sheet operations, improving user guidance.
2025-03-29 17:02:18 +08:00
Max
f28076f908 docs: Add style ID constants and usage examples to Excel README
- Introduce a section detailing supported style ID constants for borders and fills in the Excel module.
- Provide examples for creating and applying custom styles using the `excel.set.Style` method.
- Enhance documentation clarity for users implementing styling in Excel files.
2025-03-21 22:14:13 +08:00
Max
6f4c2fa5c4 refactor: Standardize Excel process method names to PascalCase
- Update all Excel-related Process method calls in README.md to use PascalCase for consistency.
- Adjust method names such as "excel.open" to "excel.Open" and "excel.write.cell" to "excel.write.Cell" to align with naming conventions.
- Ensure clarity and uniformity in the documentation for better usability.
2025-03-21 22:10:03 +08:00
Max
57fe05bed8 fix: Update processOpen to use writable flag for Excel file operations
- Change the argument from readonly to writable in the processOpen function.
- Adjust the Open function call to reflect the new writable parameter for improved clarity in file handling.
2025-03-21 21:56:22 +08:00