column each cell issue

[yixiantan]

why the eachCell function only fill the color until 9 row

[zurmokeeper]

@yixiantan Can you post the full code? And the generated excel file?

[yixiantan]

@yixiantan Can you post the full code? And the generated excel file?

i found the each cell function only will return which row that has value, i mean if the second row don have any value, then it only fill up the color for the first row.

If second row have value and third row don have value then it only will fill up the first row & second row color

[zurmokeeper]

@yixiantan Can you post the code instead of a picture?

[yixiantan]

@yixiantan Can you post the code instead of a picture?

ohhh...sry, sure

let workbook = new Excel.Workbook();
    let sheet = workbook.addWorksheet("example");
    const list = ["example 1", "example 2", "example 2"];
    sheet.addRow(list, "i");
    const column = sheet.getColumn(1);

    column.eachCell({ includeEmpty: true }, (cell, rowNumber) => {
      cell.fill = {
        type: "pattern",
        pattern: "solid",
        fgColor: {
          argb: "FF85c8ff",
        },
      };
    });

    let buffer: Excel.Buffer = await workbook.xlsx.writeBuffer();

    let base64 = Buffer.from(buffer).toString("base64");

    return base64;

[zurmokeeper]

@yixiantan You want to set the color for the whole column regardless of whether the cell has a value or not, right?

[yixiantan]

@yixiantan You want to set the color for the whole column regardless of whether the cell has a value or not, right?

ya, but not for whole column, it depend on my first column, like example i just need to set A2 to C9999 column

[yixiantan]

@yixiantan You want to set the color for the whole column regardless of whether the cell has a value or not, right?

is that anywhere to let me get range of cell?

[zurmokeeper]

@yixiantan Are you trying to set the color of all the cells in the range A2-C9999? Is that what you mean?

[yixiantan]

@yixiantan Are you trying to set the color of all the cells in the range A2-C9999? Is that what you mean?

yaya

[zurmokeeper]

@yixiantan Are you trying to set the color of all the cells in the range A2-C9999? Is that what you mean?

yaya

You're a bit of a pain in the ass with this one. It'll take a while.

[yixiantan]

@yixiantan Are you trying to set the color of all the cells in the range A2-C9999? Is that what you mean?

yaya

You're a bit of a pain in the ass with this one. It'll take a while.

I research for this quite long time but still cannot do it

[zurmokeeper]

@yixiantan Instead of answering here in the follow-up, which keeps jumping around, I'll create a new one here with the same question, and I'll respond here in the follow-up. link:

[zurmokeeper]

@yixiantan I've already realized that the comment stays over there。

[yixiantan]

the comment stays o

alright, thanks

[zurmokeeper]

@yixiantan You can try the code and see if it works the way you want it to.

[yixiantan]

@yixiantan You can try the code and see if it works the way you want it to.

it's working fine, thanks

[zurmokeeper]

@yixiantan You can try the code and see if it works the way you want it to.

it's working fine, thanks

@yixiantan You can follow up on this project（excelize）, after all, exceljs has been largely un-updated.