Hello
I am using an ajax call to access google sheets, to retrieve a range of values (e.g. sheet1!A1:A3)
The reply format is in json such as follows.
I want to insert value1 ... value3 into a listbox, but have difficulties accessing the items in the values array.
How is this done in C2 or C3 ?
thank you,
Dan
{
"range": "sheet1!A1:A3",
"majorDimension": "ROWS",
"values": [
[
"value1"
],
[
"value2"
],
[
"value3"
],
]
}