Data Export

SpreadSheet data can be exported to Excel, PDF, CSV, and PNG formats. Call the corresponding method: toPDF, toPNG, toExcel, or toCSV to export data from SpreadSheet into the file of the necessary format. For example, for Excel:

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

By default, SpreadSheet data are exported to any format with the following settings:

• header:false - the sheet header is not exported
• rawValues:true - all dataset columns are exported
• spans:true - column and row spans are exported
• styles:true - styles are exported
• math:true - math formulas are exported
• ignore:{ rowId:true } - the column with row ids isn't exported
• hidden:true - hidden rows and columns are hidden in the Excel file and can be shown by its controls

You can change this behavior by specifying the desired settings as an object in the second parameter of the export methods. For example:

webix.toExcel("ss1", options);

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

Export to Excel Settings

SpreadSheet a range of settings for exporting data into an Excel file.

• math formulas

You need to set the math:true property in the second parameter of the toExcel method.

webix.toExcel($$("ss1"),{ math:true});

• cell styles

The styles are exported by default. If you do not want to, set the styles option to false in the second parameter of the toExcel method.

webix.toExcel($$("ss1"), { styles:true });

• conditional formatting

It is possible to export styles of conditional formatting if the conditions option is set to true (default).

webix.toExcel($$("ss1"), { conditions:true });

• column and row spans

The spans are exported by default. If you do not want to, set the spans:false property in the second parameter of the toExcel method:

webix.toExcel($$("ss1"), { spans:true });

• hidden columns and rows

Hidden columns and rows are exported as hidden to Excel and can be shown in the file by its controls. If you want to ignore them, set the hidden property to false:

webix.toExcel($$("ss1"), { hidden:false });

• row heights

This setting is set to false by default and can take the following values:

• true - to export only custom row heights (different from the default rowHeight);
• "all" - to export both custom and default row heights;
• false - default, row heights are not exported.

webix.toExcel($$("ss1"), {
   heights:true
});

In case the styles:true option is set, the heights option is automatically set to "all".

• multiple sheets

By default, Spreadsheet exports the currently active sheet to an Excel file. You can have three more possible options:

1) to export all the sheets, set the sheets:true option in the second parameter of the toExcel method:

webix.toExcel($$("ss1"), { sheets:true });

2) to export separate sheets, set an array with sheets ids as a value of the sheets option:

webix.toExcel($$("ss1"), { sheets:[ "s1","s2" ] });

3) to export a certain sheet, set its id as a value of the sheets option:

webix.toExcel($$("ss1"),{sheets:"s2"});

• the header of a sheet

By default the header of a sheet is not exported. To export the content of a header, you need to use the header option and set it to true:

webix.toExcel($$("ss1"), {
   header:true
});

• stub cells

You can stub empty cells. When an empty cell is stubbed in the exported file it keeps its space empty and the content of the adjacent cells cannot overflow it. To stub cells, set the stubCells property to true:

webix.toExcel($$("ss1"), {
   stubCells:true
});

Export to PDF Settings

While exporting SpreadSheet to PDF document you can configure the following settings:

• math formulas

You need to set the math:true property in the second parameter of the toPDF method.

webix.toPDF($$("ss1"),{ math:true});

Note that if you set the option to false, formula value wll be exported - not the formula itself.

• cell styles

If you want to export cell styles, set the styles option to true in the second parameter of the toPDF method.

webix.toPDF($$("ss1"), { styles:true });

• conditional formatting

It is possible to export conditional formatting if the conditions option is set to true (default).

webix.toExcel($$("ss1"), { conditions:true });

• row spans

If you want to export row spans, set the spans:true property in the second parameter of the toPDF method:

webix.toPDF($$("ss1"), { spans:true });

• hidden columns and rows

By default hidden columns and rows are not included during export. You can include them by setting the hidden property to true:

webix.toPDF($$("ss1"), { hidden:true });

The hidden columns/rows will be visible in the exported file.

• row heights

This setting is set to false by default and can take the following values:

• true - to export only custom row heights (different from the default rowHeight);
• "all" - to export both custom and default row heights;
• false - default, row heights are not exported.

webix.toPDF($$("ss1"), {
   heights:true
});

In case the styles:true option is set, the heights option is automatically set to "all".

• multiple sheets

By default, Spreadsheet exports the currently active sheet to a PDF file. You can have three more possible options:

1) to export all the sheets, set the sheets:true option in the second parameter of the toPDF method:

webix.toPDF($$("ss1"), { sheets:true });

2) to export separate sheets, set an array with sheets IDs or sheet objects as a value of the sheets option:

webix.toPDF($$("ss1"), { sheets: [
  {id:"Sheet1", options:{display"image"}},
  {id:"Sheet2"},
  "Sheet3"] 
});

3) to export a certain sheet, set its id as a value of the sheets option:

webix.toPDF($$("ss1"),{sheets:"s2"});

• the header of a sheet

By default the header of a sheet is not exported. To export the content of a header, you need to use the header option and set it to true:

webix.toPDF($$("ss1"), {
   header:true
});

Exporting Data Offline

You can export SpreadSheet data offline. To enable this possibility, you should follow the common way for all data components.

Back to top