poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 40285] - CellIterator Skips First Column
Date Thu, 09 Nov 2006 18:49:19 GMT
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/


Mime
View raw message