DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=25769>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=25769 HSSFRow.getCell() returns null for cell with formula. ------- Additional Comments From [EMAIL PROTECTED] 2003-12-27 04:52 ------- I have uploaded an Excel 2000 attachment as test data. I'm only working with the "InputData" sheet. FileInputStream fileIn = new FileInputStream((File) mapfrom); // create a new org.apache.poi.poifs.filesystem.Filesystem POIFSFileSystem fs = new POIFSFileSystem(fileIn); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheet("InputData"); Iterator rowIterator = sheet.rowIterator(); while (rowIterator.hasNext()) { HSSFRow row = (HSSFRow) rowIterator.next(); HSSFCell cell = row.getCell(0); if (cell == null) { System.out.println("---> Cell null "); } } --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
