I've deleted the text in the cells then saved. Then I re-entered the text with a ' (single quote) and saved. That seemed to fix it but still have the question...
Why would it recognize the cell as being text on some and numeric on others when I have formatted the fields as "text"?? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 7:17 PM To: POI Developers List Subject: Re: Text field read in as numeric sometimes and text others times My standard response would be to try and put ' (single quote) in front to force it to be a string, but since you've tried that, i must admit i am stumped :) Can you send an example sheet over? Better to attach it to bugzilla to ensure it wont get lost. I could have a play around with it. Regards - Avik Quoting Tracey <[EMAIL PROTECTED]>: > I have a spreadsheet that contains cells with employee's name and SSN. I am > > reading this spreadsheet into a Vector and then populating a MySQL database > with the data by enumeration through the Vector and doing a toString() on the > > element. The problem that I'm having is that some of the SSN cells are being > > read in as text and others as numeric. > > INPUT DATA: > Anderson Patricia 443219876 > Andrews Randy 442615243 > Barker Marshal 123456789 > Mathews Mark 123443212 > Thompson Lucille 987654323 > > > JAVA CLASS CODE SNIPPET: > FileInputStream in = new FileInputStream( filename ); > try > { > POIFSFileSystem fs = new POIFSFileSystem( in ); > HSSFWorkbook wb = new HSSFWorkbook( fs ); > HSSFSheet sheet = wb.getSheetAt( 0 ); > Iterator it = sheet.rowIterator(); > HSSFCellStyle cellStyle = wb.createCellStyle(); > cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat( "text" )); > > int rows = sheet.getPhysicalNumberOfRows(); > for ( int r = 9; r < rows; r++ ) > { > Vector currentRow = new Vector(); > HSSFRow row = sheet.getRow( r ); > int cells = row.getPhysicalNumberOfCells(); > for ( short c = 0; c < cells; c++ ) > { > HSSFCell cell = row.getCell( c ); > cell.setCellStyle(cellStyle); > String s = new String(); > try > { > s = cell.getStringCellValue(); > } > catch (NumberFormatException ne) > { > s = "" + cell.getNumericCellValue(); > } > currentRow.addElement(s); > } > v.addElement(currentRow); > } > } > catch (Exception e) > { > System.out.println(e); > e.printStackTrace(); > return false; > } > ..... > > OUPUT IN DATABASE: > Anderson Patricia 443219876 > Andrews Randy 4.426152E (not read in as text) > Barker Marshal 123456789 > Mathews Mark 1.344321E (not read in as text) > Thompson Lucille 987654323 > > I have checked the cell Formatting in Excel to make sure that it says that it > > is Text. I've tried to put a ' in front of the numbers to indicate text. > I've > tried a custom format of "0". None of these make the cells read in > consistently as text. > > I need the SSNs to read in as Text. Please help. > Thanks. > Tracey > > > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
