使用Google电子表格作为应用的数据库

时间:2020-12-23 09:47:44

I want to use Google spreadsheets to store data online so multiple people can enter and maintain data, then publish or export (csv, xls, ods) the sheet for their application. What is the easiest way to process the sheet? If the data can be accessed as a link the updates could be immediately reflected in the client's app.

我想使用Google电子表格在线存储数据,以便多人可以输入和维护数据,然后为他们的应用程序发布或导出(csv,xls,ods)工作表。处理工作表最简单的方法是什么?如果数据可以作为链接访问,则更新可以立即反映在客户端的应用程序中。

3 个解决方案

#1


3  

This article Data Scraping Wikipedia with Google Spreadsheets discusses using Google spreadsheets as an application platform.

本文使用Google Spreadsheets进行Data Scraping Wikipedia讨论使用Google电子表格作为应用程序平台。

It already has features that allow you to share the spreadsheet with multiple editors, as well as the ability to define forms that you can invite people to fill out who's results will be entered into the spreadsheet as a row.

它已经具有允许您与多个编辑者共享电子表格的功能,以及定义表单的功能,您可以邀请人们填写哪些结果将作为一行输入到电子表格中。

#2


1  

Just in case its still vaguely of interest 5 months later, there is a SQL-like wrapper language for Google Spreadsheets at:

为了防止它在5个月之后仍然含糊不清,Google Spreadsheets有一种类似SQL的包装语言:

http://gqlx.twyst.co.za

Its very much an alpha release - but maybe its of some use or perhaps the code could give you some ideas.

它是一个alpha版本 - 但也许它有一些用处,或者代码可能会给你一些想法。

#3


0  

I think if I am clear on your requirements, you want to store your data online in a Google Spreadsheet where multiple people can access that right? Then you want an app to use that data? Correct me if I am wrong.

我想如果我明白您的要求,您希望将数据在线存储在Google电子表格中,多个人可以访问该数据吗?那么你想要一个应用程序使用该数据?如果我错了,请纠正我。

It is possible to have Google spreadsheet as a database and the client app can directly access that data through APIs - spreadsheet APIs . If you want a simple link where people can go and update - you can also have a web app using google apps scripting. very simple to use and would solve your purpose too , why to export your data to ods, xls, csv, make your app directly over Google Spreadsheet. Would be maintainable too.

可以将Google电子表格作为数据库,客户端应用程序可以通过API(电子表格API)直接访问该数据。如果您想要一个人们可以去更新的简单链接 - 您还可以使用谷歌应用程序脚本创建一个Web应用程序。使用非常简单,也可以解决您的目的,为什么要将数据导出到ods,xls,csv,直接通过Google电子表格制作您的应用。也可以维护。

#1


3  

This article Data Scraping Wikipedia with Google Spreadsheets discusses using Google spreadsheets as an application platform.

本文使用Google Spreadsheets进行Data Scraping Wikipedia讨论使用Google电子表格作为应用程序平台。

It already has features that allow you to share the spreadsheet with multiple editors, as well as the ability to define forms that you can invite people to fill out who's results will be entered into the spreadsheet as a row.

它已经具有允许您与多个编辑者共享电子表格的功能,以及定义表单的功能,您可以邀请人们填写哪些结果将作为一行输入到电子表格中。

#2


1  

Just in case its still vaguely of interest 5 months later, there is a SQL-like wrapper language for Google Spreadsheets at:

为了防止它在5个月之后仍然含糊不清,Google Spreadsheets有一种类似SQL的包装语言:

http://gqlx.twyst.co.za

Its very much an alpha release - but maybe its of some use or perhaps the code could give you some ideas.

它是一个alpha版本 - 但也许它有一些用处,或者代码可能会给你一些想法。

#3


0  

I think if I am clear on your requirements, you want to store your data online in a Google Spreadsheet where multiple people can access that right? Then you want an app to use that data? Correct me if I am wrong.

我想如果我明白您的要求,您希望将数据在线存储在Google电子表格中,多个人可以访问该数据吗?那么你想要一个应用程序使用该数据?如果我错了,请纠正我。

It is possible to have Google spreadsheet as a database and the client app can directly access that data through APIs - spreadsheet APIs . If you want a simple link where people can go and update - you can also have a web app using google apps scripting. very simple to use and would solve your purpose too , why to export your data to ods, xls, csv, make your app directly over Google Spreadsheet. Would be maintainable too.

可以将Google电子表格作为数据库,客户端应用程序可以通过API(电子表格API)直接访问该数据。如果您想要一个人们可以去更新的简单链接 - 您还可以使用谷歌应用程序脚本创建一个Web应用程序。使用非常简单,也可以解决您的目的,为什么要将数据导出到ods,xls,csv,直接通过Google电子表格制作您的应用。也可以维护。