Requesting assistance with: DataTable. Appreciate it!

[jovanovicParticipant]

What’s the approach to export jqxDataTable data to Excel or CSV in jQuery?

[adminKeymaster]

Hi,

You can use something like this:

$(document).ready(function () {
    // Initialize jqxDataTable (example data)
    $("#myDataTable").jqxDataTable({
        width: 600,
        source: dataAdapter,  // your data adapter or local data
        columns: [
            { text: 'Name', dataField: 'name', width: 200 },
            { text: 'Age', dataField: 'age', width: 100 },
            { text: 'Country', dataField: 'country', width: 200 }
        ]
    });

    $("#exportExcel").on('click', function () {
        $("#myDataTable").jqxDataTable('exportData', 'xls');
    });

    $("#exportCsv").on('click', function () {
        $("#myDataTable").jqxDataTable('exportData', 'csv');
    });
});

Hope this helps.

Regards,
Peter

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

[Author]

Posts