Sheetster

Extentech Inc.
Developer(s) Extentech, Inc.
Stable release
Sheetster Version 1.4 / October 27, 2009 (2009-10-27)
Preview release
1.0 / January 27, 2009 (2009-01-27)
Written in Java, JSP and JavaScript
Operating system Cross-platform
Type Spreadsheet
License Professional Edition is commercial / proprietary, Community Edition is Apache v2
Website www.sheetster.com

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.[1]

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

Sheetster runs on the ExtenXLS Java (programming language) Spreadsheet SDK and includes:[3]

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[4]

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:[5]

Usage

Sheetster Open Source Spreadsheet
A Sheetster Spreadsheet

Most common usages of sheetster:

Storage

Sheetster can be stored in any database or file system of choice, such as:

Sheetster Server Defined
Sheetster Server Defined

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:

  1. Advanced server-based spreadsheet automation and functionality
  2. Alfresco ECM
  3. A REST API with JSON/XML/HTML/CSV/ and XLS output
  4. Sheetster Web Spreadsheet (source included)
  5. Built-in secure content management system
  6. ExtenXLS Java Spreadsheet SDK
  7. Customizable Java Swing administration GUI with Object-Relational Mapper and Query Builder

Integration guide

Sheetster is available for download at Extentech.com and Sourceforge.

Notes

  1. ↑ Shrivastava, Anshu (October 15, 2009). "Extentech and Alfresco Intro Integrated Open Source Web Spreadsheet Solution". TMCnet. Retrieved 2009-10-27.
  2. ↑ "Sheetster Features". Retrieved January 8, 2010.
  3. ↑ "Sheetster Web Spreadsheet". Retrieved 2009-10-27.
  4. ↑ Java News Desk (April 4, 2007). "Extentech Announces Release of Sheetster". Sys-Con. Retrieved 2009-10-27.
  5. ↑ Mitra, Sramana (March 9, 2009). "Ventana Research in Deal Radar 2009: Extentech Article Deal Radar 2009: Extentech". Ventana Research. Retrieved 2009-10-27.

References

This article is issued from Wikipedia - version of the 10/28/2014. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.