Documentation Jexcel Api

The Jexcel API is a PHP library to make it possible to publish actions from the backend to the spreadsheet interface and connect its data with any other application. With the API and Jexcel Cloud you would be able to create amazing real-time solutions, such as:

  • Real-time spreadsheet
  • Transform simple spreadsheets in live database relational applications
  • Data persistence and automatic backups
  • Serverless spreadsheets

To use this API you should have a Jexcel Cloud Account where you can generate your secret Access Key and create your online spreadsheets.

Getting started

The Jexcel Client API is available in PHP.

% composer require jexcel/client

Account and Keys

To connect to your spreadsheet and data, you will need the API key and a spreadsheet identifier. The secret API key can be generated using your Jexcel Account. With this key, you can perform any read and write actions to your spreadsheets and data, so it should be used wisely. Non authorized use of your key can create a lot of problems, so be cautious. You are responsible to keep it safe.

Secret Key

You can generate or regenerate your API key on your Jexcel Profile Account.

Unique spreadsheet identifier

You can create a new spreadsheet from your workspace.

Create your first example

require 'vendor/autoload.php';

use jexcel\Jexcel;

// Connect to the API using your secret API key
$jexcel = new Jexcel('ZzAsZzQ0YWI1MmMzZjQwZjQ4MmQ6YWM2Njg3MzgwZWVmNDVkdzExZjJlN1==');

// Get the spreadsheet / first worksheet by default
$spreadsheet = $jexcel->getSpreadsheet('f0a9d5c1-2106-4641-86b1-71c144f61255');

// Get the columns width - (Expected an array with the column width)

// Result [40, 40, 45]