育將電腦工作室 - 線上書籍

台南社大-點2下社團
==========

1. 查看記錄 ```
  <pre class="brush:as3;">
  Logger.log("Hello World");
  ```
  
  ![](https://i.imgur.com/FxAWKtJ.png)  
     
   ![](https://i.imgur.com/4UJk6cE.png)
2. Google Service 配額：[https://developers.google.com/apps-script/guides/services/quotas ](https://developers.google.com/apps-script/guides/services/quotas)
3. 連結試算表  
     
   ![](https://i.imgur.com/iVEqAgt.png)
4. 建立一個試算表：  
   取得id：  
   取得url：  
     
   ![](https://i.imgur.com/qYEi8i1.png)
5. 寫入資料 ```
  <pre class="brush:as3;">
  function myFunction() {
    //Logger.log("Hello World");
    var url = "https://docs.google.com/spreadsheets/d/1TSFg5mocDvsaYOxHjClSAKhOJKtN4sc_gxDpQTkzNGc/edit#gid=0";
    var ss = SpreadsheetApp.openByUrl(url);//打開試算表
    var name = "聯絡我們";//工作表
    var ws = ss.getSheetByName(name);//取得工作表
    
    //姓名、電話、email、聯絡內容
    var row = ["姓名","電話","email","聯絡內容"];
    ws.appendRow(row);//寫入資料
    
    
  }
  ```
6. 練習\["name","tel","email","content"\] 寫入  
   ```
  <pre class="brush:as3;">
  function myFunction() {
    //Logger.log("Hello World");
    var url = "https://docs.google.com/spreadsheets/d/1TSFg5mocDvsaYOxHjClSAKhOJKtN4sc_gxDpQTkzNGc/edit#gid=0";
    var ss = SpreadsheetApp.openByUrl(url);//打開試算表
    var name = "聯絡我們";//工作表
    var ws = ss.getSheetByName(name);//取得工作表
    
    //姓名、電話、email、聯絡內容
    //var row = ["姓名","電話","email","聯絡內容"];
    //ws.appendRow(row);//寫入資料
    
    //寫入資料另一種方法  
    
    //name、tel、email、content
    var row = ["name","tel","email","content"];
    var lastRow = ws.getLastRow()+1; // 得到最新列指標  
    // getRange(row位置, col位置, row數量, col數量)
    ws.getRange(lastRow, 1, 1, row.length).setValues([row]);
    
  }
  ```
7.

Title1

Title2

Title3

Title1

Title2

Title3

MarkDown