excel

parser for uploaded Excel files or loaded as ArrayBuffer

string 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

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;
        }
    }
 }
See also
Back to top