How to apply row formatting into customize xlsx
How to apply row formatting into customize xlsx
jacek_k
Posts: 6Questions: 1Answers: 0
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);
This discussion has been closed.
Replies
This thread should help, it's asking the same thing.
Cheers,
Colin