How to style first row?

[matze1708]

Hi guys,

how it is possible to style the first row?

i´d try this

          const CellOptions = {
            font: {
              name: 'Arial',
              sz: 10,
              bold: true,
              color: { rgb: "FFFFFFFF" }
            },
            fill: {
              bgColor: { rgb: "FF59AB44" },
              fgColor: { rgb: "FF59AB44" },
            },
            alignment: {
              wrapText: true
            },
          };


      WS['A1'].s = CellOptions;

but what i do for A1 i need A1 to K1

Thanks you

[pietersv]

If you know the extent, you can iterate over each cell, e.g.
"ABCDEFGHIJK".split('').forEach(c=>WS[c+'1'].s = CellOptions)