Skip to main content
POST
/
v1
/
workbooks
/
{id}
/
calc
JavaScript
import Grid from '@grid-is/api';

const client = new Grid({
  apiKey: 'My API Key',
});

const response = await client.workbooks.calc('id', { read: ['A1'] });

console.log(response);
{}
Use this endpoint if you need detailed cell objects that include raw values, value types, format strings, and cell positional offsets. If you only need cell values, try the values endpoint.

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

​
id
string
required

Body

application/json
​
read
string[]
required

A1-style cell reference, cell range, or formula that references cells in a sheet. References can be relative, mixed, or absolute. References may include a sheet prefix

​
apply
object | null

Response

Successful Response

Response type returned by the for /calc query endpoint.

​
{key}
Examples:
{
  "formatted": "€6,378.32",
  "offset": [0, 0],
  "type": "number",
  "value": 6378.32
}
⌘I