Excelnode - styling

General Q&A
1

Hi,

I need to add styling to a row but nothing is reflecting. How do I do that. Below is the code I tried

let headerStyle = workbook.createStyle({
font: {
size: 11,
bold: true
},
//numberFormat: ‘R#,##0.00; (R#,##0.00); -’,
numberFormat: ‘#,##0; (#,##0); -’,
fill: {
type: ‘none’,
color: ‘#FF0800’,
bgColor: ‘#3c77d6’,
fgColor: ‘#3c77d6’
},
});
sheet1.cell(_currentRow, 1).string(‘BILLING RECORDS’).style(headerStyle);

I tried all color options but the row/cell isnt colored.

2

Hi @sisa-zaza

Try using type: "pattern" and patternType: "solid".

let headerStyle = workbook.createStyle({
  font: {
    size: 11,
    bold: true,
  },
  numberFormat: `#,##0; (#,##0); -`,
  fill: {
    type: "pattern",
    patternType: "solid",
    fgColor: "#3c77d6",
  },
});

Let me know if it works for you.