excel

parser for uploaded Excel files or loaded as ArrayBuffer

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

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;
        }
    }
 }

Back to top