Sheetster is a GPL Open Source

Open source

The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...

 Web Spreadsheet

Spreadsheet

A spreadsheet is a computer application that simulates a paper accounting worksheet. It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns. Each cell contains alphanumeric text, numeric values or formulas...

 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 (BIFF8 and XLSX Spreadsheets)
• 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 runs on the ExtenXLS

ExtenXLS

ExtenXLS is a Java Excel Reporting Toolkit developed by Extentech. It is a Reporting API that allows for the reading in, modifying and creation of spreadsheet-based reports from Java applications....

 Java (programming language)

Java (programming language)

Java is a programming language originally developed by James Gosling at Sun Microsystems and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities...

 Spreadsheet SDK and includes:

Sheetster Web Spreadsheet	ExtenXLS Java Spreadsheet SDK	Cellbinder Automation API	Spreadsheet Automation Server
Source Included/GPL	Customizable Java Swing GUI Gui Gui or guee is a generic term to refer to grilled dishes in Korean cuisine. These most commonly have meat or fish as their primary ingredient, but may in some cases also comprise grilled vegetables or other vegetarian ingredients. The term derives from the verb, "gupda" in Korean, which literally...	REST API JSON JSON JSON , or JavaScript Object Notation, is a lightweight text-based open standard designed for human-readable data interchange. It is derived from the JavaScript scripting language for representing simple data structures and associative arrays, called objects... /XML XML Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards.... /HTML HTML HyperText Markup Language is the predominant markup language for web pages. HTML elements are the basic building-blocks of webpages.... /CSV Comma-separated values A comma-separated values file stores tabular data in plain-text form. As a result, such a file is easily human-readable .... /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 Database A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...  applications	Excel Microsoft Excel Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications...  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 (.xlsx/.ooxml)
• Excel Binary Spreadsheet (.xls)CSV
• ExtenXLS XML Doc (.exml)
• Archive All Spreadsheets (.zip)
• XSLT
  XSLT
  XSLT is a declarative, XML-based language used for the transformation of XML documents. The original document is not changed; rather, a new document is created based on the content of an existing one. The new document may be serialized by the processor in standard XML syntax or in another format,...
  
   Transform
• CSV

Usage

Most common usages of sheetster:

• As a hosted web spreadsheet: www.sheetster.com
• 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

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

• SaaS online access
• Local host server for offline access
• Behind the firewall
• On Amazon S3
  Amazon S3
  Amazon S3 is an online storage web service offered by Amazon Web Services. Amazon S3 provides storage through web services interfaces...
  
  

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. An 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.

External links

• Extentech
• Sourceforge