datatable remove column on export to pdf and excel

Question

i have a problem when remove column before export to pdf,excel. and second problem that because of this column the reverse of column doesn't work right here is the code i use

Answer 1

When we are using jquery datatable for displaying data in datatable and export datatabel information into PDF,Excel or CSV we might be exclude or hide some columns. So, here i will give you demo how to remove or hide columns when exporting data when using jquery.

In this example the copy button will export column index 1 and all visible columns, the Excel button will export only the visible columns and the PDF button will export column indexes 1, 2 and 4 only.

Column visibility controls are also included so you can change the columns easily and see the effect of the export options.