Answers

• kthorngren Posts: 21,132Questions: 26Answers: 4,918

  July 2020

  See if this thread asking a similar question helps.

  Kevin
• @nuj_3313 Posts: 15Questions: 5Answers: 0

  July 2020 edited July 2020

  No... that is different requirement.
  My requirement is to force user to hide some column using colvis button while exporting to pdf if trying to export more than n no of columns.
  Please help
• kthorngren Posts: 21,132Questions: 26Answers: 4,918

  July 2020 edited July 2020 Answer ✓

  Here are some ideas:

  You can use the column-visibility event to determine if the number of visible columns, using columns().visible(), is good for export. You could use button().enable() and button().disable() based on the number of visible columns.

  You can use buttons.buttons.action to determine the number of visible columns, using columns().visible(), and execute the export if the number is good. See the third example in the buttons.buttons.action docs.

  There are probably other ways you can combine these to meet your requirements.

  Kevin
• @nuj_3313 Posts: 15Questions: 5Answers: 0

  July 2020 edited July 2020

  Got it Thanks @kthorngren
  I have used buttons.buttons.action and jquery to get the no of column like below

     buttons: [{
     extend: 'pdf',
     text: 'Create pdf',
     action: function ( e, dt, node, config ) {
     var columnCount = 0;
     $("table#tableId thead tr.className th").each(function(){
      columnCount++;
  });
  if(columnCount > 15){   
         alert('message');
         return false;
      }
     $.fn.dataTable.ext.buttons.pdfHtml5.action.call(this, e, dt, node, config);
   }}, 'colvis']