Monday, 9 September 2013

Get data from a Cell in Google Spreadsheet via Javascript/JSON

Get data from a Cell in Google Spreadsheet via Javascript/JSON

need a little help..
I was working with this code that i found on here.
Is it possible to retrieve just a specific Cell in a spreadsheet in
similar fashion?
like If I wanted to retrieve cell A5 something like entry.gsx$A5 ?
Thanks
function importGSS(json){
for(i = 0; i < json.feed.entry.length; i++){
entry = json.feed.entry[i];
$('#departments').append('<option>' + entry.gsx$subdivision.$t +
'</option>');
$('#subject').append('<option>' + entry.gsx$section.$t + '</option>');
$('#services').append('<option>' + entry.gsx$station.$t + '</option>');
}
}

No comments:

Post a Comment