✍ 📁 🙈 🙉 🙊 : Blogger Google資料庫

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

2024年4月6日星期六

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() #免費資料庫

2024年4月4日星期四

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

2024年3月28日星期四

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)

2024年4月6日 星期六

Google Apps Script

建立 Google Sheets 為網頁資料庫

2024年4月4日 星期四

Google Apps Script 2

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

2024年3月28日 星期四

Google Apps Script 1

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

2024年4月6日星期六

2024年4月4日星期四

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

2024年3月28日星期四

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