✍ 📁 🙈 🙉 🙊 : 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()

✍ 📁 🙈 🙉 🙊

window Resize

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單