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.
Showcases
| Blackjack | OnSheet | |
|---|---|---|
 |
 |
|
| Using Grid API, you can write javascript program to manipulate the spreadsheet data. Buttons can be created for user to invoke your javascript procedure. In this example, you've got a blackjack game! Feel free to browser the source code in your browser. | OnSheet is EditGrid's Japanese version. It is run by Infoteria, EditGrid's partner in Japan. OnSheet demonstrats EditGrid's customisation and localisation capabilities. If you want to run your own EditGrid, contact us. | |
| Box.net | Xignite | |
 |
 |
|
| EditGrid's Remote Workbook API is an easy way to integrate EditGrid's powerful web-based spreadsheet editing UI with your document service. Box.net's users can open and edit spreadsheets stored in Box.net with EditGrid. | Xignite provides financial web services. Through Grid API, EditGrid provides an efficient mashup platform to query Xignite data and display the custom reports. This Xignite report mashup also demonstrates the custom menu items create by Grid API. | |
| PA School District Data | Tradingcomps.com | |
 |
 |
|
| Making use of EditGrid's JSON export, EditGrid spreasdheet is powering the backend data of these interactive maps and timelines, created by EditGrid user David Cohen. Simile Exhibit is used in dynamically presenting the data. | Tradingcomps.com tries to automate the comps model building of financial analysts and make it collaborative. It is create by EditGrid user Dave Schmierer. It made extensive use of EditGrid Web API to closely integrate EditGrid spreadsheet to its site - the most comprehensive integration we've seen so far. Dave is now part of the EditGrid Team. | |
| Central Desktop | Atlassian Confluence | |
 |
 |
|
| EditGrid serves Central Desktop's online spreadsheet feature. In the integration, EditGrid hosts all the online spreadsheet securely for Central Desktop, and Central Desktop real-time permission the file to its user according to its own permissioning system using Web API. | EditGrid has a plugin for Confluence, one of the most popular enterprise wiki. EditGrid APIs are used to enable real-time collaboration for Excel file hosted in Confluence wiki. It also became the default plugin for all hosted customers of Confluence. | |
| Kiva.org | StrikeIron | |
 |
 |
|
| Users of Kiva.org (a Web2.0 Grameen Bank) use EditGrid to manipulate and massage data exported by Kiva.org, then convert it to .kml and .ical file with EditGrid's My Data Format feature. Simile Exhibit is also used to create interactive map, list and timeline. | StrikeIron provides "Data as a Service". Using EditGrid Grid API, users can create mashup easily. In this example, cell changes are listened using Grid API. On changes, data is fetch from StrikeIron's web services with reports and charts created by EditGrid in real time. |