EuSpRIG offers Risk Managers the world's only independent, authoritative & comprehensive web based information describing the current state of the art in Spreadsheet Risk Management.
EditGrid APIs allows programmatic access of EditGrid spreadsheets and services. It consists of Web API and Grid API.
* Web API is an API for controlling and manipulating the data in EditGrid. It supports two modes of operations: REST and SOAP, which means you can adopt the API very easily no matter you're using scripting languages like PHP and Perl, or more heavy duty platforms like Java and .NET.
* Grid API is a JavaScript-based API. It allows you to instantiate EditGrid's grid as a JavaScript object and add it to your web application. By doing so, you can wire your code with the grid, customize its functionality, and connect your application logic with it in great flexibility.
Besides the APIs, a lot of EditGrid features are developed with developers in mind, we support:
* JSONP Pure JavaScript approach to load spreadsheet data to your website without writing a single line of backend code.
* My Data Format Transform the spreadsheet XML export to any format through your custom stylesheet.
* Permalinks Allow you to retrieve data or access to export format right in the URL.
Es gibt sie noch, die einsamen Cowboys, die auf ihrem täglichen Excel-Ritt autonom und unabhängig ihre Zahlenherde betreuen. Immer wieder muss einer von ihnen seine Herde abgeben – weil sie zu groß geworden ist.
Use Google Spreadsheets API to create a database in the cloud
Mr. Jeffrey W Scudder (Google)
30min Intermediate
case study, cloud computing, google spreadsheets, online databse, web, web services
I'll show you how to create a Python module which wraps the Google Spreadsheets Data API web service in an interface so that it looks like a local database. Using this tool, your application can run anywhere with Internet connectivity and users will be able to take their data with them. The benefit of using Google Spreadsheets for a back-end is that it provides a simple UI which is easy for non programmers to interact with. The cost of provisioning and running a Spreadsheets based database is zero from the perspective of an application developer. This example module provides a toolkit which simplifies interactions with the Google Spreadsheets API for a specific use case: using a spreadsheet like a remote database.
F. Hermans, M. Pinzger, and A. van Deursen. (2011)cite arxiv:1111.6895Comment: 9 Pages, 5 Colour Figures; Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2011 ISBN 978-0-9566256-9-4.