iro - 経済統計練習帳

var str;
var x=new Array();
var y=new Array();
var a=new Array();
 
 
function sample() {
 
id="1n6IFBdsE_j3sJzyKWqhv0n2Q_B6EadPPf35GfRpEfSQ";
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
for(s=1;s<21;s++){  
sheet.setColumnWidth(s, 50)
sheet.setRowHeight(s, 50);
}
 
sheet.getRange(1,1).setBackground('red'); 
sheet.getRange(2,2).setBackground('green');  
 
 
 sheet.getRange(5,5,3,3).setBackground('red'); 
 
 
 
}