Loop through row in export excel customize
Loop through row in export excel customize
geethunimesh
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
}
}
});
This discussion has been closed.
Answers
$('row', sheet).each(function() {
if ($(this).find('c[r^="E"]').length > 0) {
if ($(this).text === 0) {
//apply cell color
}
}
});
This is worked.