✍ 📁 🙈 🙉 🙊 : Blogger Google資料庫

顯示具有 Blogger Google資料庫 標籤的文章。顯示所有文章

Google Apps Script

建立 Google Sheets 為網頁資料庫

<h3>Google Apps Script development platform
<br><br>
<img style="width:80%;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja7higLn_5MgI7cpNonQrpXhe-h8JjNoDQ6rctVKFYA6OG1bFxhAxYBnpHRHzXZN-B0sUEv1duFeSidqyKebk-2q3BREWzHvieKFwd1w-i-enFIftkhI8eotxgk0NPyx80f4myd11FVlCUz7dL2qqit9YBpi5XjuBAX3G85gta6aGkvtw/s1600/app2.jpg" /></h3>

<pre> 進入 Apps Script 指令碼的地方，編寫寫你的 apps script，
 測試偵錯之後，發佈部署上網，供 HTML 向 Google 試算表
 讀取或寫入資料 的橋樑。</pre>

<Tn>
☛ <a  href="https://script.google.com/u/0/home/projects/177_UBdBm6WvzxeBN_9RbH_Mz0B9MQ44E-Xs5esKA990DsvE1M1Ea4jjV/edit" target="_blank" title="HTML">我的 Apps Script </a> 
<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> 
</Tn>

.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>

Edit

#ccs #HTML #blogger #google blogger #google apps script #Google Sheets 為網頁資料庫 #免費資料庫 #doGet(e) #deleteColumns() #insertColumns() #免費資料庫

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

Google Apps Script 1

set Google SpreadSheet content
設定 Google 試算表內容

<ol>
<li><<?>button onclick="clearALL()" ><r>清空 Google 試算表內容 
     </r><<?>/button>

<li><<?>button onclick="addALL()"   ><r>加入 Google 試算表內容 
    </r><<?>/button>

<li><<?>button onclick="addRow()"  ><r>第二行插入新二行</r><<?>/button>
<li><<?>button onclick="delRow()"  ><r>刪除第二及三行</r>  <<?>/button>

<li><<?>button onclick="addCol()"  ><r>第二欄 插入欄位</r> <<?>/button>
<li><<?>button onclick="delCol()"  ><r>刪除第二欄</r>     <<?>/button>
</ol>
<marquee id="mm" width="100%"scrollamount="20">
    ...upload...download...</marquee>

<button class="BB" onclick="clearALL()" >清空 Google 試算表內容</button>
<button class="BB" onclick="addALL()"   >加入 Google 試算表內容</button>
<br><br>
<button class="BB" onclick="addRow()"   >第二行插入新二行</button>
<button class="BB" onclick="delRow()"   >刪除第二及三行</button>
<br><br>
<button class="BB" onclick="addCol()"   >第二欄 插入欄位</button>
<button class="BB" onclick="delCol()"   >刪除第二欄 </button>

function delCol(){  UD(1) ;
parameter = {dow:'deleteColumns',colIndex:2,numcols:1}; 
$.get(appUrl, parameter, function(data) { Stable() })
}

function addCol(){  UD(1) ;
parameter = {dow:'insertColumns',colIndex:2,numcols:1}; 
$.get(appUrl, parameter, function(data) { Stable() })
}

function delRow(){  UD(1) ;
parameter = {dow:'deleteRows',rowIndex:2,numRows:2}; 
$.get(appUrl, parameter, function(data) { Stable() })
}

function addRow(){  UD(1) ;
parameter = {dow:'insertRows',rowIndex:2,numRows:2}; 
$.get(appUrl, parameter, function(data) { Stable() })
}

function clearALL(){  UD(1) ;
parameter = {dow:'clearALL' }; 
$.get(appUrl, parameter, function(data) { Stable() })
}

//************************************************************
function Stable(){  UD(1) ;
var txt="";
parameter = {dow:'READJSON' ,Row:0,Col:0,RRow:0,CCol:0}; 
$.get(appUrl, parameter, function(data) {
              txt+= "<table id='table1' ><tbody>" ;
              for(var rr=0 ;rr < data.length ;rr++){
                   txt+= "</tr><tr>" ;
                   for(var cc=0 ;cc< data[0].length ;cc++){
                    txt+= "<td>"  + data[rr][cc] + "</td>" ; }
               }
txt+= "</td></tr></tbody><table>" ;
TT.innerHTML= txt; 
  UD(2) })
}

Stable() ;
</script>

#mm{font-size: 18px}

ol { background-color:tan ;}
li { background-color:ivory ;
     padding-left:10px;
     text-align: left;
     font-size: 18px ;}

#table1    { border-style:solid;}
#table1 td { border: 1px solid brown;
             padding:0px 10px;
             height:20px;
             min-height:500px; 
             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>

<ol>
<li><<?>script>

<li><TT>var appUrl= "https://script.google.com/macros/s/AKfycbwRszX3TbwcxYwBfAphcFmQdjV1hg02VJ6ETIkGcPOnO6uV7UyZ1iSIaurVgMDePUdn6w/exec"</TT>
<br><br>
<li>function clearALL(){ // ** 清空 工作表 內容 ** 
<li>parameter = { <R>dow:'clearALL'</R> }; 
<li>$.get(appUrl, parameter, function(data) {.....})
<li>}
<br><br>
<li>function addALL(){ // ** 加入 工作表 內容 **
<li>var sd=[['0','1','2','3'],['a','你','好','嗎'],
        ['b',2,22,222],['c',3,33,333],['d',4,44,444]] ;
<li>parameter = {<R>dow:'SaveJSON'</R>,Sdata:JSON.stringify(sd),Row:1,Col:1}; 
<li>$.get(appUrl, parameter, function(data) {.....})
<li>}
<br><br>
<li>function addRow(){ // ** 插入列 Insert Row **
<li>parameter = {<R>dow:'insertRows'</R>,rowIndex:2,numRows:2}; 
<li>$.get(appUrl, parameter, function(data) {.....})
<li>}
<br><br>
<li>function delRow(){ // ** 刪除多個列 delete Rows **
<li>parameter = {<R>dow:'deleteRows'</R>,rowIndex:2,numRows:2}; 
<li>$.get(appUrl, parameter, function(data) {.....})
<li>}
<br><br>
<li>function addCol(){ // ** 插入欄位 insert Columns **
<li>parameter = {<R>dow:'insertColumns'</R>,colIndex:2,numcols:1}; 
<li>$.get(appUrl, parameter, function(data) {.....})
<li>}
<br><br>
<li>function delCol(){ // ** 刪除多欄位 delete  Columns **
<li>parameter = {<R>dow:'deleteColumns'</R>,colIndex:2,numcols:1}; 
<li>$.get(appUrl, parameter, function(data) {.....})
<li>}
<li><<?>/script>

</ol>

#B1 , #B2 ,TT ,#mm{font-size: 18px} 
div {word-break: break-all; word-wrap: break-word;
     font-size: 20px ;}
ol { background-color:tan ;}
li { background-color:ivory ;
     padding-left:10px;
     text-align: left;
     font-size: 18px ;}

#table1    { border-style:solid;}
#table1 td { border: 1px solid brown;
             padding:0px 10px;
             height:20px;
             min-height:500px; 
             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 #Modify Google SpreadSheet content() #blogger #google blogger #google apps script #Google Sheets 為網頁資料庫 #免費資料庫 #setValuesALL() clear() #getRange() #getDataRange() #insertRows()

訂閱：文章 (Atom)

✍ 📁 🙈 🙉 🙊

window Resize

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單

Google Apps Script

建立 Google Sheets 為網頁資料庫

Google Apps Script 2

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

Google Apps Script 1

set Google SpreadSheet content
設定 Google 試算表內容

window Resize

html 測試 左入右出

html 測試 上入下出

html 測試 單入單出

html 測試 左單右單

Google Apps Script

建立 Google Sheets 為網頁資料庫

Google Apps Script 2

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

Google Apps Script 1

set Google SpreadSheet content 設定 Google 試算表內容

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單

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

set Google SpreadSheet content
設定 Google 試算表內容