Reading the excel file

[sunitha reghu]

I am using hssf to read an excel which users uploading to a servlet.
The problem is that it can not read the SSN . So i made ssn as text. But i already have name as text. I am geteting ssn and anem as text. My que how to take ssn out frm that.
I pasting the portion of the code.

for(int r=0;r< rows; r++)
        {
        Vector currentRow= new Vector();
        //out.println(" PRINTING Rows<br>"+r);
        HSSFRow row =sheet.getRow(r);
        
        int cells =row.getPhysicalNumberOfCells();
        out.println("Number of physical cells <br>"+cells);
        for(short c=0;c<cells;c++)
        {
        HSSFCell cell=row.getCell(c);
        //out.println("cell value"+c);

if(cell.getCellType()==HSSFCell.CELL_TYPE_STRING)
{
out.println("The Name of the Employee"+cell.getStringCellValue());
 }
else if(cell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC)
{
out.println("The Gross wage this quarter"+cell.getNumericCellValue());
}  

The name of the employee is coming up with ssn and the name.
Can anyone help me??
[ November 17, 2003: Message edited by: sunitha raghu ]

[Jeanne Boyarsky]

Are you saying that SSN and name are in the same cell? If so, you would get the whole cell as text and parse it.

[sunitha reghu]

No ssn and name are in diff cell.
so both are getting are string values.
i solved that using regular expression.
but if some enters ssn with hyphen then it will be problem
then i will get that in name field. so have to find some way for that.

Originally posted by Jeanne Boyarsky:
Are you saying that SSN and name are in the same cell? If so, you would get the whole cell as text and parse it.