[SOLVED] Datagrid Export only specify columns from the grid.

[Franky]

Hi Sir,

Would like to ask, is there possible to export to excel/csv for specify columns only from a datagrid?

Note: I have implemented datagrid with filter and export extension, all working fine after guided by Jarry.

[Franky]

Bump, anyone can please help?

[jarry]

Please specify the 'fields' parameter while calling the 'toCsv' or 'toExcel' methods. Be sure to download a newer version from https://www.jeasyui.com/extension/datagrid_export.php

Code:

$('#dg').datagrid('toCsv', {
    filename: 'datagrid.csv',
    fields: ['itemid','productid'],
    rows: rows,
    footer: [{
        productid: 'Summary',
        listprice: 30
    },{
        productid: 'Summary',
        listprice: 40
    }]
});

[Franky]

Please specify the 'fields' parameter while calling the 'toCsv' or 'toExcel' methods. Be sure to download a newer version from https://www.jeasyui.com/extension/datagrid_export.php

Code:

$('#dg').datagrid('toCsv', {
    filename: 'datagrid.csv',
    fields: ['itemid','productid'],
    rows: rows,
    footer: [{
        productid: 'Summary',
        listprice: 30
    },{
        productid: 'Summary',
        listprice: 40
    }]
});

Hi Jarry,

Thanks again for your help. This new enhancement work pretty good and as expected.
Thanks ya bro!