javascript - Google Visualization API Not Respecting GID or Sheet Parameter - Stack Overflow

admin管理员组

文章数量:1344319

I'm using the Google Visualization Javascript API to load a Chart from Google Sheets and display it in a div. My app is hosted on Google App Engine. I provide the URL to the sheet with the parameter gid=1 to specify the second sheet but the chart the gets displayed is the first sheet. Here's my simplified code (it's basically the example code provided in the documentation):

// sheetUrl is the URL of the Google sheet, e.g., http:///spreadsheet/ccc?key=0AobNU9T3MusKdGFqRHNJYkFnb3RuSkt4QlE#gid=1
// divId is the id of the <div> element I'm displaying in

google.load('visualization', '1.0', {packages: ['table']});
google.setOnLoadCallback(drawChart);

function drawChart() {
    var query = new google.visualization.Query(sheetUrl);
    query.send(handleQueryResponse);
}

function handleQueryResponse(response) {

    var data = response.getDataTable();
    var table = new google.visualization.Table(document.getElementById(divId));
    table.draw(data);
}

You can see the #gid=1 in the URL. I've also tried &gid=1 and &sheet='Volume', which is the name of the tab but when the page loads, the data from the first tab gets rendered.

I have noticed Google sheet urls in the form I have above but also in this form:

I haven't been able to find any documentation explicitly explaining the tq endpoint. I tried using a URL in this form but I get timeout error when trying to load the chart. Any one run into this problem or have insight in the tq thing? Thanks!

Edit 2014-02-17:

I've changed my URL to use the tq endpoint and I've tried the following parameters:

#gid=1
&gid=1
#sheet=Volume
&sheet=Volume

When I query for the url in the browser:

;sheet=Volume

I get the appropriate sheet back. But when I use the Visualization API to query, I get the first sheet.

I'm using the Google Visualization Javascript API to load a Chart from Google Sheets and display it in a div. My app is hosted on Google App Engine. I provide the URL to the sheet with the parameter gid=1 to specify the second sheet but the chart the gets displayed is the first sheet. Here's my simplified code (it's basically the example code provided in the documentation):

// sheetUrl is the URL of the Google sheet, e.g., http://https://docs.google./a/google./spreadsheet/ccc?key=0AobNU9T3MusKdGFqRHNJYkFnb3RuSkt4QlE#gid=1
// divId is the id of the <div> element I'm displaying in

google.load('visualization', '1.0', {packages: ['table']});
google.setOnLoadCallback(drawChart);

function drawChart() {
    var query = new google.visualization.Query(sheetUrl);
    query.send(handleQueryResponse);
}

function handleQueryResponse(response) {

    var data = response.getDataTable();
    var table = new google.visualization.Table(document.getElementById(divId));
    table.draw(data);
}

You can see the #gid=1 in the URL. I've also tried &gid=1 and &sheet='Volume', which is the name of the tab but when the page loads, the data from the first tab gets rendered.

I have noticed Google sheet urls in the form I have above but also in this form:

https://docs.google./spreadsheet/tq?key=0AobNU9T3MusKdGFqRHNJYkFnb3RuSkt4QlE

I haven't been able to find any documentation explicitly explaining the tq endpoint. I tried using a URL in this form but I get timeout error when trying to load the chart. Any one run into this problem or have insight in the tq thing? Thanks!

Edit 2014-02-17:

I've changed my URL to use the tq endpoint and I've tried the following parameters:

#gid=1
&gid=1
#sheet=Volume
&sheet=Volume

When I query for the url in the browser:

https://docs.google./spreadsheet/tq?key=0AobNU9T3MusKdGFqRHNJYkFnb3RuSkt4QlE&sheet=Volume

I get the appropriate sheet back. But when I use the Visualization API to query, I get the first sheet.

• javascript
• google-app-engine
• google-visualization
• google-sheets-api

Share Follow edited Feb 18, 2014 at 15:54 ericso asked Feb 16, 2014 at 20:45 ericsoericso 3,31877 gold badges3131 silver badges3737 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 8

The correct URL to pass to the Visualization API that will work with the new Google Sheets is this format:

https://docs.google./spreadsheets/d/{key}/gviz/tq

You can use the gid query parameter to pass the ID of the worksheet you want to retrieve. So if your gid is 0, the URL would be:

https://docs.google./spreadsheets/d/{key}/gviz/tq?gid=0

You can find additional information regarding URL formats for both the old and new Google Sheets in this bug report.

Hope that helps.

Referencing by sheet name also works as in

https://docs.google./spreadsheets/d/{key}/gviz/tq?sheet=MySheetName

Make sure spreadsheet is "new" vs "old" Google Sheets. I banged my head on that one as I thought my sheet was new. Once I created a new style sheet and used donnapep answer I was working again. I then confirmed using sheet=sheetname works as well which was what I was really after.

本文标签： javascriptGoogle Visualization API Not Respecting GID or Sheet ParameterStack Overflow