Templates Plugins Courses

Using Google Sheets Plugin


#22

Marc, all the notations are supported, but it depends which operation you are trying to do. For example if you read values(v4) with these notations you will see that it’s already working that way.
maybe you didn’t use the right syntax for modifying data?
try this
[
“row1value1”,
“row1value2”,
“row1value3”
],
[
“row2value1”,
“row2value2”,
“row2value3”
]
so if you want to update a certain range, let’s say a2:b3 you just need to use our call “update row”, put A2 for notation (As a starting point) and then pass the data as shown above
makes sense?


#23

Hi Levon,

Thanks for your answer, I’m working with spreadsheets with over 500 rows and 50 columns so it might be tiring to enter all that manually.

Cheers


#24

You can try to define those expressions dynamically