Export to excel issue

[KgdkParticipant]

Hi all,
I am dynamically constrcuting a HTML table and on load of of my page I am converting it to a jqxDataTable. Everything works fine.
But when I download the content as excel I am facing some issue.If the cell content contains any special characters like (.,:,; etc) The data does not appear properly in the excel.
Eg: If the cell data is vg:cd only vg appears , Similarly if data is 0.934,1.2 only 0 appears in the excel.
I have tried setting the characterset to utf-8 in export settings, It doesn’t seem to work, Please Help
Thanks in Advance.

[Peter StoevKeymaster]

Hi Kgdk,

“characterSet” property of the exportSettings object may need to be set to something in your scenario.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts