In your code retrieve the value like this: String myString = xlsrow.getCell(collidx).getRichStringCellValue().getString();
-----Original Message----- From: FELIX BERIG [mailto:[email protected]] Sent: Thursday, September 13, 2012 3:23 PM To: [email protected] Cc: [email protected] Subject: RE: POI 3.8 Invalid cell type The cell format in Excel file defined as Text. I am just checking the cell type in the code and it shows as numeric On Thu, Sep 13, 2012 at 4:11 PM, Gandhi, Kunal - External wrote: > Is the cell format in the excel file defined as format text or are you > setting the HSSFCell type as text using the POI API and trying to > retrieve numerical from excel? > > -----Original Message----- > From: FELIX BERIG [mailto:[email protected]] > Sent: Thursday, September 13, 2012 3:07 PM > To: [email protected] > Cc: [email protected]; [email protected] > Subject: Re: POI 3.8 Invalid cell type > > Hi guys, > > Thanks for the reply. My problem is that cell is defined as text. For > some reason POI considers it as a numeric and adds '.0' to the text of > the cell. If cell is Numeric I can only retrieve context of the cell > by using xlsRow.getCell(colIdx).getNumericCellValue(). I have a > mapping in my application which maps columns in the xls file to the > database fileds. > Let's say DB field defined as varchar(5). File contains 12345. POI > adds '.0' the cell value and I am trying to insert '12345.0' into > varchar(5). > > So my question is why POI considers text cell with number in it as > numeric(cell format defined as TEXT) > > Thank you, > Feliks. > > > > On Thu, Sep 13, 2012 at 3:49 PM, [email protected] wrote: > >> What is your question exactly? Is it that you want the value >> returned >> as a string with no decimals or are you encountering an error >> somewhere? >> >> >> >> FELIX BERIG <[email protected]> wrote on 2012-09-13 01:46:23 PM: >> >>> FELIX BERIG <[email protected]> 2012-09-13 01:46 PM >>> >>> Please respond to >>> "POI Users List" <[email protected]> >>> >>> To >>> >>> [email protected], >>> cc >>> >>> 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] >>> > > --------------------------------------------------------------------- > 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. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] --------------------------------------------------------------------- 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.
