Loop through row in export excel customize

Loop through row in export excel customize

geethunimeshgeethunimesh Posts: 25Questions: 9Answers: 0

Is it possible to loop row and format column wise in excel export
$('row c', sheet).each(function () {
if ($(this).find('[r^="E"]')) {
if($(this).text===0){
//apply cell color
}
}
});

Answers

  • geethunimeshgeethunimesh Posts: 25Questions: 9Answers: 0

    $('row', sheet).each(function() {
    if ($(this).find('c[r^="E"]').length > 0) {
    if ($(this).text === 0) {
    //apply cell color
    }
    }
    });
    This is worked.

This discussion has been closed.