trouble with grid values export to excel

[Administrator]

HI,

I have a trouble with a essential grid when i export to excel, i use essential grid and export to excel method, my version of component is 6.4.0.15


GridExcelExport excel = new GridExcelExport(this.GridGroupingControl1, "example.xls");
excel.ExportNestedTable = true;
excel.Export();


i have two columns Entrada1 and Salida2 this columns are datatype double, but whe i export to excel y saw in datetime format.

why?
how can i resolve this?



Dibujo_480e81f1.zip

[Rekha P]

Hi Gabriel,

Thank you for your interest in Syncfusion Products.

In the attached screen shot, the columns Entrada1 and Salida2 seems to be in datatype of "time" which stores the hour, minute, and second values with colon (:). The data type "double" specifies Double-precision floating point number.

Please refer a simple sample below which illustrates the records with "double" data type and exporting it to excel.

http://files.syncfusion.com/support/GGC.Web/7.1.0.30/F80702/Sample.zip

Please let me know if this helps you.

Thanks,
Rekha