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

[@MarissaTuttle]

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

[@josericardo3015]

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

[@ExcelGoogleSheets]

🙂

[@aa2lo060]

@@ExcelGoogleSheets Me too

[@senormanana]

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

[@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?

[@ExcelGoogleSheets]

Just make a script the same way I did in the video by grabbing the value from C26 and then schedule that script in power automate to run weekly.

[@sergiomira741]

Greetings from Colombia!! Thanks!!!

[@guillermosepulvedaf]

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

[@sabarashid1513]

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?

[@ExcelGoogleSheets]

You can use Ctrl+Up, Ctrl+Down shortcuts to figure out the start and end. learn.microsoft.com/en-us/javascript/api/office-scripts/excelscript/excelscript.keyboarddirection?view=office-scripts

[@sabarashid1513]

@@ExcelGoogleSheets Thank you for the prompt response. Looking forward to more videos around Office Script from you :-)

[@cedricguy4753]

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.

[@ExcelGoogleSheets]

I have no clue. App Script has it's limitations too, it's not like it's perfect. The only thing I know is that within the last couple of years there were a lot of updates done by Microsoft. I can't say the same about Google, it's snail pace.

[@daxteoh27]

ca you do more guidance video on excel office script?

[@ExcelGoogleSheets]

Did you watch these already? kzbin.infosearch?query=office%20script

[@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?

[@ExcelGoogleSheets]

What do you mean by "dropdown menu"?

[@PanduKm]

@@ExcelGoogleSheets i mean the dropdown in the cell sir, when i open the dropdown it will immediately closed after other user edit any cell in any sheet, that's why i think the autosave from google sheet that caused the dropdown closed.

[@ExcelGoogleSheets]

@@PanduKm I don't think there is anything you can do.

[@PanduKm]

@@ExcelGoogleSheets okay sir thanks for answering my question. But could you create a tutorial for filtering or lookup data from another workbook but from app script? I try looking on Google but can't find that tutorial.

[@rishirishi4970]

👍

[@ExcelGoogleSheets]

Thanks!

[@aasmuhammad8027]

Thank you.

[@prakhargupta2941]

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

[@Abhishja]

how about Repeated item labels?

[@SD-sv7xt]

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)

[@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

[@ExcelGoogleSheets]

use setValues() instead of appendRow()