Getting-started
The Jspreadsheet Client API is available in PHP or NodeJS.NodeJS
PHP
How to install
% npm install @jspreadsheet/client
Simple example
Before start please make sure the spreadsheet has public visibility or, you have the appropriate permissions. For the study of the data operations, please consider the following public spreadsheet.import { Client } from "@jspreadsheet/client"; // Access token const token = 'MSwzMTJmZWQzMWYyYTI1OWQ5OGVhMWYxOWNhMDNhYWY3ZTA2ZmVmMWQz'; // Spreadsheet Guid const guid = '15eb1171-5a64-45bf-be96-f52b6125a045'; // Create a new client const client = new Client({ token }); // Get the spreadsheet instance const spreadsheet = client.getSpreadsheet(guid); spreadsheet.getWidth().then((result) => { console.log(result); }); // Result [40, 40, 45]
How to install
% composer install jspreadsheet/client
Simple example
Before start please make sure the spreadsheet has public visibility or, you have the appropriate permissions. For the study of the data operations, please consider the following public spreadsheet.<?php require 'vendor/autoload.php'; use jspreadsheet\Jspreadsheet; // Access token $token = 'MSwzMTJmZWQzMWYyYTI1OWQ5OGVhMWYxOWNhMDNhYWY3ZTA2ZmVmMWQz'; // Spreadsheet Guid $guid = '15eb1171-5a64-45bf-be96-f52b6125a045'; // Create a new client $client = new Jspreadsheet($token); // Get the spreadsheet instance $spreadsheet = $client->getSpreadsheet($guid)->getColumns()->getWidth(); // Result [40, 40, 45]