How to print to PDF with column visibility fixed in code

hwyckoff

I am looking at the example of how to export a table to PDF.

I have a special case where I would like the export to contain only certain columns that I declare in code -- not to be selected by the user. In this case, while many columns are visible on the screen, only -- say, column numbers 2 and 3 would export.

How is this done?

kthorngren

Does this example of using column selectors help?
https://datatables.net/extensions/buttons/examples/html5/columns.html

Kevin

hwyckoff

@kthorngren -- This solves it.

What is the difference between extend: 'pdf' and extend: 'pdfHtml5'?

 {
      extend: 'pdfHtml5',
      exportOptions: {
           columns: [ 0, 1, 2, 5 ]
      }
 },

kthorngren

What is the difference between extend: 'pdf' and extend: 'pdfHtml5'?

This doc discusses the differences:
https://datatables.net/extensions/buttons/built-in

Kevin