问题描述
花了很多时间看这个..似乎关于访问Google-apps电子表格的信息不是很好维护..
Google IO今年有一个增强的公告Google-apps脚本。包括UI元素..
这让我想到了基于Google电子表格中的数据创建小部件，没有数据只是简单的读取/查找和显示计算。然后我意识到UI功能仅适用于Premier帐户..不是每年只需50美元和一些免费试用时间的大笔交易。似乎ui功能可能有点限制性。
然后我开始思考我可能要做的所有小事情，所以我开始研究如何从Javascript访问电子表格，在这种情况下我认为它们可以是一个简单的I-Google小工具.I-Google小工具功能非常强大且灵活。这可以提供更大的灵活性。简而言之，我已经做得很短......其他人在那里？这种看起来像是一条线索以及我无法获取当前电子表格的但是长时间没有触摸过，我无法在当前的电子表格中使用它。
这是当前的公开只读电子表格。
这是谷歌现在提到的，因为它的旧格式，我已经尝试了（旧的和新的）..不知道这是否有任何区别..
我已经实现了一个相当完整的例子，代码是
代码是BSD许可证（商标和机构标记除外，均为权利）保留）
评论相当好......
它在
运作（页面底部）
独自站立：
上运行。您的上述提示已接近但我正在寻找更多...正如您现在可以看到的那样，但我将探索Jquery语法作为当前实现是纯JS
Spent a bunch of time looking at this.. It seems that what little info there was about accessing a Google-apps spreadsheet is not very well maintained..At Google IO this year there was an announcement of enhanced Google-apps script. Including UI elements..
That got me to thinking of creating a widget based on data in Google spreadsheets, no data writing just a simple reading/look up and display calculations.. Then I realized the UI feature was only available for Premier account.. Not a huge deal at only $50/yr and some free trial time up front. It seems that the ui feature may be somewhat restrictive.
But then I began to think about all the little things I might have to do,, so I started to investigate how to just access the spreadsheets from Javascript, in which case I think they could be a plain I-Google gadget.. an I-Google gadget is quite powerful and flexible in what it can do. And this could allow a lot more flexibility.. In short I've come up short.. anyone else out there? This sort of looked like a clue http://almaer.com/blog/gspreadsheet-javascript-helper-for-google-spreadsheets and this one which I could not fetch a current spreadsheet http://code.google.com/apis/gdata/samples/spreadsheet_sample.html but has not been touch for a long time and I could not make it work on a current spreadsheet.
Here is a current "public" read only spreadsheet. http://spreadsheets1.google.com/ccc?key=tzbvU7NnAnWkabYmGo4VeXQ&hl=enThis is in what Google now refers t as it's old format, I've tried both (old and new).. don't know if that makes any difference..
I have implemented a fairly complete example and the code is athttps://bitbucket.org/tbrander/ggadget/wiki/HomeCode is BSD license (except for Trademarks and institutional markings which are all rights reserved)It is reasonably well commented...It is in operation athttp://acre.cba.ua.edu/ (bottom of page)Stand alone at :http://acre.cba.ua.edu/mobiletool/res.html
It functions across IE, Chrome FF i-Phone and Android Your hints above are close but I was looking for yet more... as You can now see,, But I will explore the Jquery syntax as the current implementation is pure JS
这篇关于通过Javascript访问Google-apps公共电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！