Set Range Value in an Excel Worksheet – Aspose.Cells Cloud API
Use this REST API to set a value in the specified range. When appropriate, the value is converted to another data type and the cell’s number format is reset.
Prerequisites
- A valid Aspose Cloud account.
- A JWT token that includes the
Cells.ReadWritescope. - The workbook must already be uploaded to the target storage location.
REST API
POST https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/ranges/value
The request parameters are:
| Parameter Name | Type | Location | Description |
|---|---|---|---|
| name | string | path | Workbook name |
| sheetName | string | path | Worksheet name |
| value | string | query | Input value |
| range | object | body | Range object in the worksheet |
| isConverted | boolean | query | Indicates whether the input value should be converted |
| setStyle | boolean | query | Indicates whether to apply style to the target cells |
| folder | string | query | Workbook folder |
| storageName | string | query | Storage name |
The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out 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 call the Cloud API with cURL. Include a valid JWT token in the Authorization header.
Response Schema
| Field | Type | Description |
|---|---|---|
| Code | integer | HTTP status code of the operation. |
| Status | string | Short description of the result (e.g., “OK”). |
| Message | string | Detailed error message when the request fails (optional). |
| Result | object | Additional data returned for successful calls (optional). |
Possible HTTP Status Codes
- 200 OK – The range value was set successfully.
- 400 Bad Request – Invalid parameters or malformed request body.
- 401 Unauthorized – Missing or invalid JWT token.
- 403 Forbidden – Insufficient permissions for the requested operation.
- 404 Not Found – Specified workbook, worksheet, or range does not exist.
- 500 Internal Server Error – Unexpected server error.
Cloud SDK Family
Using an SDK is the best way to speed up development. An SDK handles low‑level details, allowing you to 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: