How to revert the hide logic

tekuii

I need to revert the hide logic.
The default logic is: user clicks on the columns that he doesn't want to show.
What I need: everything loads hidden than user select columns that he wants to show.

My code:

{
extend: "excelHtml5",
text: '<i class="fluigicon fluigicon-file-xls icon-sm">Obra</i> ',
titleAttr: "Exportar para Excel",
className: "btn btn-success",
exportOptions: {
columns: [
300,
301,
302,
303,
304,
305,
306,
307,
308,
309,
310,
311,
312,
313,
314,
],
},
},

kthorngren

Are you asking about only exporting to Excel the visible columns? If so see this exemple showing how to select the exported columns.

Kevin