Resources‎ > ‎

Authoring Scripts



Today's Code:
function myFunction() 
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  var sheetName = ss.getName(); 
  var sheets = ss.getSheets(); 
  var data = sheets[7].getRange(1,1,12,3).getValues(); 
  Logger.log(sheetName); 
  getInformation(data); 

function getInformation(dataRange) { 
  var headers = dataRange.shift(); 
  for (i in dataRange) {
    for (j = 0; j < 3; j++) { 
      Logger.log(dataRange[i][j]); 
    } 
   //var information = dataRange[i][0]; 
   //var names = dataRange[i][1]; 
   //var today = dataRange[i][2]; 
   //Logger.log(today); 
   } 
  Logger.log('test'); 
}