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]=



좀 알려줘유..