Answers

• allan Posts: 63,133Questions: 1Answers: 10,399 Site admin

  July 2020

  In the getTableData function the table.rows().every( part could be changed to be:

  table.rows({search: ‘applied’}).every(
  

  to get just the filtered data. The code following that could also be modified if you want to get rendered data rather than the raw data for the row.

  Allan
• dascoco Posts: 9Questions: 4Answers: 0

  July 2020

  Thanks works very well.

  Do you also have a short example for rendered data? And I also have a multiple selection on the datatable when I select some rows in PDF export only that ones are exported. Is it also possible for Excel export?
• allan Posts: 63,133Questions: 1Answers: 10,399 Site admin

  July 2020 Answer ✓

  You are largely reimplement what Buttons already has here - I'd suggest looking at using the buttons.exportData() method (it wasn't available back when the example you are working off was originally created). It can be used to orthogonal export and getting selected rows only.

  Allan
• dascoco Posts: 9Questions: 4Answers: 0

  July 2020

  Thank you for suggestion. It gave me the hint what needs to be change.

  I changed in the getTableDatafunction the table.rows().every( part to:

      table.rows({ search: 'applied', selected: table.rows('.selected').any() }).every(function (rowIdx, tableLoop, rowLoop) {
          var renderedData = table.cells(rowIdx, '').render('display');
          var aData = [];
  
          excelExportLayout()[tableID].forEach(function (colID) {
              aData.push(renderedData[colID]);
          });
          ws += buildRow(aData, rowNum, '');
  
          rowNum++;
      });