Calculate Cell Formula

This REST API calculates the cell formula in an Excel workbook.

REST API

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

Request Parameters

Parameter Name	Type	Parameter location (path/query/body)	Description
name	string	path	Name of the Excel file (e.g., `Book1.xlsx`).
sheetName	string	path	Name of the worksheet that contains the cell.
cellName	string	path	Address of the cell to be calculated (e.g., `A1`).
options	object	body	JSON object with calculation options (see Options object table).
folder	string	query	Folder in storage where the file is located.
storageName	string	query	Name of the Aspose Cloud storage.

Options object

Field	Type	Description	Default
CalcStackSize	string	Maximum calculation stack size.	`"1"`
IgnoreError	boolean	If `true`, calculation errors are ignored and the cell value is set to `#N/A`.	`false`
Recursive	boolean	Enables recursive calculation of dependent cells.	`false`
Precision	string	Number of decimal places for numeric results.	`"15"`
UseThreading	boolean	Enables multi‑threaded calculation.	`false`

Request example (cURL)

Request

curl -v "https://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/cells/A1/calculate" \
  -d '{"CalcStackSize":"1"}' \
  -X POST \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>"

Response

{
  "Code": 200,
  "Status": "OK",
  "Value": 123.45,
  "Formula": "=SUM(B1:B5)",
  "IsError": false
}

Error handling

HTTP Status	Code	Message	Example body
400	4000	Bad Request – missing or invalid parameters.	`{ "Code": 4000, "Message": "The parameter 'name' is required." }`
401	4010	Unauthorized – invalid or expired JWT token.	`{ "Code": 4010, "Message": "Access token is invalid or has expired." }`
404	4040	Not Found – the specified file, worksheet, or cell does not exist.	`{ "Code": 4040, "Message": "File 'Book1.xlsx' not found." }`
500	5000	Internal Server Error – unexpected server condition.	`{ "Code": 5000, "Message": "An unexpected error occurred." }`

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

Cloud SDK Family

Using an SDK is the best way to speed up development. An SDK abstracts 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 call Aspose.Cells web services using various SDKs:

Set Cell Formula in Excel Worksheets Clear Cell Formatting in an Excel Worksheet