excel

parser for uploaded Excel files or loaded as ArrayBuffer

object excel;

Available only in PRO Edition

Example

$$('mylist').data.driver = webix.DataDriver.excel;
$$('mylist').load("binary->files/data.xlsx");
// it is the same as
$$('mylist').load("binary->files/data.xlsx", "excel");

Related samples

Excel Viewer
Excel Proxy
Excel File Uploading and Downloading
Import from Excel

Details

The Excel data driver is available in the PRO version only.

The object contains methods and properties for correct processing Excel file. Basically, it parses Excel file data into a plain jsarray.

webix.ui({
    view:"list",
    id:"mylist",
    url:"binary->files/data.xlsx",
    datatype:"excel"
});

Excel file should be loaded with the help of binary proxy or the uploaded File contents should be parsed:

 { view:"uploader", value:"Select Excel File", width:200,
    on:{
        onBeforeFileAdd:function(upload){
            $$("excel").clearAll();
            $$("excel").parse(upload.file, "excel");
            return false;
        }
    }
 }