Search

I can only send you a link to a test page. Will send the details to you and Allan in a private message tomorrow morning. Thanks.

OK, appreciate you letting us know. Colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here. Cheers, Colin

Thanks

Thank you, this solve my problem.

Odd, it works for me here using Chrome and FF. What browser are you using? Colin

@Jatin : here you go, Colin

You will need customization and use the export options: https://datatables.net/reference/button/excelHtml5#Customisation https://datatables.net/reference/api/buttons.exportData() https://datatables.net/extensions/buttons/examples/html5/columns.html If you take a look at this thread you would need "customizeData" to add further rows to print / export. https://datatables.net/forums/discussion/comment/147595/#Comment_147595 It is described here in the docs: Something like this could be the structure of it: exportOptions: { columns: function(column, data, node) { if (column > 17) { //no export of columns > 17 return false; } return true; }, modifier: { selected: null }, //export all rows not only the selected ones format: { body: function ( data, row, column, node ) { ... do something return data; }, header: function ( data, column ) { ... do something return data; }, footer: function ( data, column ) { ... do something return data; } }, customizeData: function (data) { ... manipulate the data object } }

Placement of DT elements is controlled by the dom options: https://datatables.net/reference/option/dom Otherwise, use your browser's inspect tool to see what styling is applied and amend or override it to suit your needs.

Use columns.visible, column().visible() or the column visibility button depending on when and how you want to hide the columns. Kevin