How to work with 2D array and ranges in Google sheets using Google Apps script
In this video, you'll learn how to work with 2D array and ranges in google spreadsheet using Google apps script.
Here you'll learn
1)what is 2D(Two Dimensional) array and how to create 2D array
2)How to add an element using push method to 2D array
3)How to add, remove or insert elements using splice method to 2D array
4)how to get ranges in 2D array using getvalues method.
5)How to assign 2D values to spreadsheet range using setvalues method.
********* Tutorial Playlists *********
Google apps script tutorial for beginners- https://bit.ly/google-apps-script-tut...
Automate internet explorer with VBA- https://goo.gl/Xmy8Af
Autoit tutorials for beginners- https://goo.gl/JHB1E2
Selenium Webdriver tutorials for beginners -https://goo.gl/QqxTrF
***** Contact me *******
Blog: http://www.amarindaz.com/contact/
FB page: / amarindaz
****** Books written by me *******
Autoit tutorials for beginners: http://amzn.to/2GjaDbD
Excel VBA for beginners: http://amzn.to/2nhI067
****** Productivity tool ********
My Favorite YouTube Tools ➜ https://goo.gl/MX9Z4p and ➜https://goo.gl/UW1uRX
****** Gear Used To Shoot This Video *****
_Audio & Microphone
http://amzn.to/2GibdGu
*******Learning partner*******
Video courses ➜https://click.linksynergy.com/fs-bin/...
Don't forget to subscribe! https://goo.gl/J2453w
💼 To Hire Me 👉 https://fwd.cx/WLGgpTiZW5HK
Checkout my app 👉 https://www.myfreshtools.com