Spreadsheet Data
Get and set data to and from your online spreadsheets.Documentation
Methods
The following methods are available to interact with the spreadsheet headers programmatically.Method | Description |
---|---|
getData | Get the data from the worksheetJspreadsheet getData(): Promise<{ id: string, row: number, data: string[] }[]> GET /api/:guid/data
|
setData | Set a new data for your worksheet @param data - new data Jspreadsheet setData(data: (string[] | { row: number; data: string[]; })[]): Promise<void> POST /api/:guid/data
|
Examples
Get the spreadsheet data
The following example show how to get the data from a worksheet.import { Client } from "@intrasheets/client"; // Create a new client const client = new Client({ // API Server baseUrl: "http://localhost:8009/api", // Your authentication token token: "eyJhbGciOiJIUzUxMiIsInR5cCJ9.eyJkb21haW4iOiJsb2NhbGhvc3Q6ODAPQSJ9.Xr2Ir2-zEc_tqV5y6i", }); // Spreadsheet Guid const guid = '79b45919-c751-4e2b-a49a-6c1286e2fc03'; // Get the spreadsheet instance const spreadsheet = client.getSpreadsheet(guid); // Request data spreadsheet.getData().then((data) => { console.log(data); });
Set the spreadsheet data
The following example show how to update the data from a worksheet.import { Client } from "@intrasheets/client"; // Create a new client const client = new Client({ // API Server baseUrl: "http://localhost:8009/api", // Your authentication token token: "eyJhbGciOiJIUzUxMiIsInR5cCJ9.eyJkb21haW4iOiJsb2NhbGhvc3Q6ODAPQSJ9.Xr2Ir2-zEc_tqV5y6i", }); // Spreadsheet Guid const guid = '79b45919-c751-4e2b-a49a-6c1286e2fc03'; // Get the spreadsheet instance const spreadsheet = client.getSpreadsheet(guid); // Set Data spreadsheet.setData([['1', '2', '3']]).then(() => { // It worked correctly }).catch((err) => { // Something went wrong console.log(err); });