How to apply row formatting into customize xlsx

jacek_k

I have question how I can apply that:

createdRow: function( row, data, dataIndex){

                        if ( data.desc == "--" ) {        
     $('td', row).css('background-color', 'orange');

   }
   if ( data.desc == "---" ) {        
     $('td', row).css('background-color', 'green');

   }
   if ( data.desc == "-" ) {        
     $('td', row).css('background-color', 'gold');

   }

                    },

into customize xlsx:

var sheet = xlsx.xl.worksheets['sheet1.xml'];

                $('row c', sheet).attr('s', normal);

                $('row:nth-child(2) c', sheet).attr('s', head);

colin

This thread should help, it's asking the same thing.

Cheers,

Colin