How to Export the Remote Spreadsheet Worksheet to other formats: Step-by-Step Guide
Contents
[
Hide
]
Export a cloud spreadsheet/Excel to another format file.
Export Spreadsheet as Format API
API Endpoint
GET http://api.aspose.cloud/v4.0/cells/{name}
Request Parameters:
| Parameter Name | Type | Path/Query String/HTTP Body | Description |
|---|---|---|---|
| name | String | Path | (Required) The name of the workbook file to be retrieved. |
| format | String | Query | (Required) The desired output format (e.g., “Xlsx”, “PDF”, “CSV”). |
| folder | String | Query | (Optional) The folder path where the workbook is stored. The default is null. |
| storageName | String | Query | (Optional) The name of the storage if using custom cloud storage. Use default storage if omitted. |
| outPath | String | Query | (Optional) The folder path where the workbook will be stored. The default is null. |
| outStorageName | String | Query | Output file Storage Name. |
| fontsLocation | String | Query | Use custom fonts. |
| region | String | Query | The spreadsheet region setting. |
| password | String | Query | The password for opening the spreadsheet file. |
Response
[
{
"Name": "ResponseFile",
"DataType": {
"Identifier": "File",
"Reference": "Stream"
}
}
]
Error Codes
- 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
- 401 Unauthorized: Invalid access token. Or invalid client id and secret.
- 404 Not Found: The spreadsheet file not accessible.
- 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.
Where should you use the Export Spreadsheet as another format API?
- Legacy System Migration: Convert thousands of legacy XLS files to XLSX for modern systems.
- Archive Standardization: Normalize various spreadsheet formats (XLS, XLSM, ODS, CSV) to a single format for archival.
- Office Suite Interoperability: Convert Excel files to formats compatible with LibreOffice, Google Sheets, or Apple Numbers.
- Data Source Normalization: Convert various spreadsheet formats to CSV or JSON for database ingestion.
- Web Publishing: Convert financial models to HTML for web display.
Why should you use the Export Spreadsheet as another format API?
- Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared to building custom chart rendering solutions, this significantly reduces the development workload.
- Reduced Labor Costs: Reduced the need for positions dedicated to document consolidation.
- Pay-per-use: No upfront investment, only pay for API calls actually used.
- Zero Maintenance Costs: No need to maintain servers, update software, or deal with compatibility issues.
- Comprehensive Format Support: Convert between 20+ spreadsheet formats.
- Preserve Data Fidelity & Formatting
How to Use the Export Spreadsheet as Format API with SDKs?
Export Spreadsheet as Format API Specification
The Export Spreadsheet as Format API Specification provides a publicly accessible programming interface to perform REST interactions seamlessly.
Use Aspose.Cells Cloud SDKs
Using the SDK is the fastest way to develop, as it abstracts away the low-level details, allowing you to export a spreadsheet to a format file with short code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.
The following code examples illustrate how to interact with Aspose.Cells web services via various SDKs: