✍ 📁 🙈 🙉 🙊 : google apps script A

<h3>Google Apps Script<br>
建立 Google Sheets 為網頁資料庫</h3>

<center>
<table  ><tbody><tr>
<td class="T1" >HTML</td>
<td class="T2">⇦ data ⇨</td>
<td class="T3" >Google Apps Script</td>
<td class="T2" >⇦ data ⇨</td>
<td class="T1" >Google Sheets</td>
</tr></tbody></table>
</center>
<br><br>

<h3><img style="width:90%;" src="https://developers.google.com/apps-script/images/landing-page-hero.svg" /></h3>
<br><br>
  
☛ <a  href="https://developers.google.com/apps-script" target="_blank" title="HTML">Google Apps Script 官網</a> 
<br>
☛ <a  href="https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet" target="_blank" title="HTML">使用 google Apps 腳本自動執行任務</a>

<br>

<pre>1) 在 google 試算表內，功能選項 -> 擴充功能 -> 進入 Apps Script。 
2) 進入 Apps Script 開始編輯 Code.gs，裡頭預設有一個名為 
   myFunction，接著 myFunction 改為 function doGet(e){...}。
3) doGet 包含一個 e 的參數，用來接收 HTML 值 e.parameter 傳來給
   Apps Script 給 Code.gs 的值所解析出來的值。
</pre>
<img style="width:100%;" src="https://1.bp.blogspot.com/-S4aIezAxocQ/X85RFja3XQI/AAAAAAAAJc8/O6bz9ezuYHQDbdGq-s0JF3h5ZS9rFpHSgCLcBGAsYHQ/s1078/Apps%2BScript%2Bnew%2BIDE.png" />
<br><br>
  
☛ <a  href="https://docs.google.com/spreadsheets/d/e/2PACX-1vR-kD0kOAdZLL1zRQmDnrYQgAy2fdGVmUtyMw27lysn00Xco_T87dsbn6NUvpiSWlWR-P2dcxSzpSNf/pubhtml"
      target="_blank" title="go to my google Sheets">
  我的示範 google 工作表1 </a>
<iframe id="iframe" src="https://docs.google.com/spreadsheets/d/e/2PACX-1vR-kD0kOAdZLL1zRQmDnrYQgAy2fdGVmUtyMw27lysn00Xco_T87dsbn6NUvpiSWlWR-P2dcxSzpSNf/pubhtml" style="width:98%;height:500px "></iframe>
  
  
<style>
.T1 {width:100px;border: 1px solid black;text-align: center;color : blue;
     background:radial-gradient(circle at center,yellow,red);}

.T3 {width:150px;border: 1px solid black;text-align: center;color : blue; 
     background:radial-gradient(circle farthest-corner at left,yellow,red);background:radial-gradient(circle farthest-corner at left,yellow,red);}
.T2 {width:80px;text-align: center}

pre { font-size: 20px ;}
 h3 { text-align: center;
     font-size: 30px;
     font-weight: bold;
     text-shadow: 10px 6px 10px grey;
     color: blue; }
</style>

<div class="DDiv">
<h3>MY Apps Script Code.gs</h3>
<br>
var SpreadSheet = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1fgPZTBOj0BoVsbaNfDNoq4oK_3iO0CWG8LNDv73m3UI/edit#gid=0");
<br>
<br>
var SheetName = SpreadSheet.getSheetByName("工作表1")
<br>

<bR>function doGet(e) {
<br>      var parameter = e.parameter ;
<br>
<br>      if( parameter.dow == <R>"read"</R>){
<br>              var obj = {};
<br>              var data = SheetName.getDataRange().getValues();
<br>              obj.content = data;
<br>              return ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(ContentService.MimeType.JSON) }
<br>
<br>
<br>      if( parameter.dow == <R>"Add"</R>){ 
<br>              SheetName.appendRow([parameter.in1,parameter.in2,
<br>              parameter.in3,parameter.in4]); }
<br>
<br>
<br>      if( parameter.dow == <R>"Del"</R>){
<br>              SheetName.deleteRow(parameter.idd);  }
<br>
<br>
<br>      if( parameter.dow == <R>"Dchange"</R>){ 
<br>         var range=SheetName.getRange(parameter.idd,parameter.cow ) ;
<br>         range.setValue(parameter.newD);  }
<br>
<br>
<br>      if( parameter.dow == <R>"UA"</R>){  
          SheetName.insertRows(parameter.idd); }

<br>
<br>var      ss = SpreadsheetApp.getActiveSpreadsheet();
<br>var sheet = ss.getSheets()[0];
<br>var sheet = SpreadsheetApp.getActiveSpreadsheet() ;
<br>
<br>var outt = "var sheet = SpreadsheetApp.getActiveSpreadsheet()"
<br>      outt += "\n sheet.getName() = " ;
<br>       outt +=  sheet.getName()  ;
<br>       outt += "\n sheet.getSheets()0].getSheetName() = " ;
<br>       outt +=  sheet.getSheets()[0].getSheetName() ;
<br>      outt += "\n sheet.getLastRow() = " ;
<br>       outt +=  sheet.getSheets()[0].getLastRow() ;
<br>       outt += "\n sheet.getLastColumn() = " ; 
<br>       outt += sheet.getSheets()[0].getLastColumn() ;
<br>       outt += "\n sheet.getUrl() = " ;
<br>       outt +=  sheet.getUrl() ;
<br>      outt += "\n sheet.getDataRange().getValues() = " ;
<br>       outt+=     sheet.getDataRange().getValues() ;
<br>
<br>return ContentService.createTextOutput(outt).setMimeType(ContentService.MimeType.JSON)

}

</div><br>

html 程式訪問 google Apps Script 值 data 傳回 google 工作表1 內容。
  <br />var <R>appUrl</R> = "我的 google Apps Script 應用程式的網址"，

<ol>
<li>  <</span>div id="DP"><</span>/div>
<br>
<br>
<li>  <</span>script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"><li><</>/script>
<br>
<br>
<li>  <</span>script>
<li>  var <R>appUrl</R> = "https://script.google.com/macros/s/AKfycbzXvEa5XUTxtlm_s0LsEcvd5rfkSGBrxgg4cy9hKhiyLWXAfuBN3Ja0CWqXHPAVjWr4/exec" ;
<br>
<br>
<li>parameter = {dow:'read'    };
<br>
<li>$.get(appUrl, parameter, function(data) {
<li>      if(!data){ $('#show').text('無資料'); }
<li>            else{ $('#DP').text(JSON.stringify(JSON.parse(data))) ; }
<li>    }) 
<li>  <</c>/script>
</ol>
 <br><br>

傳回 :<br>

parameter = {dow:'read' };
$.get(appUrl, parameter, function(data) {
if(!data){ $('#show').text('無資料'); }
else{ $('#DP').text(JSON.stringify(JSON.parse(data))) ; }
})
</script>

.DDiv {word-break: break-all; word-wrap: break-word;}
R {color:red}
</style>

☛ Blogger Google資料庫

Edit

用JavaScript連結Google Sheets 建立 Google Sheets 為網頁資料庫 Google Sheet 網頁資料庫 How to pull your data from Google Sheets to Web Google Sheets to Web SpreadsheetApp.openByUrl(); SpreadSheet.getSheetByName() SheetName.getRange() range.setValu()

✍ 📁 🙈 🙉 🙊

window Resize

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單