my data is serialized like this format
. but I’m unable to get value (only column a ).
so how I can get value using only row numbers.
Please, try to use the following solution:
//get all the spreadsheet records:
var items=spreadsheet._grid.data.findAll(function(item){ return true; });
var arr=[]
for (i=1;i<items.length;i++){ //iterate thruogh all the rows (excluding the header)
arr.push(items[i][2]) //get value of a needed column
}
console.log(arr)