reading spreadsheet data

29 views
Skip to first unread message

lun

unread,
Feb 2, 2010, 11:15:11 PM2/2/10
to Google Data Javascript Client
i tried to read the spreadsheet data with "google.visualization.Query"
it didn't work. Below is my spreadsheet link

https://spreadsheets.google.com/ccc?key=tDBZK0CrVtbYrrp7nbZRb7Q

I have some integer and string values, and some empty cell in
spreadsheet(you can find it on above spreadsheet). when ever it finds
the integer values in a row it considers that row as first row and
above that as header or label.

is it google's problem or i am missing something ??

Here is the code i have written::
var prefs;
var data;
google.load('visualization', '1',{package:'table'});
google.setOnLoadCallback(init);

function init(){
prefs = new _IG_Prefs();
var url= prefs.getString("_table_query_url");
var query = new google.visualization.Query(url);
query.send(handleQueryResponse);
}
function handleQueryResponse(response){
if (response.isError()) {
alert("Error in query");
}
for (var col = 0; col < data.getNumberOfColumns(); col++) {
for (var row = 1; row < data.getNumberOfRows(); row++) {
console.log("[" + row + "][" + col +"]" +
data.getFormattedValue(row,col));
}
}
}

monsur

unread,
Feb 3, 2010, 10:07:08 PM2/3/10
to Google Data Javascript Client
It looks like you are trying to access the Visualization API, which
you can learn more about here:

http://code.google.com/apis/visualization/

This group is for the Google Data JavaScript Client, which is a
different piece of code.

Thanks,
Monsur

Reply all
Reply to author
Forward
0 new messages