通过Javascript访问Google-apps公共电子表格 [英] Access Google-apps public spreadsheet via Javascript
问题描述
花了很多时间看这个..似乎关于访问Google-apps电子表格的信息不是很好维护..
Google IO今年有一个增强的公告Google-apps脚本。包括UI元素..
这让我想到了基于Google电子表格中的数据创建小部件，没有数据只是简单的读取/查找和显示计算。然后我意识到UI功能仅适用于Premier帐户..不是每年只需50美元和一些免费试用时间的大笔交易。似乎ui功能可能有点限制性。
然后我开始思考我可能要做的所有小事情，所以我开始研究如何从Javascript访问电子表格，在这种情况下我认为它们可以是一个简单的I-Google小工具.I-Google小工具功能非常强大且灵活。这可以提供更大的灵活性。简而言之，我已经做得很短......其他人在那里？这种看起来像是一条线索 http://almaer.com/blog/ gspreadsheet-javascript-helper-for-google-spreadsheets 以及我无法获取当前电子表格的 http://code.google.com/apis/gdata/samples/spreadsheet_sample.html 但是长时间没有触摸过，我无法在当前的电子表格中使用它。
这是当前的公开只读电子表格。 http://spreadsheets1.google.com/ccc?key=tzbvU7NnAnWkabYmGo4VeXQ&hl=en
这是谷歌现在提到的，因为它的旧格式，我已经尝试了（旧的和新的）..不知道这是否有任何区别..
我已经实现了一个相当完整的例子，代码是
https://bitbucket.org/tbrander/ggadget/wiki/Home
代码是BSD许可证（商标和机构标记除外，均为权利）保留）
评论相当好......
它在
运作 http://acre.cba.ua.edu/ （页面底部）
独自站立：
http://acre.cba.ua.edu/mobiletool/res.html
<它可以在IE，Chrome FF i-Phone和Android
上运行。您的上述提示已接近但我正在寻找更多...正如您现在可以看到的那样，但我将探索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=en This 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 at https://bitbucket.org/tbrander/ggadget/wiki/Home Code is BSD license (except for Trademarks and institutional markings which are all rights reserved) It is reasonably well commented... It is in operation at http://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公共电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
