✍ 📁 🙈 🙉 🙊

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()

CK General ledger

<h3 class="h3" >Modify Google SpreadSheet content</h3>

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

<button onclick="Upload() ">upload renew</button>
<div id="DP1"></div> 
<div id="DP2"></div>

parameter = {dow:'ReadData' };
$.get(appUrl, parameter, function(data) {
     alert(JSON.stringify(data)) ; 
     Mdata=data ; DP();})

function DP(){ 
txt = "" ;
txt+= "<table id='table1' >" ;
txt+= "<tbody>"
txt+="<tr class='ColNO'><td> </td>" ;
   for(var ccc=0 ;ccc< Mdata[0].length ;ccc++){
       txt+="<td class='ColNO'>" ;
       txt+= "<select class='SL' " ;
       txt+= "onchange='Cchange(this.value ," + rr + ")    ;"  ;
       txt+= " this.selectedIndex=0 ')>" ;
       txt+= "<option style='display:none;'> </option>"
       txt+= "<option value='insU'> 向左插入行</option>"
       txt+= "<option value='insD'> 向右插入行</option>"
       txt+= "<option value='del'> 刪除本行</option>"
       txt+= "</select></td>" ;  }

for(var rr=0 ;rr < Mdata.length ;rr++){
      txt+= "</tr><tr><td class='RowNO'>" ;
      txt+= "<select class='SL' " ;
      txt+= "onchange='Rchange(this.value ," + rr + ")    ;"  ;
      txt+= " this.selectedIndex=0 ')>" ;
      txt+= "<option style='display:none;'> </option>"
      txt+= "<option value='insU'> 向上插入行</option>"
      txt+= "<option value='insD'> 向下插入行</option>"
      txt+= "<option value='del'> 刪除本行</option>"
      txt+= "</select></td>" ;
        for(var cc=0 ;cc< Mdata[0].length ;cc++){
            txt+= "<td><input type='text' class='INc' value='" ;
            txt+= Mdata[rr][cc] + "' onchange='CH(" ;
            txt+= rr + "," + cc + ", this.value " + ")' > </td>" ; }
}
txt+= "</td></tr></tbody><table>" ;
DP1.innerHTML= txt ; 
DP2.innerHTML= JSON.stringify(Mdata)
}

function Rchange(xx,yy){
var insCno =table1.rows[0].cells.length
Adata = [] ;
Tdata = [] ;
var assno = 0;
for(var cl=0 ; cl < insCno-1 ; cl++){Adata[cl]="new"+cl}

if(xx=="insU"){ //向上插入行
     for(cl=0 ; cl < Mdata.length ; cl++){
         if(yy == cl){ Tdata [cl] = Adata;
                       assno=1 ;
                       Tdata [cl+assno ] = Mdata[cl] ;}
     else{Tdata [cl+assno ] = Mdata[cl] ;  }
     } Mdata =Tdata ;  }

if(xx=="insD"){  // 向下插入行
     for(cl=0 ; cl < Mdata.length ; cl++){
         if(yy == cl){ Tdata [cl+assno ] = Mdata[cl] ;
                       assno=1 ;
                       Tdata [cl+assno] = Adata; }
     else{Tdata [cl+assno ] = Mdata[cl] ;  }
     } Mdata =Tdata ;  }

if(xx=="del"){  // 刪除本行
       for(cl=0 ; cl < Mdata.length-1 ; cl++){
           if(yy == cl){ assno =1} 
                Tdata[cl] = Mdata[cl+assno] ;   
           } Mdata =Tdata ;  }
DP() ;
}

function CH( rr , cc ,vv){
Mdata[rr][cc] = vv ;
DP2.innerHTML= JSON.stringify(Mdata ) ; }

}) ;
}

</script>

Edit

CSS background

<h3>CSS background 背景</h3>
<div style="margin-top：-30px">
<pre><code> background-image:url("https://xxx.jpg") 呈現一張圖片地址
 background-size     圖片尺寸 
 background-position 圖片呈現位置
 background-repeat   圖片重複的效果
 background-color    背景顏色
</code></pre></div>

<table border="0" style="font-size : 25px;">
<tbody>
<tr><td rowspan="8" style="vertical-align:top" >div {
</td><td colspan="3">width: 100% ;
</td></tr><tr><td colspan="3">height: 100%;
</td></tr><tr><td colspan="3">background-image : url("https://xxx.jpg") ;

</td></tr><tr><td>background-size :</td><td id="Bgsize">
</td><td><select id="Swidth" onchange="myDIV.style.backgroundSize = this.value;DPcss();this.selectedIndex=0" >
    <option value="" style="display:none;">background-size</OPTION>
    <option value="contain">contain</OPTION>
    <option value="cover">cover</OPTION>
    <option value="auto">auto</OPTION>
    <option value="100px 100px">100px 100px</OPTION>
    <option value="200px 200px">200px 200px</OPTION>
    <option value="200px">200px</OPTION>
    <option value="100% 100%">100% 100%</OPTION>
    <option value="80%">80%</OPTION>
    <option value="500px">500px</OPTION>
</SELECT>

</td></tr><tr><td> background-position :</td><td id="Bgposition">
</td><td><select id="Swidth" onchange="myDIV.style.backgroundPosition= this.value;DPcss();this.selectedIndex=0" >
    <option value="" style="display:none;">background-position</OPTION>
    <option value="left top">left top</OPTION>
    <option value="left center">left center</OPTION>
    <option value="left bottom">left bottom</OPTION>
    <option value="center top">center top</OPTION>
    <option value="center center">center center</OPTION>
    <option value="center bottom">center top</OPTION>
    <option value="right  top">right top</OPTION>
    <option value="right  center">right center</OPTION>
    <option value="right bottom">right  bottom</OPTION>
    <option value="50% 50%">50% 50%</OPTION>
    <option value="30% 70%">30% 70%</OPTION>
    <option value="20px 200px">20px 200px</OPTION>
    <option value="50px 300px">50px 300px</OPTION>
    <option value="initial">initial</OPTION>
</SELECT>

</td></tr><tr><td> background-repeat :</td><td id="Bgrepeat">
</td><td><select id="Swidth" onchange="myDIV.style.backgroundRepeat= this.value;DPcss();this.selectedIndex=0" >
    <option value="" style="display:none;">background-repeat</OPTION>
    <option value="no-repeat">no-repeat</OPTION>
    <option value="repeat">repeat</OPTION>
    <option value="repeat-y">repeat-y</OPTION>
    <option value="repeat-x">repeat-x</OPTION>
    <option value="space">space</OPTION>
    <option value="round">round</OPTION>
    <option value="initial">initial</OPTION>
</SELECT>

</td></tr><tr><td>  background-color :</td><td id="Bgcolor">
</td><td><select id="Swidth" onchange="myDIV.style.backgroundColor = this.value;DPcss();this.selectedIndex=0" >
    <option value="" style="display:none;">background-color</OPTION>
    <option value="red">red</OPTION>
    <option value="pink">pink</OPTION>
    <option value="gray">gray</OPTION>
    <option value="gold">gold</OPTION>
</SELECT>

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

</div>

function DPcss() { //alert( );
Bgsize.innerHTML =style.backgroundSize + " ;" ;
Bgposition.innerHTML =style.backgroundPosition + " ;";
Bgrepeat.innerHTML =style.backgroundRepeat + " ;";
Bgcolor.innerHTML = style.backgroundColor + " ; }" ;
}
DPcss();
</script>

#myDIV select { background:rgba(0, 0, 0, 0) ; 
                color:white; width:200px; 
                font-size: 20px}

#myDIV option {background-color: rgb(204, 204, 204 , 3);color:black;}

#myDIV table  {font-size: 20px ;}

pre { font-size: 18px; }
pre > code { white-space: pre;
             margin-top: -25px;
             display: block; }

h3  { text-align: center;
      font-size: 30px;
      font-weight: bold;
      text-shadow: 10px 6px 10px grey;
      color: blue; }
</style>

<h3>CSS Background Patterns</h3>
<pre><code > CSS Background Patterns 簡易單色背景 CSS 語法產生器。
 如果你的網站需求是需要一些單色的背景紋理圖案，來避免略顯單調的白色的話，
 這個 CSS Background Pattern 網站所提供的服務就非常適合。你只需要決定前景、
 背景色、透明度和紋理間的間隔，就可以即時預覽結果，並複製相關的 CSS 程式碼
 到你的網站作使用。</code></pre>

h3  { text-align: center;
      font-size: 30px;
      font-weight: bold;
      text-shadow: 10px 6px 10px grey;
      color: blue; }

.divDP {
    width: 150px;
    height: 150px;
    float: left;
    margin: 10px;
    font-size:22px;
    box-shadow: 0 1px 8px #666;
}

.pattern1 {
    background-size: 50px 50px;
    background-color: #0ae;
    background-image: -webkit-linear-gradient(rgba(255, 255, 255, .2) 50%, transparent 50%, transparent);
    background-image: linear-gradient(rgba(255, 255, 255, .2) 50%, transparent 50%, transparent);
}

.pattern2 {
    background-size: 50px 50px;
    background-color: #f90;
    background-image: -webkit-linear-gradient(0deg, rgba(255, 255, 255, .2) 50%, transparent 50%, transparent);
    background-image: linear-gradient(0deg, rgba(255, 255, 255, .2) 50%, transparent 50%, transparent);
}

.pattern3 {    background-size: 50px 50px;
    background-color: #c16;
    background-image: -webkit-linear-gradient(-45deg, rgba(255, 255, 255, .2) 25%, transparent 25%, transparent 50%, rgba(255, 255, 255, .2) 50%, rgba(255, 255, 255, .2) 75%, transparent 75%, transparent);
    background-image: linear-gradient(-45deg, rgba(255, 255, 255, .2) 25%, transparent 25%, transparent 50%, rgba(255, 255, 255, .2) 50%, rgba(255, 255, 255, .2) 75%, transparent 75%, transparent);

}

.pattern4 {
    background-size: 50px 50px;
    background-color: #ac0;
    background-image: -webkit-linear-gradient(45deg, rgba(255, 255, 255, .2) 25%, transparent 25%, transparent 50%, rgba(255, 255, 255, .2) 50%, rgba(255, 255, 255, .2) 75%, transparent 75%, transparent);
    background-image: linear-gradient(45deg, rgba(255, 255, 255, .2) 25%, transparent 25%, transparent 50%, rgba(255, 255, 255, .2) 50%, rgba(255, 255, 255, .2) 75%, transparent 75%, transparent);
}

.pattern5 {
    background-size: 50px 50px;
    background-color: white;
    background-image: 
        -webkit-linear-gradient(to top,transparent 50%, rgba(200, 0, 0, .5) 50%, rgba(200, 0, 0, .5)),
        -webkit-linear-gradient(to left, transparent 50%, rgba(200, 0, 0, .5) 50%, rgba(200, 0, 0, .5));
    background-image: 
        linear-gradient(to top,transparent 50%, rgba(200, 0, 0, .5) 50%, rgba(200, 0, 0, .5)),
        linear-gradient(to left, transparent 50%, rgba(200, 0, 0, .5) 50%, rgba(200, 0, 0, .5))
}

.pattern6 {color:red;
    background-color: #eee;
    background-size: 60px 60px;
    background-position: 0 0, 30px 30px;
    background-image: 
        -webkit-linear-gradient(45deg, black 25%, transparent 25%, transparent 75%, black 75%, black), 
        -webkit-linear-gradient(45deg, black 25%, transparent 25%, transparent 75%, black 75%, black);
    background-image: 
        linear-gradient(45deg, black 25%, transparent 25%, transparent 75%, black 75%, black),
        linear-gradient(45deg, black 25%, transparent 25%, transparent 75%, black 75%, black);
}

.pattern7 {color:red;
    background-color: #eee;
    background-size: 60px 60px;
    background-image: 
        -webkit-linear-gradient(45deg, black 25%, transparent 25%, transparent 75%, black 75%, black), 
        -webkit-linear-gradient(-45deg, black 25%, transparent 25%, transparent 75%, black 75%, black);
    background-image: 
        linear-gradient(45deg, black 25%, transparent 25%, transparent 75%, black 75%, black),
        linear-gradient(-45deg, black 25%, transparent 25%, transparent 75%, black 75%, black);
}

.pattern8 {
    background-color: #fff;
    background-size: 100% 1.2em;
    background-image: 
        -webkit-linear-gradient(to right, transparent 21px, #abced4 21px, #abced4 23px, transparent 23px), 
        -webkit-linear-gradient(#eee .05em, transparent .05em);
    background-image:   
        linear-gradient(to right, transparent 21px, #abced4 21px, #abced4 23px, transparent 23px), 
        linear-gradient(#eee .05em, transparent .05em);
}

.pattern9 {color:white;
    background: 
        -webkit-radial-gradient(circle, white 10%, transparent 10%), 
        -webkit-radial-gradient(circle, white 10%, black 10%) 50px 50px;
    background: 
        radial-gradient(circle, white 10%, transparent 10%), 
        radial-gradient(circle, white 10%, indigo 10%) 50px 50px;
    background-size: 100px 100px;
}

.pattern10{
    background: 
        -webkit-radial-gradient(circle at 0% 2%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), 
        -webkit-radial-gradient(circle at 100% 100%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), none;
    background: 
        radial-gradient(circle at 0% 2%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), 
        radial-gradient(circle at 100% 100%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), none;
    background-size: 20px 20px;
}

.pattern11 {
    background-color: #88AA33;
    background-image: -webkit-radial-gradient(circle at 0% 50%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), -webkit-radial-gradient(circle at 100% 100%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), none;
    background-image: radial-gradient(circle at 0% 50%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), radial-gradient(circle at 100% 100%, rgba(96, 16, 48, 0) 9px, #661133 10px, rgba(96, 16, 48, 0) 11px), none;
    background-position: 0 10px, 0 0%, 0 0;
    background-size: 20px 20px;
}

.pattern12{
    background-color: #330000;
    background-image: 
        -webkit-radial-gradient(#890000 4%, #5B0000 9%, rgba(102, 0, 0, 0) 9%), 
        -webkit-radial-gradient(#890000 4%, #5B0000 8%, rgba(102, 0, 0, 0) 10%), 
        -webkit-radial-gradient(rgba(153, 0, 0, 0.8) 20%, rgba(102, 0, 0, 0)), 
        -webkit-radial-gradient(rgba(153, 0, 0, 0.8) 20%, rgba(102, 0, 0, 0)), 
        -webkit-radial-gradient(#660000 35%, rgba(102, 0, 0, 0) 60%), 
        -webkit-radial-gradient(#660000 35%, rgba(102, 0, 0, 0) 60%), 
        -webkit-radial-gradient(rgba(76, 0, 0, 0.7), rgba(102, 0, 0, 0)), 
        -webkit-radial-gradient(rgba(76, 0, 0, 0.7), rgba(102, 0, 0, 0)), 
        -webkit-linear-gradient(45deg, rgba(102, 0, 0, 0) 49%, #000000 50%, rgba(102, 0, 0, 0) 70%), 
        -webkit-linear-gradient(135deg, rgba(102, 0, 0, 0) 49%, #000000 50%, rgba(102, 0, 0, 0) 70%);
    background-image: 
        radial-gradient(#890000 4%, #5B0000 9%, rgba(102, 0, 0, 0) 9%), 
        radial-gradient(#890000 4%, #5B0000 8%, rgba(102, 0, 0, 0) 10%), 
        radial-gradient(rgba(153, 0, 0, 0.8) 20%, rgba(102, 0, 0, 0)), radial-gradient(rgba(153, 0, 0, 0.8) 20%, rgba(102, 0, 0, 0)), 
        radial-gradient(#660000 35%, rgba(102, 0, 0, 0) 60%), 
        radial-gradient(#660000 35%, rgba(102, 0, 0, 0) 60%), 
        radial-gradient(rgba(76, 0, 0, 0.7), rgba(102, 0, 0, 0)), 
        radial-gradient(rgba(76, 0, 0, 0.7), rgba(102, 0, 0, 0)), 
        linear-gradient(45deg, rgba(102, 0, 0, 0) 49%, #000000 50%, rgba(102, 0, 0, 0) 70%), 
        linear-gradient(135deg, rgba(102, 0, 0, 0) 49%, #000000 50%, rgba(102, 0, 0, 0) 70%);
    background-position: 0 0px, 50px 50px, 50px 0px, 0 50px, 50px 0px, 100px 50px, 0 0px, 50px 50px, 0 0px, 0 0;
    background-size: 100px 100px;
}

.pattern13 {color:red;
    background-color: white;
    background-image: 
        -webkit-radial-gradient(gold 9px, transparent 10px), 
        -webkit-repeating-radial-gradient(gold 0px, gold 4px, transparent 5px, transparent 20px, gold 21px, gold 25px, transparent 26px, transparent 50px);
    background-image: 
    radial-gradient(gold 9px, transparent 10px), 
    repeating-radial-gradient(gold 0px, gold 4px, transparent 5px, transparent 20px, gold 21px, gold 25px, transparent 26px, transparent 50px);
    background-position: 0 0;
    background-size: 30px 30px, 90px 90px;
}

.pattern14 {color:red;
    background-color: lightgray;
    background-image: 
        -webkit-radial-gradient(black 15%, transparent 16%), 
        -webkit-radial-gradient(black 15%, transparent 16%), 
        -webkit-radial-gradient(rgba(255, 255, 255, 0.1) 15%, transparent 20%), 
        -webkit-radial-gradient(rgba(255, 255, 255, 0.1) 15%, transparent 20%);
    background-image: 
        radial-gradient(black 15%, transparent 16%), 
        radial-gradient(black 15%, transparent 16%), 
        radial-gradient(rgba(255, 255, 255, 0.1) 15%, transparent 20%), 
        radial-gradient(rgba(255, 255, 255, 0.1) 15%, transparent 20%);
    background-position: 0 0px, 8px 8px, 0 1px, 8px 9px;
    background-size: 16px 16px;
}

.pattern15 {
    background-color: #BB0033;
    background-image: 
        -webkit-radial-gradient(closest-side circle at 60% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
        -webkit-radial-gradient(closest-side circle at 40% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
        -webkit-radial-gradient(closest-side circle at 40% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%),
         -webkit-radial-gradient(closest-side circle at 60% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%), 
         -webkit-radial-gradient(closest-side circle at 50% 35%, #DD3355 30%, rgba(221, 51, 85, 0) 31%), 
         -webkit-radial-gradient(closest-side circle at 60% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
         -webkit-radial-gradient(closest-side circle at 40% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
         -webkit-radial-gradient(closest-side circle at 40% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%), 
         -webkit-radial-gradient(closest-side circle at 60% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%), 
         -webkit-radial-gradient(closest-side circle at 50% 35%, #DD3355 30%, rgba(221, 51, 85, 0) 31%);
    background-image: 
        radial-gradient(closest-side circle at 60% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
        radial-gradient(closest-side circle at 40% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
        radial-gradient(closest-side circle at 40% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%),
        radial-gradient(closest-side circle at 60% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%), 
        radial-gradient(closest-side circle at 50% 35%, #DD3355 30%, rgba(221, 51, 85, 0) 31%), 
        radial-gradient(closest-side circle at 60% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
        radial-gradient(closest-side circle at 40% 43%, #BB0033 26%, rgba(187, 0, 51, 0) 27%), 
        radial-gradient(closest-side circle at 40% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%), 
        radial-gradient(closest-side circle at 60% 22%, #DD3355 45%, rgba(221, 51, 85, 0) 46%), 
        radial-gradient(closest-side circle at 50% 35%, #DD3355 30%, rgba(221, 51, 85, 0) 31%);
    background-position: 0 0%, 0 0%, 0 0%, 0 0%, 0 0%, 50px 50px, 50px 50px, 50px 50px, 50px 50px, 50px 50px;
    background-size: 100px 100px;
}
.pattern16 {
    background-color: lightgray;
    background-image:
        -webkit-repeating-linear-gradient(120deg, rgba(169,169,169,.4), rgba(255,255,255,.1) 1px, transparent 1px, transparent 60px),
        -webkit-repeating-linear-gradient(60deg, rgba(169,169,169,.4), rgba(255,255,255,.1) 1px, transparent 1px, transparent 60px),
        -webkit-linear-gradient(60deg, rgba(0,0,0,.1) 25%, transparent 25%, transparent 75%, rgba(0,0,0,.1) 75%, rgba(0,0,0,.1)),
        -webkit-linear-gradient(120deg, rgba(0,0,0,.1) 25%, transparent 25%, transparent 75%, rgba(0,0,0,.1) 75%, rgba(0,0,0,.1));
    background-image:
        repeating-linear-gradient(120deg, rgba(169,169,169,.8), rgba(169,169,169,.8) 1px, transparent 1px, transparent 60px),
        repeating-linear-gradient(60deg, rgba(169,169,169,.8), rgba(169,169,169,.8) 1px, transparent 1px, transparent 60px),
        linear-gradient(60deg, rgba(0,0,0,.1) 25%, transparent 25%, transparent 75%, rgba(0,0,0,.1) 75%, rgba(0,0,0,.1)),
        linear-gradient(120deg, rgba(0,0,0,.1) 25%, transparent 25%, transparent 75%, rgba(0,0,0,.1) 75%, rgba(0,0,0,.1));
    background-size: 70px 120px;
}
.pattern17 {
    background-image: 
        -webkit-radial-gradient( circle at 100% 50% , transparent 20%, rgba(255, 255, 255, 0.3) 21%, rgba(255, 255, 255, 0.3) 34%, transparent 35%, transparent),
        -webkit-radial-gradient( circle at 0% 50% , transparent 20%, rgba(255, 255, 255, 0.3) 21%, rgba(255, 255, 255, 0.3) 34%, transparent 35%, transparent);
    background-image: 
        radial-gradient(circle at 100% 50%, transparent 20%, rgba(255, 255, 255, 0.3) 21%, rgba(255, 255, 255, 0.3) 34%, transparent 35%, transparent), 
        radial-gradient( circle at 0% 50%, transparent 20%, rgba(255, 255, 255, 0.3) 21%, rgba(255, 255, 255, 0.3) 34%, transparent 35%, transparent);
    background-color: slategray;
    background-size:75px 100px;
  background-position: 0 0%, 0 -50px;
}

.pattern18{color:red;
  background-color: rgb(0,255,255,0.2);
  background-image: 
    -webkit-radial-gradient(circle at 50% 59%, white 3%, black 4%, black 11%, rgba(54, 78, 39, 0) 12%, rgba(54, 78, 39, 0)), 
    -webkit-radial-gradient(circle at 50% 41%, black 3%, white 4%, white 11%, rgba(210, 202, 171, 0) 12%, rgba(210, 202, 171, 0)), 
    -webkit-radial-gradient(circle at 50% 59%, white 3%, black 4%, black 11%, rgba(54, 78, 39, 0) 12%, rgba(54, 78, 39, 0)), 
    -webkit-radial-gradient(circle at 50% 41%, black 3%, white 4%, white 11%, rgba(210, 202, 171, 0) 12%, rgba(210, 202, 171, 0)), 
    -webkit-radial-gradient(circle at 100% 50%, white 16%, rgba(210, 202, 171, 0) 17%), 
    -webkit-radial-gradient(circle at 0% 50%, black 16%, rgba(54, 78, 39, 0) 17%), 
    -webkit-radial-gradient(circle at 100% 50%, white 16%, rgba(210, 202, 171, 0) 17%), 
    -webkit-radial-gradient(circle at 0% 50%, black 16%, rgba(54, 78, 39, 0) 17%);
  background-image: 
    radial-gradient(circle at 50% 59%, white 3%, black 4%, black 11%, rgba(54, 78, 39, 0) 12%, rgba(54, 78, 39, 0)), 
    radial-gradient(circle at 50% 41%, black 3%, white 4%, white 11%, rgba(210, 202, 171, 0) 12%, rgba(210, 202, 171, 0)), 
    radial-gradient(circle at 50% 59%, white 3%, black 4%, black 11%, rgba(54, 78, 39, 0) 12%, rgba(54, 78, 39, 0)), 
    radial-gradient(circle at 50% 41%, black 3%, white 4%, white 11%, rgba(210, 202, 171, 0) 12%, rgba(210, 202, 171, 0)), 
    radial-gradient(circle at 100% 50%, white 16%, rgba(210, 202, 171, 0) 17%), 
    radial-gradient(circle at 0% 50%, black 16%, rgba(54, 78, 39, 0) 17%), 
    radial-gradient(circle at 100% 50%, white 16%, rgba(210, 202, 171, 0) 17%), 
    radial-gradient(circle at 0% 50%, black 16%, rgba(54, 78, 39, 0) 17%);
  background-position: 50px 0px, 50px 0px, 0 50px, 0 50px, 0 0%, 0 0%, 50px 50px, 50px 50px;
  background-size: 100px 100px;
}

.pattern19 {
  background-color: #C8D3A7;
  background-image: 
    -webkit-radial-gradient(closest-side, transparent 0%, transparent 75%, #B6CC66 76%, #B6CC66 85%, #EDFFDB 86%, #EDFFDB 94%, #FFFFFF 95%, #FFFFFF 103%, #D9E6A7 104%, #D9E6A7 112%, #798B3C 113%, #798B3C 121%, #FFFFFF 122%, #FFFFFF 130%, #E0EAD7 131%, #E0EAD7 140%), 
    -webkit-radial-gradient(closest-side, transparent 0%, transparent 75%, #B6CC66 76%, #B6CC66 85%, #EDFFDB 86%, #EDFFDB 94%, #FFFFFF 95%, #FFFFFF 103%, #D9E6A7 104%, #D9E6A7 112%, #798B3C 113%, #798B3C 121%, #FFFFFF 122%, #FFFFFF 130%, #E0EAD7 131%, #E0EAD7 140%);
    background-image: 
        radial-gradient(closest-side, transparent 0%, transparent 75%, #B6CC66 76%, #B6CC66 85%, #EDFFDB 86%, #EDFFDB 94%, #FFFFFF 95%, #FFFFFF 103%, #D9E6A7 104%, #D9E6A7 112%, #798B3C 113%, #798B3C 121%, #FFFFFF 122%, #FFFFFF 130%, #E0EAD7 131%, #E0EAD7 140%), 
        radial-gradient(closest-side, transparent 0%, transparent 75%, #B6CC66 76%, #B6CC66 85%, #EDFFDB 86%, #EDFFDB 94%, #FFFFFF 95%, #FFFFFF 103%, #D9E6A7 104%, #D9E6A7 112%, #798B3C 113%, #798B3C 121%, #FFFFFF 122%, #FFFFFF 130%, #E0EAD7 131%, #E0EAD7 140%);
  background-position: 0 0px, 20px 20px;
  background-size: 40px 40px;
}
.pattern20 {
  background-color: #DDEEFF;
  background-image: 
    -webkit-radial-gradient(closest-side, transparent 98%, rgba(0, 0, 0, 0.3) 99%), 
    -webkit-radial-gradient(closest-side, transparent 98%, rgba(0, 0, 0, 0.3) 99%);
  background-image: 
    radial-gradient(closest-side, transparent 98%, rgba(0, 0, 0, 0.3) 99%), 
    radial-gradient(closest-side, transparent 98%, rgba(0, 0, 0, 0.3) 99%);
  background-position: 0 0px, 20px 20px;
  background-size: 40px 40px;
}
.pattern21 {background-color: #f76;
  background-image:
    linear-gradient(30deg, #fee 13.5%, transparent 13.5%, transparent 86.5%, #fee 86.5%),
    linear-gradient(-30deg, #fee 13.5%, transparent 13.5%, transparent 86.5%, #fee 86.5%),
    linear-gradient(30deg, #dcc 13.5%, transparent 13.5%, transparent 86.5%, #dcc 86.5%),
    linear-gradient(-30deg, #dcc 13.5%, transparent 13.5%, transparent 86.5%, #dcc 86.5%),
    linear-gradient(30deg, #fee 13.5%, transparent 13.5%, transparent 86.5%, #fee 86.5%),
    linear-gradient(-30deg, #fee 13.5%, transparent 13.5%, transparent 86.5%, #fee 86.5%),
    linear-gradient(30deg, #dcc 13.5%, transparent 13.5%, transparent 86.5%, #dcc 86.5%),
    linear-gradient(-30deg, #dcc 13.5%, transparent 13.5%, transparent 86.5%, #dcc 86.5%),
    linear-gradient(45deg, #544 25%, transparent 25%, transparent 75%, #544 75%),
    linear-gradient(45deg, #544 25%, transparent 25%, transparent 75%, #544 75%);
  background-position:
    0em 1em,
    0em 1em,
    1em 2em,
    1em 2em,
    2em 1em,
    2em 1em,
    3em 2em,
    3em 2em,
    0em 0em,
    1em 1em;
  background-size:
    4em 2em,
    4em 2em,
    4em 2em,
    4em 2em,
    4em 2em,
    4em 2em,
    4em 2em,
    4em 2em,
    2em 2em,
    2em 2em;
}       
    </style>
    <div class="divDP pattern1">pattern 1</div>
    <div class="divDP pattern2">pattern 2</div>
    <div class="divDP pattern3">pattern 3</div>
    <div class="divDP pattern4">pattern 4</div>
    <div class="divDP pattern5">pattern 5</div>
    <div class="divDP pattern6">pattern 6</div>
    <div class="divDP pattern7">pattern 7</div>
    <div class="divDP pattern8">pattern 8</div>
    <div class="divDP pattern9">pattern 9</div>
    <div class="divDP pattern10">pattern 10</div>
    <div class="divDP pattern11">pattern 11</div>
    <div class="divDP pattern12">pattern 12</div>
    <div class="divDP pattern13">pattern 13</div>
    <div class="divDP pattern14">pattern 14</div>
    <div class="divDP pattern15">pattern 15</div>
    <div class="divDP pattern16">pattern 16</div>
    <div class="divDP pattern17">pattern 17</div>
    <div class="divDP pattern18">pattern 18</div>
    <div class="divDP pattern19">pattern 19</div>
    <div class="divDP pattern20">pattern 20</div>
    <div class="divDP pattern21">pattern 21</div>

Edit

#ccs #HTML #background-image:url #background-size #background-position #background-repeat #background-color #Background Patterns #ccs background

訂閱：文章 (Atom)

✍ 📁 🙈 🙉 🙊

window Resize

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單

Google Apps Script 2

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

Google Apps Script 1

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

CK General ledger

CSS background

window Resize

html 測試 左入右出

html 測試 上入下出

html 測試 單入單出

html 測試 左單右單

Google Apps Script 2

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

Google Apps Script 1

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

CK General ledger

CSS background

html 測試左入右出

html 測試上入下出

html 測試單入單出

html 測試左單右單

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

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