Spreadsheet

Spreadsheet viewer

View larger

Close

The widget shows a spreadsheet - either from XLS file or by setting the cell contents programmatically.

This version is very limited and should be considered to be "pre-alpha". Try out the demo to see if it would be useful for you. I mainly built it for an upcoming presentation.

SpreadsheetView class should be also usable in GWT without Vaadin Framework, but then you must implement SpreadsheetModel by yourself.

Required dependencies: • Apache POI 3.8 - http://poi.apache.org/ • Apache Commons Codec 1.5 - Required by POI - http://commons.apache.org/codec/

This is a "pre-alpha" quality release with severe limitations: • All columns and rows have fixed sizes • No cell styling is supported • No merged cells are supported • Performance for larger spreadsheets is really bad • Only one spreadsheet widget is supported on screen at once

Sample code

Spreadsheet spreadsheet1 = new Spreadsheet();
spreadsheet1.readXLS(new FileInputStream("excel-sheet.xls"));

Spreadsheet spreadsheet2 = new Spreadsheet();
spreadsheet2.setRows(100);
spreadsheet2.setCols(10);
spreadsheet2.setCellHtml(1, 1, "Hello <b>World!</b>");
spreadsheet2.setHeight("200px");
spreadsheet2.setWidth("200px");
vl.addComponent(spreadsheet2);

Links

• Author Homepage
• Online Demo
• Issue Tracker
• Source Code

Compatibility