Hi,
using the following code is fine and shows a nice table for the
spreadsheet.. but my spreadsheet as multiple sheets and I need the
user to select which sheet to view. I know that I can add the
"sheet=<sheet name>" to the URI, but I want the a dynamic method
instead that displays all the sheets available into a combobox or
listbox... but I have no clue how to query sheets on a spreadsheet.
anyone?
Peter Wraae Marino
function showResults() {
var query = new google.visualization.Query('https://
spreadsheets.google.com/pub?
key=0AnQmRtrGVLC7dG9NMTMtQVM2OUFfOHhQTWRJQ2c5ZUE&hl=en');
query.send(handleQueryResponse);
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() +
' ' + response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var view = new google.visualization.DataView(data);
var table = new
google.visualization.Table(document.getElementById('data'));
table.draw(view, {showRowNumber: false});
}
}
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
