Condition based data export from datatable to excel

prasadhari009

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

prasadhari009

please help

tangerine

Please explain your requirements in sufficient detail.

prasadhari009

prasadhari009

based on deliquent value 'D', i want to export excel with current-delinquent values with only 'D'

allan

That is done with the rows option of buttons.exportData(). The easiest method would be to provide a function for the rows selector (see row-selector) which will only select rows with a D.

Allan

prasadhari009

I need below logic inside export options then only i can able to export excel of columns having values with D but after placed in export options its showing warning..

var indexes = table.rows().eq(0).filter(function (rowIdx) {
return table.cell(rowIdx, 7).data() === 'D' ? D : C;
});

please help me!!!!
thanks
hari

kthorngren

Allan means something more like this:

      {
        extend: 'excel',
        exportOptions: {
          rows: function ( idx, data, node ) {
            return data[1] === 'Software Engineer' ?
              true : false;
          }
        }
      },

See this example:
http://live.datatables.net/witizici/1/edit

Kevin

prasadhari009

{
  extend: 'excel',
  exportOptions: {
    rows: function ( idx, data, node ) {
      return data[7] === 'D' ? true : false;
    }
  }
},

this is working fine

thanks kevin

hari