How to get last column of specific row?

[quangtho2910]

I know we can use usedRange().endcell().columnNumber() to get the last column of workbook. But I want to get the last column of specific row. Can we do that in xlsx-populate?

[Akxe]

Excel does not store this information... you can get the last item of row by row._rows[row._rows.length - 1], but this is not 100%. It will give you the last cell with its own value. This excludes cells that are merged.

[quangtho2910]

@Akxe I tried workbook.sheet("Sheet1").row(1)._rows[row(1)._rows.length - 1] But I got an error

row is not defined

[Akxe]

You did not make the row variable... you have to define it...

const row = workbook.sheet("Sheet1").row(1);
row._rows[row._rows.length - 1];

[quangtho2910]

@Akxe Thank you but still the same ...

Cannot read property 'length' of undefined

[quangtho2910]

Here is my code:

XlsxPopulate.fromFileAsync("Filename")
.then(workbook => {
    const row = workbook.sheet("Sheet1").row(1);
    console.log(row._rows[row._rows.length - 1])
});

[Akxe]

Are you sure that there is "Sheet1" in workbook.sheet()?

[quangtho2910]

Yes, I am sure. If there is no "Sheet1" the error would be "Cannot read property 'row' of undefined". Not "Cannot read property 'length' of undefined"

[quangtho2910]

I found the way @Akxe The code should be: XlsxPopulate.fromFileAsync("Filename") .then(workbook => { const row = workbook.sheet("Sheet1").row(1); console.log(row._cells[row._cells.length - 1]._columnNumber) });

[Akxe]

Then it is because the row does not have any columns... From what I remember there is a lot of lazy defining of internal variables.

Hmm... Rows of row... The whole time you should be getting _cells

[quangtho2910]

Yes, my code works so I think that is the way to get the last column of the specific row. Thank you so much @Akxe . Based on your answer I found a way to solve my problem!

[Akxe]

Please close the issue then 😊