Datatables.Buttons hide columns in printing and exporting to excel

andrew_safwat

How can i hide the last column in printing and exporting to excel only but appear in the normal viewing

http://jsfiddle.net/andrew_safwat/qokbv1sj/

jLinux

Take a look into the buttons.exportData(), you can specify which columns to export with a column-selector, which takes an array of IDs or Indexes; or a function, which iterates through the columns, and adding those whih you return true on; or a jQuery selector; and a few other types.

andrew_safwat

Thanks a lot jLinux. it works for me

http://jsfiddle.net/andrew_safwat/cn1n060L/

jLinux

Nice! Good job