Excel export and Dates

[Glen EdwardsParticipant]

I have been looking at the Excel export due to a user raised issue in which fields which are dates that are sent to Excel do not seem to be sorting properly. I ran a quick test with the demo and it seems that date fields seem to be seen by Excel as a String and not a date (although they are formatted like the grid date), so that sorting does not work properly. In the JQWidgets export demo example, Ship Date, although marked as a date in the grid seems to be exporting as a String, so does not sort in date order but as a string.


<Cell ss:StyleID="xls-style-11"><Data ss:Type="String">3/6/2014</Data></Cell>


I am guessing that this is to preserve the formatting. Was wondering if anyone has a work around for this? I’d like the formatting but also be able to sort.

Thanks
Glen

[Peter StoevKeymaster]

Hi Glen,

We export the Dates as Strings to keep the Formatting as in the Grid. No, there’s no workaround about that as we implemented it on purpose.

Best Regards,
Peter Stoev

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

[Mircea GiurgiuParticipant]

Hi,
I was trying to export into Excel a grid with columngroup in header of grid but columngroup is not export in Excel.
Have you any idea to get it?
Thanks
Mircea Giurgiu

[Peter StoevKeymaster]

Hi Mircea,

We don’t export it. Excel Export feature exports the Grid as an Excel Table.

Best Regards,
Peter Stoev

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

[tukangParticipant]

Hi..
Is there anyway to customize the column on the file we exported to excel ?
example :
i have 10 columns ini the jqxgrid, but when i hit the export to excel button and i can customize it to only show 8 columns and the other 2 is hidden.
is that posible ?

Thanks,
Tukang

[Peter StoevKeymaster]

Hi Tukang,

Each column has exportable property. You can set it to false in case you do not wish a column to be exported.

Best Regards,
Peter Stoev

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

[tukangParticipant]

OK, Thank YOu

[Author]

Posts