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

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

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

console.log(response);
{}
Use this endpoint if you need formatted cell values. If you need more detailed cell objects, try the calc 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 /values query endpoint.

​
{key}

Excel cell value. This can be a number, string, boolean, or blank

Examples:

1234

1234.56

"Hello, world!"

true

⌘I