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]
