ren exl4 - 経済統計練習帳

function myFunction() {
 
 
  var id="1xl8NIC19JbaTWntNY8gv2H5qwMkfs0Wf7WjsGglgqks"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 
  var pp=new Array();
  for(s=0;s<10;s++){
  pp[s]=new Array(); 
  for(sx=0;sx<10;sx++){
  pp[s][sx]="abc"+s+"(+)"+sx;
  }}
 
 
sheet.getRange(1,1,10,10).setValues(pp);  
 
  var range=sheet.getRange(1,1,10,10);  
 
var v=range.getValues();
 
  Logger.log(v[5][5]);
 
}