Excel Export: Adding background color to a cell if meets a condition

vemon

Hello! How would I go about adding a background color using the customize function to add a background color if the cell in the table meets the requirements? For example, a column called **replay **has values of "Approved", "Overturned", and "Check Supervisor". Approved => Green, Overturned => Yellow, Check Supervisor => Blue.

allan

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

Allan

ttse23

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');
        }
       
        
      });