|
|
Line 179: |
Line 179: |
| <body> | | <body> |
| <div id="chart_div_2"></div> | | <div id="chart_div_2"></div> |
− | </body>
| |
− | </html>
| |
− |
| |
− | ===Test===
| |
− |
| |
− | https://docs.google.com/spreadsheets/d/1YUqF27YsO2tVdFL1R6Oxu5BT5itjA_ozZDrekzfFclk/edit?usp=sharing
| |
− |
| |
− | <html>
| |
− | <head>
| |
− | <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
| |
− | <script type="text/javascript">
| |
− | function drawSheetName() {
| |
− | var queryString = encodeURIComponent('SELECT B, C');
| |
− |
| |
− | var query = new google.visualization.Query(
| |
− | 'https://docs.google.com/spreadsheets/d/1YUqF27YsO2tVdFL1R6Oxu5BT5itjA_ozZDrekzfFclk/gviz/tq?sheet=Sheet1&headers=1&tq=' + queryString);
| |
− | query.send(handleSampleDataQueryResponse);
| |
− | }
| |
− |
| |
− | function handleSampleDataQueryResponse(response) {
| |
− | if (response.isError()) {
| |
− | alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
| |
− | return;
| |
− | }
| |
− |
| |
− | var data = response.getDataTable();
| |
− | var chart = new google.visualization.ColumnChart(document.getElementById('chart_div_3'));
| |
− | chart.draw(data, { height: 400 });
| |
− | }
| |
− | </script>
| |
− | </head>
| |
− | <body>
| |
− | <div id="chart_div_3"></div>
| |
| </body> | | </body> |
| </html> | | </html> |