✍ 📁 🙈 🙉 🙊 : Google Apps Script 2

<h3>get Google SpreadSheet content</h3>
<div class="DDiv">

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

<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/AKfycbz7m55YR3t-WeJUbrNNOgwVehbGqPDhwFy6qHHIrfvLPgKE59EQX33HKNFqlyRvYMsH_A/exec" ;
<br>
<br>
<li>parameter = {dow:'ReadData'    };
<br>
<li>$.get(appUrl, parameter, function(data) {
<li>           $('#DP').text(JSON.stringify(data)) ; 
<li>    }) 
<li>  <</c>/script>
</ol>
 <br><br>
 
傳回 :<br>

parameter = {dow:'ReadData' };
$.get(appUrl, parameter, function(data) {
 $('#DP').text(JSON.stringify(data )) ; 
})
</script>

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

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

<h3>get Google SpreadSheet content</h3>

<pre>html 程式訪問 google Apps Script，傳回 google 工作表1 內容，
var <R>url</R> = "我的 google Apps Script 應用程式的網址"。
</pre>
<ol>
<li><<c>div id="demo"><<c>/div>

<li><<c>script>
<li><div>var url ="https://script.google.com/macros/s/AKfycbz7m55YR3t-WeJUbrNNOgwVehbGqPDhwFy6qHHIrfvLPgKE59EQX33HKNFqlyRvYMsH_A/exec"
</div><br>
<li> url+= "?dow=ReadData" ;
<li> var xhp = new XMLHttpRequest();
<li> xhp.onload = function() {
<li> demo.innerHTML = xhttp .responseText;  }
<li> xhp.open("GET",url  );
<li> xhp.send();
<li> <<c>/script>
</ol>

<br>

傳回 xhp : <div id="demo"></div>

url+= "?dow=ReadData" ;

var xhp = new XMLHttpRequest();
  xhp.onload = function() {
  //var dd=[] ;

var dd=JSON.parse(xhp.responseText)
  var TxT="";

TxT+= "var dd=JSON.parse(xhp.responseText)";
      TxT+= "<br>dd = " + JSON.stringify(dd) ;
      TxT+= "<br>dd.length = " + dd.length;
      TxT+= "<br>dd[1] = " + dd[1] ;
      TxT+= "<br>dd[1][1] = " + dd[1][1] ;

demo.innerHTML =  TxT;  }

xhp.open("GET",url  );
  xhp.send();

</script>

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

<h3>get Google SpreadSheet content</h3>

<pre>html 程式訪問 google Apps Script，傳回 google 工作表1 內容，
var <R>url</R> = "我的 google Apps Script 應用程式的網址"。
</pre>
<ol>
<li><<c>div id="demo"><<c>/div>

<li><<c>script>
<li><div>var <R>url</R>  ="https://script.google.com/macros/s/AKfycbz7m55YR3t-WeJUbrNNOgwVehbGqPDhwFy6qHHIrfvLPgKE59EQX33HKNFqlyRvYMsH_A/exec"
</div><br>
<li> url+= "?dow=ReadData&A1=2&A2=1&B1=3&B2=3" ;
<li> var xhp = new XMLHttpRequest();
<li> xhp.onload = function() {
<li> demo.innerHTML = xhttp .responseText;  }
<li> xhp.open("GET",url  );
<li> xhp.send();
<li> <<c>/script>
</ol>

<br>

傳回 : <div id="demo"></div>

url+= "?dow=ReadData&A1=2&A2=1&B1=3&B2=3" ;
  var xhp = new XMLHttpRequest();
  xhp.onload = function() {
  demo.innerHTML = xhp .responseText;  }

xhp.open("GET",url  );
  xhp.send();

</script>

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

Edit

#get Google SpreadSheet content #XMLHttpRequest() #blogger #google blogger #google apps script #Google Sheets 為網頁資料庫 #免費資料庫 #doGet(e) #xhp.send() #xhp.open("GET",url ) #JSON.stringify(data) #xhttp .responseText

✍ 📁 🙈 🙉 🙊

window Resize

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單