/*
$.getJSON("https://spreadsheets.google.com/feeds/cells/1IuQajNlsOX0w2NXRqPurqvWggEtWnygjToZLMqUFGNc/1/public/values?alt=json", function(data) {
//first row "title" column
// console.log(data.feed.entry[0]['gsx$title']['$t']);
alert("qq");
alert(data.feed.entry[0]['gsx$title']['$t']);
});
$.getJSON("https://spreadsheets.google.com/feeds/cells/1IuQajNlsOX0w2NXRqPurqvWggEtWnygjToZLMqUFGNc/1/public/values?alt=json", function(result){
$.each(result, function(i, field){
$("div").append(field + " ");
});
});
//https://docs.google.com/spreadsheets/d/1IuQajNlsOX0w2NXRqPurqvWggEtWnygjToZLMqUFGNc/pubhtml
$.getJSON("https://spreadsheets.google.com/feeds/cells/1IuQajNlsOX0w2NXRqPurqvWggEtWnygjToZLMqUFGNc/1/public/values?alt=json",function(JData){
for (var i=0; i < JData.feed.entry.length ;i++){
var id = JData.feed.entry[i].id.$t; //link???
var title = JData.feed.entry[i].title.$t; //A1
var content = JData.feed.entry[i].content.$t; //content
if(i !== 0 && i % 2 == 0)
{
$( ".inner" ).append("
");
}
if(i % 2 == 0)
{
$( ".inner" ).append("cell_" + i + "(image tag) = " + content + "; ");
}
else
{
$( ".inner" ).append("cell_" + i + "(image description) = " + content + "; ");
}
}
});
*/
reference:
https://docs.google.com/spreadsheets/d/1IuQajNlsOX0w2NXRqPurqvWggEtWnygjToZLMqUFGNc/edit?usp=sharing
http://www.ioa.tw/google-sheets-api-note.html
http://www.kamira.co.vu/2012/11/jquery-google-spreadsheet.html
http://www.w3schools.com/jquery/ajax_getjson.asp
http://stackoverflow.com/questions/24293329/getting-json-data-from-google-spreadsheets-uncaught-typeerror
http://jsonviewer.stack.hu/#https://spreadsheets.google.com/feeds/cells/1IuQajNlsOX0w2NXRqPurqvWggEtWnygjToZLMqUFGNc/1/public/values?alt=json
JQuery
http://api.jquery.com/append/
https://forum.gamer.com.tw/Co.php?bsn=60292&sn=7871
http://stackoverflow.com/questions/14885231/getting-value-of-a-cell-from-google-docs-spreadsheet-into-javascript
0 意見:
張貼留言