Hi Infragistics Team,
From database, we are getting date and we are displaying it in the grid like this -
{ headerText: "Entry Date", key: "ENTRY_DATE", dataType: "date" }
But, while exporting to excel we are getting NaN for Entry Date column.
however, we have tried cellexporting function but its not working .
Hello Tapas,
It's hard to say what could be going wrong in this case based on the screenshots alone. In our Export to Excel sample we show a date column that is correctly exported. Could you please share a sample that reproduces the behavior that I could look at? Or check our sample for any differences that may result in this behavior.
I am looking forward to your reply. Thank you for using Infragistics forums!
Best regards,
Stamen Stoychev
Hi Stamen,
Below is my function which is getting called on export button click
$("#exportButton").on("igbuttonclick", function () { $.ig.GridExcelExporter.exportGrid($("#csagrid"), { fileName: "test" }, { dataExportMode: "allRows", exportEnding: function (e, args) { var columns = args.worksheet.columns(); columns.item(columns.count() - 1).cellFormat().formatString("dd/MMM/YYYY"); } });})
and below is the code where I am assigning data type as date for date column
columns: [
{ headerText: "CSA #", key: "CSA_NB", dataType: "string" }, { headerText: "Entry Date", key: "ENTRY_DATE", dataType: "date" }
]