title: How change background color of complete row in excel export of datatables?
body: <p>Hi im trying to set a background color to a complete row in a excel document exported with datatables, By now, i can paint just one cell. </p>
  
  <p>this is the code for the excel export, i iterate the column where is the value to validate and then change the color.</p>
  
  <pre><code> $.extend( $.fn.dataTable.defaults, {
            responsive: true,
            dom: 'Bfrtip',
            buttons: [
            {
              extend: 'copy',
              text: 'Copiar',
              className: 'copyButton'
            }, 
            { 
              extend: 'excel',
              text: 'Excel',
              className: 'excelButton',
              customize: function ( xlsx ) {
                    var sheet = xlsx.xl.worksheets['sheet1.xml'];
                        $('c[r=A1] t', sheet).text( 'INVENTARIO - '+document.getElementById('titulo').textContent) ;
                       $('row c[r^="A"]', sheet).each( function () {
                          // Get the value
                        var prueba='prueba' ;
                          if ( $( this).text() == '1' ) {
                             $(this).attr( 's', '15' );
                             //   $(this).text( 'CUSTODIA' );
                              console.log("ENTRO");
                           //   $('row c[r*="4"]', sheet).attr( 's', '15' );
                          }
                      });
                },
                  exportOptions: {
                  columns: [ 7, ':visible' ]
                  },
            filename: function() {
  
                    return 'INVENTARIO - '+document.getElementById('titulo').textContent ;
  
              }
  
            }
  </code></pre>
  
  <p>This is what i´ve made<a href="https://i.stack.imgur.com/MivBk.png" rel="nofollow noreferrer">Excel with one cell painted</a></p>
  
  <p>But i need to paint the full row.
  Thanks any help or sugestion</p>