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

}