Download - Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management
![Page 1: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/1.jpg)
Alfresco + SheetsterAn Open Source Java solution for Web Spreadsheet
Editing and Management
Presented by:
![Page 2: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/2.jpg)
This session covers:Uploading an Excel spreadsheet to Alfresco Web Content
Management system
Open the Spreadsheet in the Sheetster editor from within the Alfresco WCM
Create actionable charts and graphics from existing content
Publish chart with live data to a web portal using JavaScript or a REST API call
Presented by:
![Page 3: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/3.jpg)
About Extentech Inc.Founded 1999Headquartered in San FranciscoCustomers include IBM, AT&T, JPMorgan, Nielsen Corp.Extentech Inc. is the developer of:
ExtenXLS Java Spreadsheet SDK – a leading Java spreadsheet component and class library
Sheetster Server – an innovative, open source web spreadsheet built on top of ExtenXLS
Presented by:
![Page 4: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/4.jpg)
IntroducingOpen Source Java SynergyOnline spreadsheet editing
peanut butter meets doc management chocolate
Perfect for:Statistical data visualizationBusiness Intelligence appsSpreadsheet web appsSharePoint / Excel alternative
Presented by:
![Page 5: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/5.jpg)
Sheetster Server Defined• Spreadsheet automation• Excel Compatible
Built on ExtenXLS Java Spreadsheet
SDK
• Spreadsheet web servicesOpen Source Web
Spreadsheet + Server
• Open source web spreadsheet front-end
All-Java server, AJAX / XHTML
front-end
• Total choice of deployment (premise, SaaS, cloud,P2P)
Built for Developers
• Extensible Java Server REST api with sample code and api docs
REST api + Plug-ins
Presented by:
![Page 6: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/6.jpg)
WCM + Inline Spreadsheet EditingRetains Control of your data
(vs. SaaS)Collaborative online editing
enables teamworkLowers development costs
and frees up staff
Presented by:
![Page 7: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/7.jpg)
Web Spreadsheet for DevelopersSpreadsheet Web Services
and REST apiForms and MacrosEmbeddable spreadsheet
charting components
Today’s example will demonstrate Embedding Sheetster Charts
Presented by:
![Page 8: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/8.jpg)
Benefits: Live Sheetster ChartsSheetster Charts:“Live” DataSVG + XHTML: No browser
plug-insEasily modified in
spreadsheet100% Excel-compatibleAccurate Business Graphics
Presented by:
![Page 9: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/9.jpg)
EXAMPLE: Benchmark Data ChartsProduct performance data:Always changingActionableCritical to customer
decision-makingCommunicates product
differentiation
Presented by:
![Page 10: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/10.jpg)
Our Benchmark Data SpreadsheetPerformance Data in XLS:Our example uses a basic
input data spreadsheet.This is a picture of that
spreadsheet in Excel.We will add our own
product data and a chart using Sheetster…
Presented by:
![Page 11: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/11.jpg)
Uploading Spreadsheet to Alfresco1. Log into Alfresco2. Browse to space3. Upload Files4. “Edit Spreadsheet”
Presented by:
![Page 12: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/12.jpg)
Creating Sheetster Charts1. Select Cell Range2. Click Chart Button3. Chart Dialog Appears
1. Edit Chart Name2. Select Chart Type3. Customize Ranges4. Serve
Presented by:
![Page 13: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/13.jpg)
Working With Sheetster Charts1. Edit Chart data2. Mouse-over bars3. View Chart in new tab4. Resize Chart5. View updated tab
Presented by:
![Page 14: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/14.jpg)
Embedding Sheetster Charts1. Copy Embed Code2. Paste web page HTML3. Customize HTML
Presented by:
![Page 15: Sheetster + Alfresco: An Open Source Java Solution for Web Spreadsheet Editing and Management](https://reader031.vdocuments.us/reader031/viewer/2022020717/548338e1b07959520c8b49d6/html5/thumbnails/15.jpg)
Next StepsTo get started, download your free copy of
Sheetster Server and the Sheetster + Alfresco Web Client Extensions
Free Sheetster Server Downloads:http://extentech.com/estore/download_center.jsp
Sheetster + Alfresco Integration Guide:http://
extentech.com/nimbledocs/4520/2009/September/15/sheetster_and_alfresco_wcm_integration
http://[email protected](415) 759-5292http://twitter.com/extentech Presented by: