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]
