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));
}
}
}
http://code.google.com/apis/visualization/
This group is for the Google Data JavaScript Client, which is a
different piece of code.
Thanks,
Monsur