Day: May 6, 2015

 function check_website(url) { 
 var response = UrlFetchApp.fetch(url, {muteHttpExceptions: true});
 return response.getResponseCode();
}

function doLog(timestamp, responseCode, timeDiff) {
 
 var ss=SpreadsheetApp.getActiveSpreadsheet();
 var sheet=SpreadsheetApp.setActiveSheet(ss.getSheetByName("Log")); 
 sheet.appendRow([timestamp, responseCode, timeDiff]);
}

function getTime() {
 var startTime = new Date() ;
 var responseCode=check_website("http://www.psu.ac.th");
 var endTime = new Date() ;
 var timeDiff = endTime-startTime; 
 doLog(Utilities.formatDate(new Date(), "GMT+7", "yyyyMMdd-HHmmss") , responseCode , timeDiff);
}

function insertData1() {
 var ss=SpreadsheetApp.getActiveSpreadsheet();
 var sheet=SpreadsheetApp.setActiveSheet(ss.getSheetByName("Sheet1"));
 sheet.getRange(1, 1).setValue("Hello World");
 sheet.getRange("A2").setValue("สวัสดี");
 
 var v1=[ ["ชื่อ","นามสกุล","อายุ"] ];
 var v2=[
 ["สมชาย"]
 ,["Robert"]
 ,["39"]
 ];
 sheet.getRange("A3:C3").setValues(v1);
 sheet.getRange("A4:A6").setValues(v2);
}

function insertData2() {
 var ss=SpreadsheetApp.getActiveSpreadsheet();
 var sheet=SpreadsheetApp.setActiveSheet(ss.getSheetByName("Sheet1")); 
 sheet.appendRow([new Date(),"something"]);
}

function readData1(){
 var ss=SpreadsheetApp.getActiveSpreadsheet();
 var sheet=SpreadsheetApp.setActiveSheet(ss.getSheetByName("ReadData")); 

 var url="https://docs.google.com/spreadsheets/d/1oztRXjC2KJzrqC3LtiRnUPrEgohX4VTYHixylvtCdzY/edit?usp=sharing";
 var db=SpreadsheetApp.openByUrl(url);
 var table=db.setActiveSheet(db.getSheetByName("WGHCEPA"));
 var data=table.getRange("A1:J10").getValues();
 
 for (var i=0; i<data.length;i++){
 sheet.appendRow(data[i]);
 }
 
}

function readData2(){
 var ss=SpreadsheetApp.getActiveSpreadsheet();
 var sheet=SpreadsheetApp.setActiveSheet(ss.getSheetByName("readData")); 

 var id="1oztRXjC2KJzrqC3LtiRnUPrEgohX4VTYHixylvtCdzY";
 var db=SpreadsheetApp.openById(id);
 var table=db.setActiveSheet(db.getSheetByName("WGHCEPA"));
 var data=table.getDataRange().getValues();
 
 for (var i=0; i<data.length;i++){
 sheet.appendRow(data[i]);
 }
 
}

function insertData3(){
 var url="https://docs.google.com/a/psu.ac.th/spreadsheets/d/1bQyyQrB3PPyawWVb3afMi0Kgz1KUibIfMblv351BtQI/edit?usp=sharing";
 var db=SpreadsheetApp.openByUrl(url);
 var table=db.setActiveSheet(db.getSheetByName("Sheet1"));
 // เปลี่ยนเป็น ชื่อ นามสกุล และคณะ/หน่วยงานของท่าน
 var mydata=["ชื่อ","นามสกุล","คณะ/หน่วยงาน"];
 
 table.appendRow(mydata);
}