Hi, I have this code: https://snippet.webix.com/dy6e9fm2
I’m trying to export my datatable but I have a problem with the values of “codcli” at line 89, because I want to export the numbers with all the zeros like this “00000004” but in excel it reads like this “4”, Is there a way to convert or format my number into string, so Excel can read my number completely?
you have 2 solutions:
- define
exportType:"string"
to required column to export it ‘as is’ if it is already formatted in source - define
exportType:"number", exportFormat:"00000000"
to achieve required format
https://snippet.webix.com/jk8dqagw