Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  May 2019

  Hi @vbalsamello ,

  We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

  Cheers,

  Colin
• kthorngren Posts: 21,989Questions: 26Answers: 5,078

  May 2019

  Please see this FAQ:
  https://datatables.net/faqs/index#buttons

  Kevin
• vbalsamello Posts: 2Questions: 1Answers: 0

  May 2019 edited May 2019

  Thanks it's resolve with the following

  var oldExportAction = function (self, e, dt, button, config) {
                  if (button[0].className.indexOf('buttons-excel') >= 0) {
                      if ($.fn.dataTable.ext.buttons.excelHtml5.available(dt, config)) {
                          $.fn.dataTable.ext.buttons.excelHtml5.action.call(self, e, dt, button, config);
                      }
                      else {
                          $.fn.dataTable.ext.buttons.excelFlash.action.call(self, e, dt, button, config);
                      }
                  } else if (button[0].className.indexOf('buttons-print') >= 0) {
                      $.fn.dataTable.ext.buttons.print.action(e, dt, button, config);
                  }
              };
  
              var newExportAction = function (e, dt, button, config) {
                  var self = this;
                  var oldStart = dt.settings()[0]._iDisplayStart;
  
                  dt.one('preXhr', function (e, s, data) {
                      // Just this once, load all data from the server...
                      data.start = 0;
                      data.length = 2147483647;
  
                      dt.one('preDraw', function (e, settings) {
                          // Call the original action function
                          oldExportAction(self, e, dt, button, config);
  
                          dt.one('preXhr', function (e, s, data) {
                              // DataTables thinks the first item displayed is index 0, but we're not drawing that.
                              // Set the property to what it was before exporting.
                              settings._iDisplayStart = oldStart;
                              data.start = oldStart;
                          });
  
                          // Reload the grid with the original page. Otherwise, API functions like table.cell(this) don't work properly.
                          setTimeout(dt.ajax.reload, 0);
  
                          // Prevent rendering of the full data to the DOM
                          return false;
                      });
                  });
  
                  // Requery the server with the new one-time export settings
                  dt.ajax.reload();
              };
  
  

  And then adding to our dataTable configuraion the ACTION

  "buttons": [{
                      extend: 'excel',
                      text: 'Exportar a Excel',
                      action: newExportAction
                  }],