Set Cell Value – Aspose.Cells Cloud API Reference (v3.0)

This REST API sets the cell value in an Excel file.

REST API

POST https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/{cellName}

Security and Authentication

The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.

Request parameters

Name Type Location Description
name string path Name of the Excel document (including extension).
sheetName string path Name of the worksheet (case‑sensitive).
cellName string path A1‑style address of the target cell (e.g., A1).
value string query Value to assign to the cell.
type string query Data type of the value (int, string, float, etc.).
formula string query Formula to apply to the cell (optional).
folder string query Folder that contains the document (optional).
storageName string query Name of the storage where the file resides (optional).

Response

Return CellResponse.

  • Response Fields Overview
Field Type Description
Name string Address of the cell (e.g., F341).
Row integer Zero‑based row index.
Column integer Zero‑based column index.
Value string The cell’s displayed value.
Type string Data type of the cell (e.g., IsString).
Formula string Formula text if the cell contains a formula.
IsFormula bool Indicates whether the cell contains a formula.
IsMerged bool Indicates whether the cell is part of a merged range.
IsArrayHeader bool Indicates whether the cell is an array header.
IsInArray bool Indicates whether the cell belongs to an array.
IsErrorValue bool Indicates whether the cell contains an error value.
IsInTable bool Indicates whether the cell is inside a table.
IsStyleSet bool Indicates whether a style is applied to the cell.
HtmlString string HTML‑encoded representation of the cell’s value.
Style.link object Hyperlink to the style resource. 
{
  "Status":"OK",
  "Code":200,
  "Cell":{
    "Name":"A1",
    "Row": 0,
    "Column":0,
    "Value": "",
    "Type":"String",
    "Formula" : "=Sum(A2:A15)",
    ...
  }
}

Http Status Codes

Code Meaning Description
200 OK Compression succeeded; response contains compressed file 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.

How to Use the PostWorksheetCellSetValue API with SDKs

PostWorksheetCellSetValue API Specification

The OpenAPI Specification defines a publicly accessible programming interface, which enables developers to invoke REST endpoints directly from a browser or any HTTP client.

You can use the cURL command‑line tool to call Aspose.Cells web services. The example below demonstrates how to set a cell value with cURL.

Use Aspose.Cells Cloud SDKs

Using an SDK speeds up development by handling low‑level details so you can focus on your project. See the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples show how to call Aspose.Cells web services with various SDKs:

Get Merged Cells from an Excel Worksheet – Aspose.Cells Cloud API Set Cell Formula in Excel Worksheets