ExportFormat for rows

Webix JS
1

Hi Team

I have a requirement where I need to pass exportFormat just to the row while I export in excel xlsx.

Columns is working fine like below but I need is exportFormat for cell or row

webix.toExcel($$(“table”), {
rawValues:true,
columns:[
{ id:“year”, header:“Released”, exportType:“date”, exportFormat:“d-mmm-yy”},
{ id:“votes”, header:“Votes”, exportType:“number”, exportFormat:"#,##0.00"}
]
});

2

Hello, @Bunny

The fact is that exportFormatworks just with columns. As a solution for the issue, it’s possible to use $export key of Data Scheme, which allows you to work with rows.
Please, check the snippet here: Code Snippet

3

Yes it works perfectly, thank you very much !! Much appreciated.