jQuery DataTables: exporting individual columns to Excel

Question

On a web page I am displaying a list of topics created by the website users with only their titles listed. I can export to excel the whole table using TableTools and it works fine. However, some of the columns are not required, and I would like to hide some of them somehow. In a perfect situation I would like to display a small popup window when a user clicks the "XLS" button, with several checkboxes with respective table headers and a button "Export". This way the user can select only the necessary data for export. Can someone direct me, please?

Is it possible to export individual columns to Excel in jQuery DataTables?
Is it possible to export a column that was previously hidden using the fnSetColumnVis function?

dnagirl · Accepted Answer · 2011-11-21 21:31:18Z

9

When you define your buttons in oTableTools, you can set which columns to export:

"oTableTools":{
    'aButtons':[
        {'sExtends':'xls',
         'mColumns':[1,2,7,23] //set which columns here
        },
        {'sExtends':'pdf',
         'mColumns':'visible' //set which columns here
        },
                                ]
}

The docs are here.

answered Nov 21, 2011 at 21:31

dnagirl

20.5k13 gold badges86 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

parrker9 Over a year ago

Thanks a lot! This helped, especially the link!

Abu Sadat Mohammed Yasin · Accepted Answer · 2012-07-11 07:46:38Z

See the following code block, hope it will help you.

$(document).ready( function () {    
    $('#datagridtable').dataTable( {
        "sDom": '<"H"Tfr>tC<"F"ip>',

        "oColVis": {
            "buttonText": "&nbsp;",
            "bRestore": true,
            "sAlign": "right"
        },
        "oTableTools": {
            "sSwfPath": "datagrid/media/swf/copy_csv_xls_pdf.swf",
            "aButtons": [ 
                {'sExtends':'xls',
                    'mColumns':'visible' //set which columns here
                }, 
                {'sExtends':'pdf',
                    'mColumns':'visible' //set which columns here
                },
                {'sExtends':'print',
                    'mColumns':'visible' //set which columns here
                }, ]
        }
    } );
} );

Collectives™ on Stack Overflow

jQuery DataTables: exporting individual columns to Excel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related