DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUGĀ· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=40285>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED ANDĀ· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40285 ------- Additional Comments From [EMAIL PROTECTED] 2006-11-09 10:49 ------- I've also experienced this behavior. Attaching a code snippet: private String extractExcel( InputStream stream ) throws IOException { HashSet set = new HashSet(); HSSFWorkbook workbook = new HSSFWorkbook(stream); int sheetCount = workbook.getNumberOfSheets(); int resultLength = 0; for( int i = 0 ; i < sheetCount ; i++ ) { //System.out.println( "Reading sheet #" + (i+1) ); HSSFSheet at = workbook.getSheetAt( i ); int rowCount = at.getPhysicalNumberOfRows(); for (int j = 0; i< rowCount; j++) { //System.out.println( "Reading row #" + (j+1) ); HSSFRow row = at.getRow( j ); if (row == null) break; for( Iterator iterator = row.cellIterator(); iterator.hasNext(); ) { HSSFCell cell = (HSSFCell)iterator.next(); if( cell.getCellType() == HSSFCell.CELL_TYPE_STRING ) { String string = cell.getRichStringCellValue().getString(); if( string != null && string.length() > 0 ) { if (set.add( string )) { resultLength += string.length(); resultLength++; } } } } } } StringBuffer result = new StringBuffer(resultLength); for( Iterator iterator = set.iterator(); iterator.hasNext(); ) { result.append( (String)iterator.next() ).append( ' '); } return result.toString(); } -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/