Hello,

I tried to export a grid with a date = '01/01/0001' which is actually a null value in our Oracle database.

When exporting the grid to Excel I see in that column that the date is mentioned as: "Mon Jan 01 1 01:00:00 GMT+0100 (Romance Standard Time)".

I have tried to alter the export method as follows:

cellExporting: function (e, args) {
if (args.columnKey == "expiryDate" && args.cellValue == "Mon Jan 01 1 01:00:00 GMT+0100 (Romance Standard Time)") {
args.xlRow.getCellFormat(args.columnIndex).font().bold(1);
args.xlRow.setCellValue(args.columnIndex, new Date(2055,1,1));
}
},

Above code is setting the date in bold for that specific row, but it is not changing the date as requested.

Is it possible to empty the date field?

I have also noted that in your fiddle example when I try to add a date column with a date = '01/01/0001' it shows in Excel as '01/01/2001' ?

http://jsfiddle.net/h7cw52y0/

Kind regards