Sheetster
Sheetster is a GPL open-source Web Spreadsheet and a Java Application Server created by Extentech Inc. The product was created for the enterprise and small and medium-sized businesses as an Open Source alternative to closed document management systems.
History
Built by Extentech Inc, a developer of Java spreadsheet and development tools, Sheetster BETA was made available to the public on June 8, 2007.Features
- Output to PDF
- Total Compatibility with Excel 1997–2007 Files
- Embed YouTube videos in your Spreadsheets
- Publish Spreadsheets as RSS with R3S
- Instant Web2.0 Apps with Forms, Charts, and Macros
- Role-based security and sharing
| Sheetster Web Spreadsheet | ExtenXLS Java Spreadsheet SDK | Cellbinder Automation API | Spreadsheet Automation Server |
| Source Included/GPL | Customizable Java Swing GUI | REST API JSON/XML/HTML/CSV/XLS output | Object-Relational Mapper and Query Builder |
| Document chat | Named ranges | Secure content management system | Embeddable live data charts |
| Macros, forms, and gadgets for web 2.0 database applications | Excel 2007 compatibility | Data Mapping API | Collaboration, versioning, and access control |
The Sheetster administration console allows for the design of relational data objects using a visual query designer and object-relational mapper. The RESTful API accepts data from a variety of sources, and outputs data-mapped spreadsheet objects in a variety of formats including JSON, XML, and as Excel-compatible XLS.
Sheetster can be automated with macros and automatic data entry forms created from Excel cell ranges. Data Objects can be mapped to spreadsheet templates and output in a variety of formats:
- Excel 2007 Spreadsheet
- Excel Binary Spreadsheet CSV
- ExtenXLS XML Doc
- Archive All Spreadsheets
- XSLT Transform
- CSV
Usage
- As a hosted web spreadsheet:
- As a web service embedded within other applications
- Spreadsheet calculations—used as secure formula engines within Web 2.0 and traditional client-server web applications.
Storage
- SaaS online access
- Local host server for offline access
- Behind the firewall
- On Amazon S3
Integration
Integration is achieved through the RESTful API which allows for publishing of data-mapped spreadsheet cells as web services. Sheetster provides integrated support for:- Advanced server-based spreadsheet automation and functionality
- A REST API with JSON/XML/HTML/CSV/ and XLS output
- Sheetster Web Spreadsheet
- Built-in secure content management system
- ExtenXLS Java Spreadsheet SDK
- Customizable Java Swing administration GUI with Object-Relational Mapper and Query Builder