Data Export

SpreadSheet provides the possibility to export data to Excel, PDF ans PNG formats.

For any of these formats, you need to initialize a SpreadSheet first:

webix.ui({
    id:"ss1",
    view:"spreadsheet",
    data: sheet1_data
});

Then call the corresponding method: toPDF, toPNG or toExcel to export data from SpreadSheet into the file of the necessary format:

for Excel:

webix.toExcel("ss1");

for PDF:

webix.toPDF("ss1");

for PNG:

webix.toPNG("ss1");

Related sample:  Export to .xlsx, .pdf and .png

Exporting Data Offline

The dependencies which are used for providing export possibilities are generally taken from Webix CDN online catalog. If you need to implement data export offline, you should complete the following steps:

webix.cdn = "/local_folder";

Note that specifying the path to the local CDN repository has some peculiarities:

1) in case you set the path relative to the current page, it should be specified as:

webix.cdn = "../../../../local_folder";

2) the absolute path to the repository should be specified as follows:

webix.cdn = "http://localhost/local_folder";
Back to top
If you have not checked yet, be sure to visit site of our main product Webix javascript ui framework
and page of web based spreadsheet product.