Sheetster

Built by Extentech Inc, a developer of Java spreadsheet and development tools, Sheetster BETA was made available to the public on June 8, 2007.

• 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{{cite web|url=http://www.sheetster.com/ |title=Sheetster Features|accessdate=January 8, 2010}}

Sheetster runs on the ExtenXLS Java (programming language) Spreadsheet SDK and includes:{{cite web|url=http://sourceforge.net/projects/sheetster/ |title=Sheetster Web Spreadsheet|accessdate=2009-10-27}}

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:{{cite news|url=http://bx.businessweek.com/information-governance/view?url=http://www.sramanamitra.com/2009/03/09/deal-radar-2009-extentech/|archive-url=https://web.archive.org/web/20110723192208/http://bx.businessweek.com/information-governance/view?url=http:%2F%2Fwww.sramanamitra.com%2F2009%2F03%2F09%2Fdeal-radar-2009-extentech%2F|url-status=dead|archive-date=July 23, 2011|title=Ventana Research in Deal Radar 2009: Extentech Article Deal Radar 2009: Extentech |last=Mitra|first=Sramana|date=March 9, 2009|work=Ventana Research|accessdate=2009-10-27}}

• Excel 2007 Spreadsheet (.xlsx/.ooxml)
• Excel Binary Spreadsheet (.xls)CSV
• ExtenXLS XML Doc (.exml)
• Archive All Spreadsheets (.zip)
• XSLT Transform
• CSV

File:Sheester screenshot megacomm.jpeg

Most common usages of sheetster:

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

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

File:Sheetster defined.png

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. [http://www.alfresco.com/ 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

[http://extentech.com/uimodules/docs/docs_detail.jsp?showall=true&meme_id=2396 Integration guide]

Sheetster is available for download at [http://extentech.com/estore/product_detail.jsp?product_group_id=230&product_id=321 Extentech.com] and [http://sourceforge.net/projects/sheetster/ Sourceforge].

{{Reflist}}

• [http://ostatic.com/sheetster-open-source-web-spreadsheet Sheetster Open Source, anonymous author]
• [http://www.wareprise.com/2009/10/19/how-to-open-and-edit-excel-2007-xlsx-file-online/ how-to-open-and-edit-excel-2007-xlsx-file-online,October 19, 2009, Walsh, Ivan]
• [http://www.downloadsquad.com/2007/08/23/sheetster-web-based-spreadsheets/ Sheetster: Web based spreadsheets,August 23, 2009, White, Peter]

• [http://www.extentech.com/ 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}}
• [http://sourceforge.net/projects/sheetster/ Sourceforge]

Category:Free spreadsheet software

Category:Online spreadsheets