Sheetster


title: "Sheetster" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["free-spreadsheet-software", "online-spreadsheets"] topic_path: "general/free-spreadsheet-software" source: "https://en.wikipedia.org/wiki/Sheetster" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0

| name = Extentech Inc. | logo = [[File:Sheetster logo.png|Sheetster Logo]] | screenshot = Sheetster screenshot.png | screenshot size = 250px | developer = Extentech, Inc. | latest_release_version = Sheetster Version 1.4 | latest_release_date = | latest_preview_version = 1.0 | latest_preview_date = | operating_system = Cross-platform | programming language = Java, JSP and JavaScript | genre = Spreadsheet | license = Professional Edition is commercial / proprietary, Community Edition is Apache v2 | website = **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 (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 Java (programming language) Spreadsheet SDK and includes: ::data[format=table]

Sheetster Web SpreadsheetExtenXLS Java Spreadsheet SDKCellbinder Automation APISpreadsheet Automation Server
Source Included/GPLCustomizable Java Swing GUIREST API JSON/XML/HTML/CSV/XLS outputObject-Relational Mapper and Query Builder
Document chatNamed rangesSecure content management systemEmbeddable live data charts
Macros, forms, and gadgets for web 2.0 database applicationsExcel 2007 compatibilityData Mapping APICollaboration, 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 Transform
  • CSV

Usage

::figure[src="https://upload.wikimedia.org/wikipedia/commons/7/74/Sheester_screenshot_megacomm.jpeg" caption="A Sheetster Spreadsheet" alt="Sheetster Open Source Spreadsheet"] ::

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 ::figure[src="https://upload.wikimedia.org/wikipedia/commons/6/6c/Sheetster_defined.png" caption="Sheetster Server Defined" alt="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

References

References

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

::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::

free-spreadsheet-softwareonline-spreadsheets