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'); } |
Resources >