Dear Team,
Using WebExcelExporter i am exporting webdatagrid to excel. It works fine. But when the column contains DATE datatype it is exported as string format. How to convert the date datatype while exporting.
Hi DayanaArul,
There is DisableCellValueFormatting property that is false by default. When it is false, DataFormatString turns objects into string for excel. If you do not want this, set it to true, and the actual date will be the value. Then you may need to set a format on the excel cell or column.
regards,David Young