Convert range to json
Excel API : ConvertRangeToJson
Overview
Converts a range of spreadsheet on a local drive to the json file.
Function Description
This method reads a spreadsheet file from the local file system, converts it’s range to the desired json file, and returns the converted result. The source file path and target format must be specified correctly. Ensure that the necessary permissions are in place to read the source file and write the converted file if applicable. The conversion process occurs entirely on the cloud server, eliminating the need for any cloud storage or external downloads. If the source file does not exist, is inaccessible, or if an error occurs during the conversion process, an appropriate exception will be thrown. Supported formats for conversion depend on the available libraries and their capabilities.
API Endpoint
PUT http://api.aspose.cloud/v4.0/cells/convert/range/json
The request parameters of convertRangeToJson API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
|---|---|---|---|
| Spreadsheet | File | FormData | Upload spreadsheet file. |
| worksheet | String | Query | worksheet name of spreadsheet. |
| range | String | Query | cell area. e.g. A1:C10 |
| outPath | String | Query | (Optional) The folder path where the workbook is stored. The default is null. |
| outStorageName | String | Query | Output file Storage Name. |
| fontsLocation | String | Query | Use Custom fonts. |
| regoin | String | Query | The spreadsheet region setting. |
| password | String | Query | The password for opening spreadsheet file. |
Response Structure
{
File
}
Error Handling
- 400 Bad Request: Invalid url.
- 401 Unauthorized: Authentication has failed, or no credentials were provided.
- 404 Not Found: Source file not accessible.
- 500 Server Error The spreadsheet has encountered an anomaly in obtaining conversion data.
Usage Scenarios
Key Features and Benefits
- Cloud-Native Conversion: Conversion of local files directly in the cloud, eliminating the need to store them there.
- Reduced Cloud Resource Burden: No need to upload files to the cloud, saving cloud storage space.
- Simplified Workflow: Convert local spreadsheets to the json format directly through cloud services, without intermediate steps.
OpenAPI Specification
The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.
Excel API SDK
Using an SDK is the best way to speed up the development. An SDK takes care of low-level details and lets you focus on your project tasks. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.
The following code examples demonstrate how to make calls to Aspose.Cells web services using various SDKs: