function Reporting() {
// 로그테스트해유
var test = 'test variable';
Logger.log(test);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet_target = ss.getSheetByName("main_sheet")
var inputedNames = sheet_target.getRange("L2:L11");
var sourceSheetList = new Array;
//range 에서 이름 데이터 추출
for (j=0; j<10; j++){
var listCount = j + 1;
sourceSheetList[j] = inputedNames.getCell(listCount, 1).getValue();
if(sourceSheetList[j] == ""){
Logger.log("j=%s , sourceSheetList = %s ", j, sourceSheetList[j]);
break;
}
Logger.log("j=%s , sourceSheetList = %s ", j, sourceSheetList[j]);
}
var rowCounter = 2;
for (i=0; sourceSheetList[i] =! ""; i++){
Logger.log("입력 돌아유! rowCounter=%s, i=%s 번째, sourceSheetList[i]=%s", rowCounter, i, sourceSheetList[i]);
Logger.log("입력 돌아유! rowCounter=%s, i=%s 번째, sourceSheetList[i]=%s", rowCounter, i, sourceSheetList[i+1]);
Logger.log("입력 돌아유! rowCounter=%s, i=%s 번째, sourceSheetList[i]=%s", rowCounter, i, sourceSheetList[i-1]);
Logger.log("입력 돌아유! rowCounter=%s, i=%s 번째, sourceSheetList[i]=%s", rowCounter, i, sourceSheetList[i+2]);
}
[16-08-13 13:25:13:927 JST] test variable
[16-08-13 13:25:14:310 JST] j=0.0 , sourceSheetList = AAAAAAAAAAAAAAAAA
[16-08-13 13:25:14:312 JST] j=1.0 , sourceSheetList = BBBBBBBBBBBBBBBB
[16-08-13 13:25:14:313 JST] j=2.0 , sourceSheetList =
[16-08-13 13:25:14:314 JST] 입력 돌아유! rowCounter=2.0, i=0.0 번째, sourceSheetList[i]=true
[16-08-13 13:25:14:315 JST] 입력 돌아유! rowCounter=2.0, i=0.0 번째, sourceSheetList[i]=BBBBBBBBBBBBBBBB
[16-08-13 13:25:14:315 JST] 입력 돌아유! rowCounter=2.0, i=0.0 번째, sourceSheetList[i]=undefined
[16-08-13 13:25:14:316 JST] 입력 돌아유! rowCounter=2.0, i=0.0 번째, sourceSheetList[i]=
좀 알려줘유..
찾았다.. 자바스크립트 비교연산자가 이상하게 생겨먹었네