<script>
var y=new Array();
function sample(){
google.script.run
.withSuccessHandler(function(x) {
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
for(s=0;s<3;s++){
y[s]=new Array();
}
y[0][0]="year";
y[1][0]="2004";
y[2][0]="2007";
y[0][1]="sale";
y[0][2]="ex";
y[1][1]=x[1][1];
y[1][2]=x[1][2];
y[2][1]=x[2][1];
y[2][2]=x[2][2];
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
})
.withFailureHandler(function(msg) {})
.f();
}
function drawChart() {
var data = google.visualization.arrayToDataTable(y);
var options = {
title: '会社',
curveType: 'function',
legend: { position: 'bottom' }
};
var chart = new google.visualization.LineChart(document.getElementById('memo'));
chart.draw(data, options);
}
</script>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8" />
<title>日本地図</title>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
</head>
<body onload="sample()">
<p id="memo"></p>
<?!= HtmlService.createHtmlOutputFromFile('sample').getContent(); ?>
</body>
</html>
var x=new Array();
function doGet(e) {
var template = HtmlService.createTemplateFromFile('index');
return template.evaluate()
.setTitle('練習')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function f(){
var id="1ZefuaGPEHlparec15SH6zoK5db1tEduMyRVZU2brtSI";
var ex1 = SpreadsheetApp.openById(id);
var sh = ex1.getSheetByName("data");
n=sh.getRange(1,1).getValue();
for(s=1;s<3;s++){
x[s]=new Array();
}
x[1][1]=n;
x[1][2]=100;
x[2][1]=500;
x[2][2]=700;
return x;
}
最終更新：2018年05月16日 11:35
