JavaScript equivalent of finding the last row

[wilsojoh]

Is there a JavaScript equivalent of the VBA method to find the last row?

finalRow = cells(rows.count, 1).End(xlUp).row

 

[VBE313]

Yes there is.

const ws = context.workbook.worksheets.getItem("Sheet1");
let getLastCell = ws    
      .getCell(0, 1)
      .getEntireColumn()
      .getUsedRange(true)
      .getLastCell()

by setting getUsedRange to true, it will grab the last cell that has a value in it.

 

[wilsojoh]

Yes there is.

const ws = context.workbook.worksheets.getItem("Sheet1");
let getLastCell = ws   
      .getCell(0, 1)
      .getEntireColumn()
      .getUsedRange(true)
      .getLastCell()

by setting getUsedRange to true, it will grab the last cell that has a value in it.

Thank you. I use the find last row all the time as I mainly deal in consistent data frames.

 

[VBE313]

Thank you. I use the find last row all the time as I mainly deal in consistent data frames.

you are welcome. I have been playing around with the new Excel TypeScript macros. They are fun but definitely have a learning curve.