Check documentation for the latest version of dhtmlxSuite API Reference DHTMLX Docs

API Reference

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

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).


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:


  • the file's content is:
$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");
Back to top