jQWidgets Forums

jQuery UI Widgets › Forums › Grid › Grid Export to Excel

Tagged: , ,

This topic contains 4 replies, has 3 voices, and was last updated by  augusta.bande 5 years, 3 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Grid Export to Excel Posts
  • October 27, 2019 at 5:41 pm Grid Export to Excel #107156

    edilson88
    Participant

    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

    October 29, 2019 at 12:34 pm Grid Export to Excel #107177

    Hristo
    Participant

    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

    November 26, 2019 at 11:14 am Grid Export to Excel #107462

    augusta.bande
    Participant

    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!

    December 5, 2019 at 11:49 am Grid Export to Excel #107506

    Hristo
    Participant

    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

    January 9, 2020 at 3:08 pm Grid Export to Excel #107798

    augusta.bande
    Participant

    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
Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.