How to Export a Remote Spreadsheet Range to Other Formats: Step‑by‑Step Guide
Contents
[
Hide
]
Export a cloud spreadsheet/Excel range to a format file. The format file can be saved in the cloud or exported to local storage.
Export Range as Format API
Web API
GET https://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/ranges/{range}
Security and Authentication
The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.
Request Parameters
| Parameter Name | Type | Location | Description |
|---|---|---|---|
| name | String | Path | (Required) The name of the workbook file to be retrieved. |
| worksheet | String | Path | The worksheet name of the spreadsheet. |
| range | String | Path | The range to be converted (e.g., A1:C12). |
| format | String | Query | (Required) Desired output format (e.g., pdf, png, svg). |
| folder | String | Query | (Optional) Folder path where the workbook is stored. |
| storageName | String | Query | (Optional) Name of the storage if using a custom cloud storage. |
| outPath | String | Query | (Optional) Path for the output file in cloud storage. |
| outStorageName | String | Query | (Optional) Storage name for the output file. |
| fontsLocation | String | Query | (Optional) Custom fonts location. |
| region | String | Query | (Optional) Spreadsheet region/language setting (e.g., en-US, fr-FR). Influences number formatting, date parsing, and locale‑specific behavior. |
| password | String | Query | (Optional) Password required to open the spreadsheet file. |
Response
[
{
"Name": "ResponseFile",
"DataType": {
"Identifier": "File",
"Reference": "Stream"
}
}
]
HTTP Status Codes
| Code | Meaning | Description |
|---|---|---|
| 200 | OK | Filter applied successfully; response contains operation details. |
| 400 | Bad Request | Missing or invalid parameters (e.g., unsupported file type). |
| 401 | Unauthorized | Invalid or missing JWT token. |
| 413 | Payload Too Large | Uploaded file exceeds size limit. |
| 500 | Internal Server Error | Unexpected server error. |
Where should you use the Export Range to another format API?
Data Export & Migration Scenarios
- Database Integration – Export specific Excel ranges directly to database systems.
- Application Integration – Feed selected spreadsheet data into SaaS applications.
- System Migration – Transfer specific data ranges between legacy and modern systems.
- Cross‑Platform Sharing – Share focused data subsets across different platforms.
Reporting & Analytics
- Targeted Reporting – Export specific report sections to other formats for focused analysis.
- Dashboard Data Feeds – Supply specific data ranges to BI dashboard tools.
- Performance Metrics – Extract KPI ranges for performance‑tracking systems.
- Financial Reporting – Export financial statement sections for external auditing.
Development & Testing
- Test Data Management – Export specific data ranges for testing purposes.
- Development Environments – Share sample data ranges with development teams.
- API Testing – Generate CSV test data from specific spreadsheet sections.
- Prototype Development – Provide focused data sets for application prototypes.
Business Operations
- Selective Data Sharing – Share specific data ranges with external partners.
- Partial Data Backup – Backup critical data ranges in a chosen format.
- Departmental Data Transfer – Share specific data between departments.
- Compliance Reporting – Export regulatory data ranges for compliance submissions.
Automation Workflows
- Scheduled Range Exports – Automatically export specific ranges on a schedule.
- Trigger‑Based Extraction – Export ranges based on business events or triggers.
- Workflow Integration – Integrate range exports into business process workflows.
- Batch Range Processing – Process multiple specific ranges in batch operations.
Why should you use the Export Range to another format API?
- Developer‑Friendly – Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development with comprehensive documentation. Compared to building custom chart‑rendering solutions, this significantly reduces development workload.
- Reduced Labor Costs – Less need for personnel dedicated to document consolidation.
- Pay‑per‑Use – No upfront investment; you only pay for the API calls you actually use.
- No Server Maintenance – No servers to maintain, no software updates, and no compatibility issues.
- Preserves Complex Excel Formatting – Output files retain the original spreadsheet’s formatting.
How to Use the Export Spreadsheet Range as Format API with SDKs?
Export Range as Format API Specification
The Export Range as Format API Specification provides a publicly accessible programming interface, enabling REST interactions directly from a web browser.
You can use the cURL command‑line tool to access Aspose.Cells web services easily. The following example shows how to make calls to the Cloud API with cURL.
Use Aspose.Cells Cloud SDKs
Using the SDK is the fastest way to develop, as it abstracts away low‑level details, allowing you to export a spreadsheet range to a format file with concise code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.
The following code examples demonstrate how to call Aspose.Cells web services using various SDKs: