✍ 📁 🙈 🙉 🙊 : Google Apps Script 2

get Google SpreadSheet content
取得 Google 試算表內容

<pre>     1. <r>url</r>    = 我的 Google Apps Script
     2. <b>SSheet</b> = 存放資料 試算表 地址
     3. <r>SName</r>  = 存放資料 試算表 頁名稱

</pre>

<ol>
<li><div>var <r>url</r> ="https://script.google.com/macros/s/AKfycby29qp9tcOvEVB6bgiLgGk0t-1wXD4UTCCb8Sid9eDJt74Ye55JYtNBmz2TmeUFHDH6/exec"
</div><br>

<li><div>var <b>SSheet</b> = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"
</div><br>

<li>var <r>SName</r>="工作表1"
<br><br>

<li> url+= "?SName=" + SName 
<li> url+= "&SSheet=" + SSheet
<br><br>
<li> var xhp = new XMLHttpRequest();
<br><br>
<li> xhp.onload=function(){<B>Tdata</B>= JSON.parse(xhp.responseText)}
<li> xhp.open("GET",url  );
<li> xhp.send();
</ol> 傳回 :

<div id="TA"><marquee scrollamount="20">download</marquee>
</div>

var SSheet = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"

var SName="工作表1" ;

url+= "?SName=" + SName ;
url+= "&SSheet=" + SSheet

var xhp = new XMLHttpRequest();

xhp.onload=function(){Tdata =JSON.parse(xhp.responseText) ;
                      txt +="Tdata = "+ Tdata +"<br> "; 
                      txt +="Tdata.length  = "+ Tdata.length  ; 
                      TA.innerHTML=txt ;                }

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

Ur.innerHTML="url= " +url;

</script>

#table1    {border-style:solid;}
#table1 td {border: 1px solid brown;
            padding:0px 10px;
            min-height:500px;}
td  {  height:20px; font-size: 20px ;}

#TA ,#TB, pre ,#Ur{ font-size: 20px ;}
R   {color:red}
B   {color:blue}
  BB{ font-size: 25px ;}  
h3  { text-align: center;
      font-size: 30px;
      font-weight: bold;
      text-shadow: 10px 6px 10px grey;
      color: blue; }
</style>

<pre>     1. <r>url</r>    = 我的 Google Apps Script
     2. <b>SSheet</b> = 存放資料 試算表 地址
     3. <r>SName</r>  = 存放資料 試算表 頁名稱
     4. <B>READJSON</B>讀取 試算表 內 所有 數據
        <R>Row=0&Col=0&RRow=0&CCol=0</R>
        Row = 0 讀取 試算表 內所有數據  傳回 <B>Tdata</B>
</pre>

<ol>
<li><div>var <r>url</r> ="https://script.google.com/macros/s/AKfycby29qp9tcOvEVB6bgiLgGk0t-1wXD4UTCCb8Sid9eDJt74Ye55JYtNBmz2TmeUFHDH6/exec"
</div><br>

<li><div>var <b>SSheet</b> = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"
</div><br>

<li>var <r>SName</r>="工作表1"
<br><br>

<li> url+= "?dow=<B>READJSON</B>&<R>Row=0&Col=0&RRow=0&CCol=0</R>" 
<li> url+= "&SName=" + SName 
<li> url+= "&SSheet=" + SSheet
<br><br>
<li> var xhp = new XMLHttpRequest();
<br><br>
<li> xhp.onload=function(){<B>Tdata</B>= JSON.parse(xhpt.responseText)}
<li> xhp.open("GET",url  );
<li> xhp.send();
</ol> 傳回 :

<div id="TA"><marquee scrollamount="20">download</marquee>
</div>

var SSheet = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"

var SName="工作表1" ;

url+= "?dow=READJSON&Row=0&Col=0&RRow=0&CCol=0" ;
url+= "&SName=" + SName ;
url+= "&SSheet=" + SSheet

var xhp = new XMLHttpRequest();

xhp.onload=function(){Tdata =JSON.parse(xhp.responseText) 
                      txt +="Tdata = "+ Tdata +"<br>"; 
                      txt +="Tdata.length  = "+ Tdata.length  ; 
                     TA.innerHTML=txt;                }

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

Ur.innerHTML="url= " +url;

</script>

#table1    {border-style:solid;}
#table1 td {border: 1px solid brown;
            padding:0px 10px;
            min-height:500px;}
td  {  height:20px; font-size: 20px ;}

<pre>     1. <r>url</r>    = 我的 Google Apps Script
     2. <b>SSheet</b> = 存放資料 試算表 地址
     3. <r>SName</r>  = 存放資料 試算表 頁名稱
     4. <B>READJSON</B>讀取 試算表 部份 數據
        <R>Row=2&Col=2&RRow=1&CCol=3</R>
        傳回 <B>Tdata</B>
</pre>

<ol>
<li><div>var <r>url</r> ="https://script.google.com/macros/s/AKfycby29qp9tcOvEVB6bgiLgGk0t-1wXD4UTCCb8Sid9eDJt74Ye55JYtNBmz2TmeUFHDH6/exec"
</div><br>

<li><div>var <b>SSheet</b> = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"
</div><br>

<li>var <r>SName</r>="工作表1"
<br><br>

<li> url+= "?dow=<B>READJSON</B>&<R>Row=2&Col=2&RRow=1&CCol=3</R>" 
<li> url+= "&SName=" + SName 
<li> url+= "&SSheet=" + SSheet
<br><br>
<li> var xhp = new XMLHttpRequest();
<br><br>
<li> xhp.onload=function(){<B>Tdata</B>= JSON.parse(xhpt.responseText)}
<li> xhp.open("GET",url  );
<li> xhp.send();
</ol> 傳回 :

<div id="TA"><marquee scrollamount="20">download</marquee>
</div>

var SSheet = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"

var SName="工作表1" ;

url+= "?dow=READJSON&Row=2&Col=2&RRow=1&CCol=3" ;
url+= "&SName=" + SName ;
url+= "&SSheet=" + SSheet

var xhp = new XMLHttpRequest();

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

Ur.innerHTML="url= " +url;

</script>

#table1    {border-style:solid;}
#table1 td {border: 1px solid brown;
            padding:0px 10px;
            min-height:500px;}
td  {  height:20px; font-size: 20px ;}

<pre>     3. <r>appUrl</r>    = 我的 Google Apps Script
     4. <b>SSheet</b> = 存放資料 試算表 地址
     5. <r>SName</r>  = 存放資料 試算表 頁名稱
     6. <B>READJSON</B>讀取 試算表 所有 數據
        <R>Row=0&Col=0&RRow=0&CCol=0</R>
        傳回 <B>Tdata</B>
</pre>
<ol>
<li><<?>script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"><br><<?>/script>
<br><br>

<li><<?>script>
<li>var <r>appUrl</r>= "https://script.google.com/macros/s/AKfycby29qp9tcOvEVB6bgiLgGk0t-1wXD4UTCCb8Sid9eDJt74Ye55JYtNBmz2TmeUFHDH6/exec"
<br><br>
<li>var <b>SSheet</b> = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"
<br><br>
<li>var <r>SName</r> = "工作表1"
<br><br>
<li>parameter = {dow:'READJSON' , Row:0,Col:0,RRow:0,CCol:0,
             <br> SName:SName   , SSheet:SSheet          };
<br><br>
<li>var Tdata;

<li>$.get(appUrl, parameter, function(data) {
<r>Tdata</r> = data  }) 
<br>
<li> <<c>/script>
</ol>
</pre>
<br>

Tdata 傳回 : <div id="TA"></div>

var SSheet = "https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0"
var SName = "工作表1"

parameter = {dow:'READJSON' , Row:0,Col:0,RRow:0,CCol:0,
              SName:SName   , SSheet:SSheet          }; 
$.get(appUrl, parameter, function(data) {
        Tdata=data ;
        txt = "Tdata = " + Tdata ;
        txt +="<br>Tdata.length = " + Tdata.length ;    
        txt +="<br>Tdata[1] = " + Tdata[1] ; 
        txt +="<br>Tdata[1][2] = " + Tdata[1][2] ; 
        TA.innerHTML= txt; })

</script>

#TA, pre{ font-size: 20px ;}
R   {color:red}
B   {color:blue}

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 測試左單右單