✍ 📁 🙈 🙉 🙊 : Google Apps Script 1

<h3>get Google SpreadSheet content</h3>
<table border="1" style="width:100%">
<tbody><tr><td>
<div width="100%"><</c>script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"><<c>/script>

<br>
var appUrl = "apps script appUrl " ;
<tr><td>

parameter = { }  // 讀取 Google 試算表 資訊
<br>$.get(appUrl, parameter, function(data) {.......})</pre>
<div id="DP1"></div>

</td></tr><td>

parameter={ dow:'ReadData' } // 讀取 Google 試算表 內容
<br>$.get(appUrl, parameter, function(data) {.......})
<div id="DP2"></div>

</td></tr><td>
// 讀取 Google 試算表 指定位置內容 <br>
parameter = {dow:'ReadData', A1:2 , A2:1 , B1:3 , B2:3} 
<br>$.get(appUrl, parameter, function(data) {.......})</pre>
<div id="DP3"></div><br>

</td></tr><td>
// 讀取 Google 試算表 指定位置內容 <br>
parameter = {dow:'ReadData', A1:1 , A1:1 , B1:1 , B2:1}  
<br>$.get(appUrl, parameter, function(data) {.......})</pre>
<div id="DP4"></div><br>

</div>

</td></tr></tbody><table>

function IT(){
parameter = { };
$.get(appUrl, parameter, function(data) {
txt = "data = " + JSON.stringify(data ) ;
       DP1.innerHTML= txt; })

parameter = {dow:'ReadData'}; // 讀取所有內容
$.get(appUrl, parameter, function(data) {
txt = "data = " + JSON.stringify(data ) ;
       DP2.innerHTML= txt; })

parameter = {dow:'ReadData',A1:2,A2:1,B1:3,B2:3};
$.get(appUrl, parameter, function(data) {
txt = "data = " + JSON.stringify(data ) ;
       DP3.innerHTML= txt; })

parameter = {dow:'ReadData',A1:1,A2:1,B1:1,B2:1};
$.get(appUrl, parameter, function(data) {
txt = "data = " + JSON.stringify(data ) ;
       DP4.innerHTML= txt; })

}
IT();

</script>
<a  href="https://docs.google.com/spreadsheets/d/1loDC9_v5gdeosEd01_S4x619gCmxZS6SF4uRQLo3rOg/edit#gid=0" target="_blank" title="HTML">HTML Google資料庫20240320</a>

td {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>

// 清空 Google 試算表內容
function clearALL(){
DP1.innerHTML= UPDOWN.innerHTML;
parameter = {dow:'clearALL'};
$.get(appUrl, parameter, function(data) {DP() }) ;  }

// 加入 Google 試算表 部份內容
// Sdata 加入內容
// Row=2 var Col=2 加入位置
function setValuesALL(){
DP1.innerHTML= UPDOWN.innerHTML;
var Sdata=[['你','好','嗎'],[2,22,222],[3,33,333],[4,44,444]]
 var Row=2 ; var Col=2 ;
parameter = {dow:'setValuesALL' , Sdata:JSON.stringify(Sdata) ,
             Row:Row , Col:Col  };
$.get(appUrl, parameter, function(data) {DP(); }) ;  }

</script>

<h3>Modify Google SpreadSheet content</h3>

<div id="UPDOWN" style="display:none">
<marquee scrollamount="10" style="width:200px" ><b>
....upload....download.... </b></marquee></div>

<table border="1" style="width:100%;">
<tbody><tr><td height="150px">
<button onclick="clearALL()" >清空 Google 試算表內容</button>
<pre>parameter = {dow:'<r>clearALL</r>'}; 
$.get(appUrl, parameter, function(data) {......}) </pre><br>
<tr><td height="150px">
<button onclick="setValuesALL()" >加入 Google 試算表 部份內容</button>
<pre><m> // 加入試算表部份內容放入 Sdata 序列物件</m>
var Sdata=[['你','好','嗎'],[2,22,222],[3,33,333],[4,44,444]]
<m> // Row 及 Col 放入試算表位置,如果Row=0放入試算表最底加新一行   </m>
var Row=2 ; var Col=2 ;
parameter = {dow:'<r>setValuesALL</r>' , Sdata:JSON.stringify(DD) 
             Row:Row , Col:Col  };
$.get(appUrl, parameter, function(data) {.....}) ;</pre>
</td></tr><td>
<div id="DP1"></div> 
</td></tr></tbody><table>

// Google 試算表 刪除列,rowIndex:2 插入列在第二行,numRows:3  合共插入2列
function deleteRows(){
DP1.innerHTML= UPDOWN.innerHTML;
parameter = {dow:'deleteRows' , rowIndex:2 , numRows:2};
$.get(appUrl, parameter, function(data) {DP() }) ;   }

//Google 試算表 插入多個列,rowIndex:2 刪除列在第二行,numRows:3  刪除插入2列
function insertRows(){
DP1.innerHTML= UPDOWN.innerHTML;
parameter = {dow:'insertRows' , rowIndex:2 , numRows:2};
$.get(appUrl, parameter, function(data) {DP() }) ;   }

</script>

<h3>Modify Google SpreadSheet content</h3>

<div id="UPDOWN" style="display:none">
<marquee scrollamount="10" style="width:200px" ><b>
....upload....download.... </b></marquee></div>

<table border="1" style="width:100%;">
<tbody><tr><td height="150px">
<button onclick="insertRows()" >Google 試算表 插入列 </button>
<pre>parameter = {dow:'<r>insertRows</r>' , rowIndex:2 , numRows:2} 
$.get(appUrl, parameter, function(data) {......}) </pre><br>
<tr><td height="150px">

<button onclick="deleteRows()" >Google 試算表 刪除多個列</button>
<pre>parameter = {dow:'<r>deleteRows</r>' , rowIndex:2 , numRows:2 };
$.get(appUrl, parameter, function(data) {.....}) ;
<br></pre>
</td></tr><td>
<div id="DP1"></div> 
</td></tr></tbody><table>

// Google 試算表 刪除欄位 [rowIndex:2 刪除第二欄] [numRows:3  合共刪除2欄]
function deleteColumns(){
DP1.innerHTML= UPDOWN.innerHTML;
parameter = {dow:'deleteColumns' , colIndex:2 , numcols:2};
$.get(appUrl, parameter, function(data) {DP() }) ;   }

//Google 試算表 插入欄位, [colIndex:2 第二行插入欄位] [numcol:2  插入2欄]
function insertColumns(){
DP1.innerHTML= UPDOWN.innerHTML;
parameter = {dow:'insertColumns' , colIndex:2 , numcols:2};
$.get(appUrl, parameter, function(data) {DP() }) ;   }

</script>

<h3>Modify Google SpreadSheet content</h3>

<div id="UPDOWN" style="display:none">
<marquee scrollamount="10" style="width:200px" ><b>
....upload....download.... </b></marquee></div>

<table border="1" style="width:100%;">
<tbody><tr><td height="150px">
<button onclick="insertColumns()" >Google 試算表 插入多欄位 </button>
<pre>parameter = {{dow:'<r>insertColumns</r>' , colIndex:2 , numcols:2} 
$.get(appUrl, parameter, function(data) {......}) </pre><br>
<tr><td height="150px">

<button onclick="deleteColumns()" >Google 試算表 刪除多欄位</button>
<pre>parameter = {dow:'<r>deleteColumns</r>' , colIndex:2 , numcols:2};
$.get(appUrl, parameter, function(data) {data) {.....}) ;
<br></pre>
</td></tr><td>
<div id="DP1"></div> 
</td></tr></tbody><table>

Edit

#get Google SpreadSheet content #Modify Google SpreadSheet content() #blogger #google blogger #google apps script #Google Sheets 為網頁資料庫 #免費資料庫 #setValuesALL() clear() #getRange() #getDataRange() #insertRows()

✍ 📁 🙈 🙉 🙊

window Resize

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單