Office Scripts: Add Row at End of Worksheet

[@PramodTeewaree]

You are a life saver! Thank you very much.

[@johnfromireland7551]

Get last row, is probably, the most frequently used method! Awesome!

[@renatobeltrame5403]

Hi, could you show the code for it? Please?

[@jonathansmith31]

Hey Sudhi, great video! You make scripts much easier to follow! Hope you keep producing them! QQ im trying to use the autofill method, i want it to be dynamic but it wont let me pass the range as a variable, any thoughts? Maybe a little video? 😁

[@khoakhoa201]

how about copy from range from onesheet to the last row of other sheet. I could found alot of tutorial with VBA. But couldnt found it in Office Script. Thank you for providing very valuable knowledges!

[@leebecker8255]

Really helpful, thanks!

[@jasonhordichuk5620]

I need to add a row into a table. Can you show us how to do that?

[@hoges510]

This is great. Is there a tweak to say add 5 row at a time, but have them all empty whilst retaining formulas?

[@carlycarlyle]

Hi Sudui, thank you for the video. It has just got me started using Excel online Can you help me with something I am trying to do? Copy Range from a worksheet and paste it on plus one of the last row of column A on another sheet so it leaves a space. I have been looking online and can't find anything.

[@mahikumar8813]

Why am I not able to refresh queries in Excel web with Office Script? Mr.Sudhi, I would appreciate your help with this.

[@user-jh6em2kf7o]

How to insert rows between different values?

[@user-jh6em2kf7o]

how to insert row between different values excel with office scripts

[@Ahmed7255]

a lot of work