Advanced Excel Workbook Operations: Sheet Management and Compression – Aspose.Cells Cloud
Contents
[
Hide
]
Complete suite of Excel worksheet management APIs. Add, delete, move, rename worksheets, compress spreadsheet size, and create new workbooks from templates. Full control over Excel workbook structure and organization through the cloud API. No local Excel installation required.
Excel Worksheet Management APIs
Worksheet Addition & Creation
- Add Worksheet to Spreadsheet – Add new worksheets to workbooks, supporting worksheet‑type specification and insertion position.
- Create New Spreadsheet – Create new workbooks, supporting blank files or creation from templates (e.g., Timeline Work Plan Table, Sales Data Comparison Table, etc.).
Worksheet Editing & Renaming
- Rename Worksheet in Spreadsheet – Modify worksheet names, supporting dynamic naming and batch renaming.
- Move Worksheet in Spreadsheet – Adjust worksheet positions within workbooks, reorganizing worksheet order.
Worksheet Deletion & Cleanup
- Delete Worksheet from Spreadsheet – Delete specified worksheets from workbooks, removing unnecessary content.
Workbook Optimization
- Compress Spreadsheet – Compress workbook file sizes, optimizing storage and transmission efficiency.
Application Scenarios
Automated Report Generation
- Template‑Based Creation – Automatically generate weekly or monthly reports based on standard templates.
- Dynamic Structure – Add or delete analysis worksheets automatically according to data volume.
- Professional Naming – Rename worksheets to standardized formats without manual effort.
Workflow Document Processing
- Collaboration Management – Dynamically adjust worksheet structures in multi‑user collaboration environments.
- Version Control – Clean up obsolete worksheets during document version updates.
- File Optimization – Compress files automatically before sending to reduce attachment size.
Enterprise Data Management
- Batch Processing – Manage worksheet structures across hundreds of files simultaneously.
- Standardized Output – Ensure all output files have unified worksheet layouts.
- Resource Optimization – Regularly compress archived files to save storage space.