Sheetster is a

GPL The GNU General Public Licenses (GNU GPL or simply GPL) are a series of widely used free software licenses, or ''copyleft'' licenses, that guarantee end users the freedom to run, study, share, or modify the software. The GPL was the first c ...

open-source Open source is source code that is made freely available for possible modification and redistribution. Products include permission to use and view the source code, design documents, or content of the product. The open source model is a decentrali ...

Web

Spreadsheet A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in c ...

and a

Java Java is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea (a part of Pacific Ocean) to the north. With a population of 156.9 million people (including Madura) in mid 2024, proje ...

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 system A document management system (DMS) is usually a computerized system used to store, share, track and manage files or documents. Some systems include history tracking where a log of the various versions created and modified by different users is r ...

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 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. Written entirely in the Java programming languag ...

Java (programming language) Java is a High-level programming language, high-level, General-purpose programming language, general-purpose, Memory safety, memory-safe, object-oriented programming, object-oriented programming language. It is intended to let programmers '' ...

Spreadsheet SDK and includes: 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 (Extensible Stylesheet Language Transformations) is a language originally designed for transforming XML documents into other XML documents, or other formats such as HTML for web pages, plain text, or XSL Formatting Objects. These formats c ...

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 Simple Storage Service (S3) is a service offered by Amazon Web Services (AWS) that provides object storage through a web service interface. Amazon S3 uses the same scalable storage infrastructure that Amazon.com uses to run its e-commerc ...

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
Alfresco ECM
# A REST API with JSON/XML/HTML/CSV/ and XLS output # Sheetster Web Spreadsheet (source included) # Built-in secure content management system # ExtenXLS Java Spreadsheet SDK # Customizable Java Swing administration GUI with Object-Relational Mapper and Query Builder
Integration guide
Sheetster is available for download a
Extentech.com
an
Sourceforge

Notes

References

''Sheetster Open Source'', anonymous author

''how-to-open-and-edit-excel-2007-xlsx-file-online'',October 19, 2009, Walsh, Ivan

''Sheetster: Web based spreadsheets'',August 23, 2009, White, Peter

External links

Extentech
*{{cite news, url=http://www.prweb.com/releases/2009/10/prweb3033394.htm, archive-url=https://web.archive.org/web/20091030141615/http://www.prweb.com/releases/2009/10/prweb3033394.htm, url-status=dead, archive-date=October 30, 2009, title=Extentech and Alfresco Partner to Deliver a Powerful Open Source Web Spreadsheet , date= October 14, 2009 , work=Press release, accessdate=2009-10-27
Sourceforge
Free spreadsheet software Online spreadsheets