讀取 Google 試算表 json 2

Google 表單 － 建立免費雲端資料庫
篩選內容

資料庫 試算表網址 後面加入 &q=bb ，代表篩選出 試算表 包含有 bb 內容。
https://spreadsheets.google.com/feeds/list/1HFp4Uhn5sf09BFeZoWlvEE3zD26H0IlBMzSEfRNQUI4/1/public/values?alt=json-in-script&q=bb


用 HTML script 讀取 Google 試算表 json 內容。

<div id="TXT1"> </div> <script type="text/javascript" > var xhr = new XMLHttpRequest(); xhr.open("GET", "https://spreadsheets.google.com/feeds/list/1HFp4Uhn5sf09BFeZoWlvEE3zD26H0IlBMzSEfRNQUI4/1/public/values?alt=json-in-script&q=bb", false); xhr.send(); var json = xhr.responseText; var obj = JSON.parse(json.slice(28,json.length-2)); var spData=obj.feed.entry; var Atxt="<table style='font-size:20px;border: 3px solid black' border='1'><tbody><tr>"; Atxt += "<td align='center' bgcolor='darkorange' width='300px'>date</td>"; Atxt += "<td align='center' bgcolor='darkorange' width='200px'>a1</td>"; Atxt += "<td align='center' bgcolor='darkorange' width='200px'>a2</td>"; Atxt += "<td align='center' bgcolor='darkorange' width='200px'>a3</td>"; Atxt += "<td align='center' bgcolor='darkorange' width='200px'>a4</td></tr><tr>"; for (ii = 0; ii < obj.feed.entry.length;ii++){ Atxt += "<td align='right'>" + spData[ii].gsx$date.$t +"</td>"; Atxt += "<td align='right'>" + spData[ii].gsx$a1.$t +"</td>"; Atxt += "<td align='right'>" + spData[ii].gsx$a2.$t +"</td>"; Atxt += "<td align='right'>" + spData[ii].gsx$a3.$t +"</td>"; Atxt += "<td align='right'>" + spData[ii].gsx$a4.$t +"</td>"; Atxt += "</tr>"; } Atxt += "</tbody></table><br>"; document.getElementById("TXT1").innerHTML= Atxt ; </script>

00