Maintain the date format in Excel Export

[vijay@spinetechnologies]

Hi Paramvir,

I am trying to bind a pqGrid with date columns. I have mentioned the dataType property as a date for the respective columns. Also, I am formatting the date in the "dd-M-yy, D" format.

The grid is binding properly and showing data as per the given format. But when I try to export the grid in Excel, the generated files lost the data format for the date columns.

For your reference, I'm attaching screenshots. One is with the grid with properly formatted data and the other is after the export.

Kindly provide the solution.

[paramvir]

you need to mention the format in the column definition e.g.,

Code: [Select]

{ title: "Shipped Date", width: 100, dataIndx: "ShippedDate", dataType: "date", format: 'dd-M-yy, D' },


[vijay@spinetechnologies]

Hi Paramvir,

As earlier mentioned, I have applied the format property in the colModel object.

I am facing issues with the Excel Export..
Whenever I export the grid in Excel format, the exported date columns are not in the provided format.

[paramvir]

It works fine in the exported Excel in this example: https://paramquery.com/pro/demos87/export

Please share a small reproducible issue on jsfiddle if still facing issues.

[vijay@spinetechnologies]

Hi Paramvir,

Thanks for the reply. I understand the issue.