odanobunaga - 経済統計練習帳

function sample_sendMailChart() {
 
 
 
 id="14Z1-QWaoAg1Sa4NXnNI80gB5F3_xelKyvfDRNZF_z4g"; 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
 
 sheet.getRange(1,1,100,100).setBackground('white');  
 
for(s=1;s<101;s++){  
sheet.setColumnWidth(s, 10)
sheet.setRowHeight(s, 10);
} 
 
 sheet.getRange(1,1,100,100).setBackground('red');  
 
 
 
 
 
 
}