webix.toExcel($$("dataTable")) is printing inaccurate numbers

Webix JS
1

0

I am trying to export a datatable as Excel Format using this command.

> webix.toExcel($("coretableCDC"), {
>   filterHTML: true
> });

GUI - Excel
39E76 - 3.9E+77
39E78 - 3.9E+79
4E2FE - 4E2FE
4E300 - 4E+300
4E302 - 4E+302
4E304 - 4E+304
4E306 - 4E+306
4E308 - Infinity
467E1 - 4670
467E3 - 467000
467E5 - 46700000
467E7 - 4670000000
467E9 - 4.67E+11

But for a column ID, there is a different value in GUI and printing differently in Excel.

How do I rectify this having the same value in Excel as in GUI? In the above table I have given only one value as correct which is 4E2FE. I need the same to happen in other places.

2

Hello jeevanus,

You have such result because such values ​​are perceived as hexadecimal numbers, not strings, so you need to set the type as a string directly.
You can set the exportType property as string like this:

      webix.toExcel($$("table"), {
              rawValues:true,
              columns:[
                { id:"title", header:"", exportType:"string"},
              ]
       }

Please take a look at the example : Code Snippet