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]