gas876 - 経済統計練習帳

function doGet(e) {
 
  var app = UiApp.createApplication();
 
  var x1=e.parameter.x;
 
 
 
  var ss = SpreadsheetApp.openById("1qWcT-oQm7RUxrQxgAnMnGkOcrzFkiMe9y7puOd6w61Q");
  var sheet = ss.getSheetByName("data");
 
  var range = sheet.getRange("A1:Q").getValues();
 
  var x=range[1][1];
  var y=range[1][0];
 
  var a=[x1,y];
 
  sheet.appendRow(a);
 
 
  var label = app.createLabel("Hello"+x);
  app.add(label);
 
  return app;
 
 
 
 
 
}