Grid Export to Excel

[edilson88Participant]

I’m getting “q.toISOString is not a function” When using exportdata to xls.
Is this something related to version 8.3.2 because I wasn’t having any problem with version 7.1.0.
I’m using JQuery 3.4.1

[HristoParticipant]

Hello edilson88,

Could you provide us with more details?
I tested this demo and it seems to work fine.
With that little detail, I used the version of the jQuery – v3.4.1.
I would like to mention that with the newer versions of the jQWidgets it is not necessary to include the jQuery.

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[augusta.bandeParticipant]

I’m experiencing the same issue… the export works fine for pdf. For csv it works but I receive an empty file while for excel I’m getting “q.toISOString is not a function”, as well.

I have a license and I’m using the save-file.php file locally and the last jqwidgets version.

Could it be connected to empty cells? I mean, cells with value = ”; ? or again could it be an issue generated by using cellsrenderer? By exporting the PDF, I receive empty cells for value = ” even if the cellsrenderer returns something like: return ‘<div style=”text-align: left; margin-top: 5px; margin-left:5px; z-index:1000;”> x </div>’;

Could you provide an example of grid exporting by including the cellrenderer and some empty cells?
Thanks!

[HristoParticipant]

Hello augusta.bande,

You could handle the mentioned issue as you use the mentioned suggestions.
I would like to suggest you skip the import of the jQuery.
Could you clarify what you want to achieve and especially with the cellsrenderer callback?
Also, I would like to suggest you look at this topic:
https://www.jqwidgets.com/community/topic/export-to-xls-cellsrenderer-column/

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[augusta.bandeParticipant]

Hi Hristo,

I found the solution concerning the error “q.toISOString is not a function” and it was connected to the datatype when I prepared the data for the dataAdapter. I set datatype: “json” instead of datatype: “array” and this created the problem. This should solve the issue of edilson88 as well.

Thanks for your tips!

[Author]

Posts