You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2006/11/09 19:49:19 UTC
DO NOT REPLY [Bug 40285] - CellIterator Skips First Column
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 ssb_jakarta@360works.com 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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/