Cell Values

Get and set values for the spreadsheet cells.

Documentation

Methods

The following methods are available to interact with the spreadsheet cell values programmatically.

Method	Description
getValue	Get the value from one or more worksheet cells. getValue( cellNames: string ): Promise<{ x: number; y: number; name: string; value: string | null }[]> @param cellNames - cell names and/or ranges. GET /api/:guid/value
setValue	Set a new data for your spreadsheet setValue(data: { x: number; y: number; value: string }[]): Promise<void> @param {array} - new data POST /api/:guid/value