Jexcel Api

Get Data

The following example show how to get the data from a worksheet.
<?php
require 'vendor/autoload.php';

use jexcel\Jexcel;

// You can create an account and generate your keys at www.jexcel.net
define('access_token', 'your-jexcel-api-key');

// Create the Jexcel Api with the Api Key
$client = new Jexcel('ZzAsMzQ0YWI1MmMzZjQwZjQ4MmQ6YWM2Njg3MzgwZWVmNDVkYzExZjJlN1==');

// Get the spreadsheet instance and request configuration
$data = $client->getSpreadsheet('946f23e8-ecd5-459c-b377-cc0c93200457')->getConfig();


Set Data

The following example show how to update the data from a worksheet.
<?php
require 'vendor/autoload.php';

use jexcel\Jexcel;

// You can create an account and generate your keys at www.jexcel.net
define('access_token', 'your-jexcel-api-key');

// Create the Jexcel Api with the Api Key
$client = new Jexcel('ZzAsMzQ0YWI1MmMzZjQwZjQ4MmQ6YWM2Njg3MzgwZWVmNDVkYzExZjJlN1==');

// Get the spreadsheet instance and request configuration
$data = $client->getSpreadsheet('946f23e8-ecd5-459c-b377-cc0c93200457')->getConfig();