HTML5 Spreadsheet Editor: Web Application for Creating & Editing MS Excel Files

HTML5 Spreadsheet Editor is a web application that loads a Microsoft Excel file, and lets you view and edit Excel files it in a web browser. The initial version is limited in its functionality. Aspose team will release newer versions from time to time to make a complete replacement of desktop software. The best part is – it is open source. Let’s take a look at the editor. We had defined some constraints for this project, which influenced the technology we chose for the development. The application must not be dependent on plugins and must not require end-users to install extra software. So we had to stick to HTML and Ajax. Because it’s a popular language, I used Java server-side. The next important requirement was server-to-browser end-to-end data interoperability. we didn’t want to introduce a new integration layer between JavaScript on the browser-side and Java-based business-logic on the server. There are some good frameworks out there like Google Web Toolkit (GWT), Spring Framework, JavaServer Faces (JSF) and some others. JSF is a component-based web application framework. It is a part of Java standards. A wide range of third-party components are available for JSF. These components can be plugged into any JSF application. The JSF managed beans technology is yet another technology to split your whole project design into independent self-contained components. Objects are created, serialized, de-serialized, injected, managed and destroyed by the application server. HTML5 Spreadsheet Editor is an in-browser viewer and editor for Excel files. It supports XLS, XLSX, XLSM, XLSB, XLTX, SpreadsheetML, CSV, ODS. The file can be opened by specifying it in URL. You can embed HTML5 Spreadsheet Editor in any website of your choice using IFRAME. HTML5 Spreadsheet Editor requires any standard compliant Java application server that supports CDI. we have tested it on Glassfish 4.0. Just download the source code and build using Maven. It supports features like

·         Opening a Workbook

·         Viewing a Workbook

·         Working with Sheets

·         Editing Cells

·         Working with Rows

And many more new features still to come in the near future.

More About Aspose

Aspose offers a powerful set of file management components with which developers can create applications which can open, edit, create and save some of the most popular business file formats. Supported formats include Word documents, Excel spreadsheets, PowerPoint presentations, PDF documents, and Microsoft Project files. Tools allow developers to perform OCR, work with images, create and read barcodes and perform many other document conversion and management tasks. Aspose produce components for .NET, Java and SharePoint, as well as rendering extensions for SQL Server Reporting Services and JasperReports exporters.

- Aspose for Java components: 

-  Download the complete source code