Hi,
My column model looks like this:
colModel: [
{ title: "Date Added", width: 100, dataType: "date", dataIndx: "date_of", format: "dd/mm/yy" }
]
My export code looks like this:
function exportGrid() {
var blob = $grid.pqGrid("exportData", {
url: "/api/excel/export.php",
format: "xlsx",
render: true,
type: "blob",
filename: "export",
sheetName: "Export"
});
}
But when I open the Excel file, the date has come through as a string, and I have to manually convert it to a date by couble-clicking in the cell.
Thanks,
Seb