Hi Kalkunda,
Dates in Excel are stored as numbers. Here's the text from the Excel Help:
How Microsoft Excel stores dates and times
Microsoft Excel stores dates as sequential numbers known as serial values.
Excel stores times as decimal fractions because time is considered a portion
of a day. Dates and times are values and, therefore, can be added,
subtracted, and included in other calculations. For example, to determine
the difference between two dates, you can subtract one date from the other.
You can view a date as a serial value and a time as a decimal fraction by
changing the format of the cell that contains the date or time to General
format.
Excel supports two date systems: the 1900 and 1904 date systems. The default
date system for Microsoft Excel for Windows is 1900. To change to the 1904
date system, click Options on the Tools menu, click the Calculation tab, and
then select the 1904 date system check box.
The following table shows the first date and the last date for each date
system and the serial value associated with each date.
Date system First date Last
date
1900 January 1, 1900 (serial value 1)
December 31, 9999 (serial value
2958465)
1904 January 2, 1904 (serial value 1)
December 31, 9999 (serial value
2957003)
hth,
Peter Dow
Dow Software Services, Inc.
www.dowsoftware.com
909 793-9050 voice
909 793-4480 fax
> -----Original Message-----
> From: Kalkunda, Venkat [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 04, 2005 12:18 PM
> To: POI Users List
> Subject: RE: HSSFCell object.
>
>
> Thank you.
>
> I tried using that logic but it gives me some junk value if the
> cell contains only a date( in the form 8/3/2005 or any other form)
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.1/64 - Release Date: 8/4/2005
---------------------------------------------------------------------
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/
