Answers

• allan Posts: 65,287Questions: 1Answers: 10,824 Site admin

  January 2017

  This example shows how you might apply a condition in the customize function.

  Allan
• ttse23 Posts: 10Questions: 3Answers: 0

  January 2017

  This should do the trick!

  $('table.data-table').DataTable({
  
  
    dom: 'Bfrtip',
    buttons: [{
      extend: 'excel',
      text: 'Save as Excel',
      customize: function(xlsx) {
        var sheet = xlsx.xl.worksheets['sheet1.xml'];
        $('row:first c', sheet).attr('s', '7');
        //color the background of the cells if found the value
        $('row c[r^="C"]',sheet).each(function(){
          if($('is t', this).text() =="Not Approved"){
              $(this).attr('s', '15');
          } 
          else if ($('is t', this).text()=="Approved"){
              $(this).attr('s', '12');
          }
          else {
              $(this).attr('s', '34');
          }
         
          
        });