How to Modify DataGrid Export Function

[poeziafree]

Hello

Please, let me know how to Print/Download Excel file of the datagrid when serverside paging is enabled?

It only prints/downloads the current page.

Thank you in advance!

[jarry]

Retrieve all the rows from the server site and then export to excel with the 'rows' parameter.

Code:

// export with customized rows
$('#dg').datagrid('toExcel', {
    filename: 'datagrid.xls',
    worksheet: 'Worksheet',
    caption: 'Caption',
    fields: ['itemid','productid'],
    rows: rows,
    footer: [{
        productid: 'Summary',
        listprice: 30
    },{
        productid: 'Summary',
        listprice: 40
    }]
});