Colvis and dataexport buttons

JochenK

Hi ...,
My data table consists of 15 columns. With colvis I hide 10 columns so that I only have 5 columns in the display.
When using the buttos print, csv,excel and pdf all columns are put on the list. However, I only want to have the 5 visible columns in the printout. How i can do this ?

kc5151

You can use a column selector to achieve this: https://datatables.net/extensions/buttons/examples/html5/columns.html

allan

Specify :visible as the column selector for the export buttons. See this example.

Allan

JochenK

That's the solution, so simple ... I should have known it myself, thank you very much

allan

@kc5151 - Apologies, looks like we posted at almost the same time!

@JochenK - Good to hear you got it working.

Allan