$(function() {
$.get("https://spreadsheets.google.com/feeds/list/1VC633BXpMElJjRWvIRuZIP7UrEhuw6BdscnrV2heox0/1/public/full?alt=json", function(data) {
var entry = data.feed.entry;
var getKeys = Object.keys(entry[0]).slice(6);
arr = getKeys.map(title => {
return entry.map((el) => {
return el[title].$t;
}).filter((el) => {
return el.trim();
});
});
console.log(getKeys);
console.log(arr);
});
});
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
上面的代码会将谷歌工作表中的数据返回到数组数组中。getKeys我一直坚持为每个组分配值arr以返回新的 arr 值:
var arr = [
gsx$fruits = ["apple", "banana"],
gsx$animals = ["monkey", "dog", "cat", "bear"],
gsx$numbers = ["one", "two", "three", "four"]
]
...这样我就可以不仅通过索引位置访问特定组。感谢您的帮助!
狐的传说
繁花不似锦
相关分类