It would help if you post the line of code where the error is occurring. And also, what the actual error it is that is occurring. If the cell is value is numeric, don’t use a cell that is defined as text.
-----Original Message----- From: FELIX BERIG [mailto:[email protected]] Sent: Thursday, September 13, 2012 12:46 PM To: [email protected] Subject: POI 3.8 Invalid cell type Hi All. I recently upgraded to POI 3.8. I am having issue with cell type when trying to read xls file. The cell is defined as a text. But value in the cell is numeric(5678). When I validate the cell type I can see that it is Cell.CELL_TYPE_NUMERIC and the value in the cell is 5678.0 Here is the code I have: ... import org.apache.poi.ss.usermodel.Workbook; .... Workbook workbook = null; FileInputStream fileInputStream = new FileInputStream(fileName); if(fileExt.equals("xls"){ workbook = new HSSFWorkbook(fileInputStream); } if(fileExt.equals("xlsx"){ workbook = new XSSFWorkbook(fileInputStream); } sheet = workbook.getSheetAt(0); xlsRow = sheet.getRow(0); etc.... Am I doing something wrong? Thank you, Feliks. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] This communication, including any attachments, may contain information that is proprietary, privileged, confidential or legally exempt from disclosure. If you are not a named addressee, you are hereby notified that you are not authorized to read, print, retain a copy of or disseminate any portion of this communication without the consent of the sender and that doing so may be unlawful. If you have received this communication in error, please immediately notify the sender via return e-mail and delete it from your system.
