jQWidgets Forums

jQuery UI Widgets Forums Grid jqxGrid xls export

This topic contains 3 replies, has 2 voices, and was last updated by  hsnvv 11 years, 3 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • jqxGrid xls export #50587

    hsnvv
    Participant

    Hello.

    How can I export grid data with all columns (hidden columns too) to excel? Is there any parameter to exportdata function, like true/false that will turn on/off hidden columns export?

    Regards,

    jqxGrid xls export #50591

    Dimitar
    Participant

    Hello hsnvv,

    Please refer to this excerpt from the API Documentation about the exportdata method:

    Exports all rows loaded within the Grid to Excel, XML, CSV, TSV, HTML or JSON.

    The first parameter of the export method determines the export’s type – ‘xls’, ‘xml’, ‘html’, ‘json’, ‘tsv’ or ‘csv’.
    The second parameter is the file’s name. If you don’t provide a file name, the Grid will export the data to a local variable.
    For example:
    var data = $(“#jqxgrid”).jqxGrid(‘exportdata’, ‘json’);

    The third parameter is optional and determines whether to export the column’s header or not. Acceptable values are – true and false. By default, the exporter exports the columns header.
    The fourth parameter is optional and determines the array of rows to be exported. By default all rows are exported. Set null, if you want all rows to be exported.
    The fifth parameter is optional and determines whether to export hidden columns. Acceptable values are – true and false. By default, the exporter does not export the hidden columns.
    The sixth parameter is optional and determines the url of the export server. By default, the exporter is hosted on a jQWidgets server.
    The last parameter is optional and determines the char set.

    Best Regards,
    Dimitar

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

    jqxGrid xls export #50593

    hsnvv
    Participant

    Hi, Dimitar.

    “The fourth parameter is optional and determines the array of rows to be exported. By default all rows are exported. Set null, if you want all rows to be exported.” – rows or columns? I need to export hidden columns.

    Thanks,

    jqxGrid xls export #50594

    hsnvv
    Participant

    Sorry, I got it)

    The fifth parameter, what I need)

    Thank your for your help! Good luck!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.