gurapyy - 経済統計練習帳

function doGet(){
 
   var id="1v7IVPR8eSGU-8qi3zx_X5PQ3GIXoexxQSx32mmJSCEc";
 
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("data");
 
  var v=sheet.getRange(1,1,6,3).getValues();
 
  var dataTable = Charts.newDataTable();
 
 
 
 
 
  dataTable.addColumn(Charts.ColumnType.STRING, v[0][0]);
  for(var i=1; i<v[0].length; i++){
    dataTable.addColumn(Charts.ColumnType.NUMBER, v[0][i]);
  }
 
  for(var j=1; j<v.length; j++){
    dataTable.addRow(v[j]);
  }
 
  var chart = Charts.newLineChart()
      .setDataTable(dataTable)
      .setTitle("Sales")
      .build();
 
  var app = UiApp.createApplication().setTitle("AST");
  app.add(chart)
  return app;
}