Search

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

Found the answer: https://datatables.net/reference/api/rows().invalidate()

Going to need a bit more information than an empty post to be able to help I'm afraid. If you could link to a test case showing the issue, as indicated in the template text that would be great. Thanks, Allan

Typically Datatables will take care of this for you through its type detection operation. Generally when the sorting behavior is not as expected there is otehr types of data in the column. Do you have null or some other type in the data? Can you provide a link to your page or a test case replicating the issue so we can take a look? If not maybe you can capture a debugger image for the developers to look at. https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case Kevin

Hi Kevin, Thanks a lot regards