Excel Office Script - Find Last Row, Last Column (JavaScript, TypeScript)

Excel Office Script: how to find last row, last column and other constrains of data using JavaScript (TypeScript).

#excel #script #office

[MarissaTuttle]

you have no idea how long i searched for this exact thing!!!! Thank you so much!

[josericardo]

Tks for the video!
I would like very much watching more and more Office Scripts videos

[senormanana]

Great! It helps a lot to get the idea! Thanks

[guillermosepulvedaf]

Excellent tutorial, thanks!! Can you please explain how how obtain the row number of the selected cell??

[IAlzady]

Hello, firstly thank you so much. My question: I am trying to copy and paste a value from the same sheet but to a different cell. I understand that you are using static values such as ["Line 5"...]. For example, every week my cell C26 changes, I want to copy and paste that value to B51 (my last row), then the following week copy C26 to B52 with an expanding table. Do you have an idea on how to do that?

[sabarashid]

Hi, thank you for the video. I get an error on line 5 : Cannot read properties of undefined (reading 'getUsedRange'). Mine are pivot tables on a sheet I need to find the upper and lower range for further automation.
Can you please help?

[prakhargupta]

hi sir, i want to ask how do we reach the last used row of a desired column?

[daxteoh]

ca you do more guidance video on excel office script?

[cedricguy]

Question: Do you believe other applications like Word or Powerpoint will get Office Script support? Google App Script is fantastic, but seems as though Microsoft is not fully committed to making full-fledge alternative to App Script.

[SD-svxt]

Hello Sir, I have a query regarding Google finance please help me to solve it. Query is, I have 25 stocks list in Column B and I want in column C or D is ( specific date closing price of every stocks of collum B. Like I want 23/6/2022 closing price in column C or D)

[PanduKm]

Hello may i ask some help? I need fix that if other user edit some cell and hit enter, then the dropdown menu that i open or other user open will be closed. Why it's happening?

Edit: i guest the autosave from google sheet that caused the dropdown closed after other user edit cell. The question is how to avoid the automatic save from google sheet?

[Bgmi_With_Anjali]

Hello sir, i need your help.I know only you can help me.
my problem is whenever i am trying to append data it strarts from 1st column But i want to insert data from 3 or 4th column. How it is possible and what would be the source code of this problem. Please help me