Spreadsheet
Spreadsheet viewer
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
Compatibility
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