I have a fairly complex (for me anyway) excel spreadsheet which keeps track of team time(s) for a multi-stage sled-dog race http://copperdog150.com/.
我有一个相当复杂的(对我来说)excel电子表格,它记录了多阶段雪橇犬比赛http://copperdog150.com/的团队时间。
the excel spread-sheet calculates time per leg for each team, over all time, mph, order of finish, overall winner, etc, etc. the excel spreadsheet is in a laptop which travels with the race.
excel电子表格计算每个团队的每条腿的时间,包括所有时间,每小时,完成顺序,总体获胜者等等.excel电子表格位于随着比赛旅行的笔记本电脑中。
i hope to keep using the excel spreadsheet (is it worth trying to 'convert' it into a google spreadsheet? I am afraid I will be limited; I have macros for one) but was hoping I could have google docs constantly 'import' my data (e.g., times, overall winner) so HQ, race directors, and the like can just look on the web (phone/computer/tablet) to see the results... or maybe its having excel constantly 'export' the data.
我希望继续使用excel电子表格(是否值得尝试将其“转换”为谷歌电子表格?我担心我会受到限制;我有一个宏)但我希望我可以让google文档不断“导入”我的数据(例如,时间,总冠军)所以HQ,赛事总监等可以只是在网络上看到(结果是电话/计算机/平板电脑)看到结果......或者它可能会不断地“出口”数据。
i will be in the woods but my laptop has wireless and my phone (assuming I have signal) works great as a hotspot. data in the excel spreadsheet changes constantly so I would like the google spreadsheet to be 'real time'.
我将在树林里,但我的笔记本电脑有无线和我的手机(假设我有信号)作为一个热点很好。 excel电子表格中的数据不断变化,所以我希望谷歌电子表格是“实时”。
is this possible? if so, how? I am not an expert...
这可能吗?如果是这样,怎么样?我不是专家...
thanks in advance, kiko
谢谢,kiko
2 个解决方案
#1
0
There's importxml function in Google sheet to import xml data and you can also parse the data. It's fairly complicated. (more doc on importxml https://support.google.com/docs/answer/3093342)
Google表格中有importxml函数来导入xml数据,您也可以解析数据。这很复杂。 (更多doc on importxml https://support.google.com/docs/answer/3093342)
Another alternative is to use Script Editor (Select Tools -> Script editor). Essentially, you write your own script (Google App script, similar to JavaScript) to fetch and parse the data (JSON, etc).
另一种方法是使用脚本编辑器(选择工具 - >脚本编辑器)。基本上,您编写自己的脚本(Google App脚本,类似于JavaScript)来获取和解析数据(JSON等)。
Sometime, it's necessary to create a custom script if the dataset is complicated. But, some other time, importxml will just do.
有时,如果数据集很复杂,则需要创建自定义脚本。但是,在其他时候,importxml将会这样做。
This is a good start (importxml or Script Editor): http://www.computerworld.com/article/2469616/business-intelligence/business-intelligence-79661-how-to-create-an-automatically-updating-spreadsheet.html
这是一个好的开始(importxml或脚本编辑器):http://www.computerworld.com/article/2469616/business-intelligence/business-intelligence-79661-how-to-create-an-automatically-updating-spreadsheet。 HTML
And Google Developer doc: https://developers.google.com/apps-script/guides/services/external?hl=en
和Google Developer doc:https://developers.google.com/apps-script/guides/services/external?hl = en
#1
0
There's importxml function in Google sheet to import xml data and you can also parse the data. It's fairly complicated. (more doc on importxml https://support.google.com/docs/answer/3093342)
Google表格中有importxml函数来导入xml数据,您也可以解析数据。这很复杂。 (更多doc on importxml https://support.google.com/docs/answer/3093342)
Another alternative is to use Script Editor (Select Tools -> Script editor). Essentially, you write your own script (Google App script, similar to JavaScript) to fetch and parse the data (JSON, etc).
另一种方法是使用脚本编辑器(选择工具 - >脚本编辑器)。基本上,您编写自己的脚本(Google App脚本,类似于JavaScript)来获取和解析数据(JSON等)。
Sometime, it's necessary to create a custom script if the dataset is complicated. But, some other time, importxml will just do.
有时,如果数据集很复杂,则需要创建自定义脚本。但是,在其他时候,importxml将会这样做。
This is a good start (importxml or Script Editor): http://www.computerworld.com/article/2469616/business-intelligence/business-intelligence-79661-how-to-create-an-automatically-updating-spreadsheet.html
这是一个好的开始(importxml或脚本编辑器):http://www.computerworld.com/article/2469616/business-intelligence/business-intelligence-79661-how-to-create-an-automatically-updating-spreadsheet。 HTML
And Google Developer doc: https://developers.google.com/apps-script/guides/services/external?hl=en
和Google Developer doc:https://developers.google.com/apps-script/guides/services/external?hl = en