API Reference

Developers might want to set style and configuration for the sheet programmatically. For such cases SpreadSheet provides 2 classes:

SpreadSheet class
SpreadSheetCell class

Usage details

To start using the API libraries, take into account the following important thing:

your script file must contain at least 2 files included: api.php and config.php (the files reside in the 'php' folder at [YOUR_WEB_ROOT]/codebase/ directory).

Example

Let's assume that you name your script file as 'api_usage.php' and place it into 'php' folder. Then:

the file's location is:

spreadsheet/file_location.png

the file's content is:

//api_usage.php
<?php
 
require_once("api.php");
require_once("config.php");
 
$res = new PDO("mysql:dbname=$db_name;host=$db_host", $db_user, $db_pass);
 
$sh = new SpreadSheet($res, "1", $db_prefix);
 
$sh->setValue("B1", 1);
$sh->setValue("B2", "=B1-1");
$sh->setValue("B3", "=B2-2");
$sh->setValue("B4", "=B3-3");
 
?>