Hi Jaypee. The internal representation is 38473. This is the sequence number of the day starting at 1.1.1900 (+/-1). Look at threads having "date" in the subject. There such things are intensively discussed.
So you want to achieve the same external representation and thus need data formatting which is "normal" Java. So look at the J2SE documentation of SUN - most probably in the classes java.util.Date or String or similar classes. The setting and getting data formats of a cell in POI is just used for forcing Excel to show the data later as wanted. Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: news [mailto:[EMAIL PROTECTED] Im Auftrag von jaypee Gesendet: Freitag, 15. Juli 2005 09:20 An: [email protected] Betreff: How to read data as it appears in the excel sheet......... Hi Everyone, I am trying to read(just read) the data from an excel sheet column. The problem is, that particular column is formatted as "d/m/yy;@". When i read a cell in that column, it returns the alias value(eg., 38473) but not the actual value(eg., 5/1/05). How can i read the actual value(ie., 5/1/05) which is appears in that cell? I am using Version : POI api 2.5.1. Thanks in advance, Jaypee --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
