---
title: "Read and write cell values from a workbook"
method: POST
path: "/v1/workbooks/{id}/calc"
tags: ["workbooks"]
---

# Read and write cell values from a workbook

`POST /v1/workbooks/{id}/calc`

Run calculations in a workbook and retrieve cell objects.

## Path parameters

- `id` string, required

## Request body

- CalcRequest
  - `apply` object, nullable — Map of cell references to values. The values are written to cells in the spreadsheet before performing the read operation. You can write numbers, strings, and booleans. Values applied within a request are temporary and affect only that specific request. They are not permanently written to the original spreadsheet. ```json { "apply": { "A1": 10, "A2": 2.718, "A3": "Total", "A4": true, "A5": null }, // ... } ```
  - `read` string[], required

## Response `200`

Successful Response

- CalcObjectResponse — Response type returned by the for /calc query endpoint.

## Other responses

- `400` — Error returned when you make a bad request
- `403` — Error returned when you don't have permission to query a workbook
- `429` — Error returned when you exceed your API rate limit

---

[API](https://skmtc.net/grid-is/apis/grid-api.md) · [All operations](https://skmtc.net/grid-is/apis/grid-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/grid-is/grid-api/versions/2f55490ab23d/schema)