javascript - 请求谷歌电子表格时的简单 Json 格式

Question

我正在使用谷歌电子表格 API 从 javascript 中的谷歌表格中读取数据。我需要阅读 Google 表格

我希望结果是这样的:

result = [ {
        Title : 'Item1',
        Description : 'The items in this list are read dynamically from an external file for now. We can specify the Title, the description and the url of icon image.',
        Icon : 'http://icons.iconarchive.com/icons/dapino/medical/128/medical-suitecase-icon.png'
    },
    {
        Title : 'Item2',
        Description : 'Some Long description to check how the text will appear if it is too long in the info list view. It should wrap automatically and the height of the row should be adjusted as needed. I will add some more worlds.',
        Icon : 'http://icons.iconarchive.com/icons/dapino/summer-holiday/128/compass-icon.png'
    },
    {
        Title : 'Item3',
        Description : 'The pc icon is just a test icon. It can be replaced by any image local or on the server. I just used this one for testing.',
        Icon : 'http://icons.iconarchive.com/icons/gabriel-leblanc/historic-mac/128/ibook-g4-12-icon.png'
    },
    {
        Title : 'Item4',
        Description : 'Adding a final item that will be out of range of the view. You will have to scroll to see it. (at least on the iphone)',
        Icon : 'http://icons.iconarchive.com/icons/double-j-design/ravenna-3d/128/V-Card-icon.png'
    }
];

当我使用此 URL 作为 jsonp 以 json 形式请求工作表时:

我得到一个非常困惑的 Json 。有没有办法可以修改 url 以返回类似于我想要的内容？或者更简单的东西。我发现很难从返回的 Json 中提取值

Answer 1

Tabletop.js还有更高级的Sheetsee.js有效地完成这项工作。