Reading Cell value as a String regardless of the cell type (HSSF)

[Ashika Umanga]

hi guys,

I'm new to POI and what i want to do is read the String value of a Cell 
directly without considering about the cell type.
eg: Lets say my Excel file is something like following.
______________________
|  Start Date | Index | Name |
-----------------------------
|2001/01/1  | 01        |umanga|
------------------------------

So I am getting the cells as follow.
HSSFCell cellDate=row.getCell((short)1);
HSSFCell cellIndex=row.getCell((short)2);
HSSFCell cellName=row.getCell((short)3);

so now I want to get the String value '2001/01/01' from cellDate ,not 
the Date type.
and get the string value '01' from cellIndex and so on...

Actually in my application ,I am reading through cells in a loop and 
want to get the String value directly..

Any idea?

thanks in advance

umanga



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]