How to publish a chart to the web with google apps

2019-08-28 23:29发布

站内问答 / 前沿技术
1145 1 5

I have an EmbeddedChart on a spreadsheet and usually I publish it manually as an image and add it to a confluence page. This way whenever the chart is updated in the spreadsheet, it is also updated in the confluence page. Now I'm trying to automate the creation of the confluence markup that is used to create the confluence page, but I'm not able to publish and get the EmbeddedChart url in the apps script that is creating the confluence markup.

Is there a way to publish a google spreasheet chart to the web (Chart->Publish Chart...->) using google apps script? Or is there a way to get the published URL?

1条回答
不美不萌又怎样
2楼-- · 2019-08-29 00:32

You can also use the Charts API to create the chart inside your html code. From there you can call apps script to retrieve the information from the spreadsheet or directly query the spreadsheet.

In the following example you would call the api and set the package in this case is the "bar" package. Then a query object is created and then you would set the query to the spreadsheet.

After querying the sheet, we will create the chart with the desired options and then call the function draw with the parameters "data" which contains the information obtained from the query and the options.

This Api gives a lot of options for different charts. I hope it helps.

<html>
  <head>
    <!--Load the AJAX API-->
    <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <script type="text/javascript">

      // Load the Visualization API and the controls package.
      google.load("visualization", "1.1", {packages:["bar"]});

      // Set a callback to run when the Google Visualization API is loaded.
      google.setOnLoadCallback(drawDashboard);

  var columnChart = '';
     var dashboard = '';
      function drawDashboard() {
         var query = new google.visualization.Query(
      '<Spreadsheet URL>');
      
      query.setQuery('select A,B,C');
      
      query.send(handleQueryResponse);
      }

      function handleQueryResponse(response) {
        if (response.isError()) {
          alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
          return;
        }

  var data = response.getDataTable();
   
        // Create a Column Bar chart, passing some options
         columnChart = new google.charts.Bar(document.getElementById('chart_div'));
        
          options= {
            width: 600,
            height: 400,
          chart:{
            legend: 'right',
            title: 'Summative Assessment Data'}
               }

        columnChart.draw(data, options);
      }
      
    </script>
  </head>
  <body>
  <div id="chart_div"></div>
          
  </body>
</html>

查看更多
0人赞 添加讨论(0) 举报
登录 后发表回答
相关问题
查看全部
相关文章
查看全部
收藏的人(5)