How Get column data in dhtmlx spreadsheet


#1

my data is serialized like this format
image
. but I’m unable to get value (only column a ).
so how I can get value using only row numbers.


#2

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)

https://snippet.dhtmlx.com/gxhfxkvd