Date is exported as 'string' in Excel export

[singhjogaParticipant]

Hi,
Somehow the date is always exported as a String when I export to an excel file. I tried the online demos also, there also I am getting the same output. Below is the sample output from the online demo.

<Row>
  <Cell ss:StyleID="xls-style-4"><Data ss:Type="String">Sven</Data></Cell>
  <Cell ss:StyleID="xls-style-4"><Data ss:Type="String">Saavedra</Data></Cell>
  <Cell ss:StyleID="xls-style-4"><Data ss:Type="String">Doubleshot Espresso</Data></Cell>
  <Cell ss:StyleID="xls-style-5"><Data ss:Type="String">false</Data></Cell>
  <strong><Cell ss:StyleID="xls-style-6"><Data ss:Type="String">9/23/2013</Data></Cell></strong>
  <Cell ss:StyleID="xls-style-7"><Data ss:Type="Number">9</Data></Cell>
  <Cell ss:StyleID="xls-style-8"><Data ss:Type="Number">3.3</Data></Cell>
</Row>

Here the Type is String, which means, when I open the file in Excel, I cannot change the date format to other formats effectively.

Joga

[Peter StoevKeymaster]

Hi Joga,

It is exported to String as it is supposed to display the Dates in exactly the same Format as they’re dispalyed in the Grid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts