How to export-to-Excel date data and keep it as Date type instead of String, using Excel Exporter?
0
Hi! Referring to snippet below, column J is exported in DateTime datatype and column K is exported in String datatype. How can I export-to-Excel Date data and it shows as Date format in Excel file instead of General format? I need to remain the export method using Excel Exporter.
asked
Erli Elias
2 answers
0
Hi Erli,
For Estimated Departure you can take decimal attribute type but for Actual Departure you have to take String type.
answered
Mohammad Saqib
0
Hi! Sharing the way how I fix the issue. I'm using Excel Exporter V7.0.5.
The brief summary of the solution:
- Add 'Date' cell format in enumeration XLSReport.CellFormat, so that there is Date option here (in Format dropdownlist of Excel template Styles page), as follow.
- In XLSReport.DataFormatString, add logic to set date-formatted-column in Excel, as follow.
answered
Erli Elias