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" }
]