Hi!
I have alot of Excel documents that I want to present using Wicket and POI.
The problem is that I don't know how to get started using this.
Here is a simple loop on how to extract cells.
InputStream inp = new FileInputStream("workbook.xls");
HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inp));
HSSFSheet sheet = wb.getSheetAt(0);
for (Iterator rit = sheet.rowIterator(); rit.hasNext(); ) {
row = (HSSFRow)rit.next();
for (Iterator cit = row.cellIterator(); cit.hasNext(); ) {
HSSFCell cell = (HSSFCell)cit.next();
if( cell.getCellType() == HSSFCell.CELL_TYPE_STRING ){
System.out.println( cell.getRichStringCellValue().getString() );
}
}
}
--
View this message in context:
http://www.nabble.com/POI-HSSFSheet-to-ListView-tp19739001p19739001.html
Sent from the Wicket - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
