JavaScript equivalent of finding the last row

wilsojoh

New Member
Joined
Aug 31, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Is there a JavaScript equivalent of the VBA method to find the last row?

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

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Yes there is.

JavaScript:
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.
 
Upvote 0
Yes there is.

JavaScript:
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,695
Messages
6,192,475
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top