Directory

← Back

Spreadsheet

Spreadsheet viewer

Author

Contributors

Rating

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);

Compatibility

(Loading compatibility data...)

Was this helpful? Need more help?
Leave a comment or a question below. You can also join the chat on Discord or ask questions on StackOverflow.

Version

Updated to Vaadin 7.0.0.beta11

Released
2013-01-12
Maturity
EXPERIMENTAL
License
Apache License 2.0

Compatibility

Framework
Vaadin 7.0+
Browser
Firefox
Safari
Google Chrome
Online