>On Tue, 12 Feb 2002 12:52:08 1100 "Glen Stampoultzis" <[EMAIL PROTECTED]> wrote. >I'm not sure about this one because in Excel this is no distinction between >numerics and dates. Try this. Type some dates into a sheet then format >them as numbers. Now type some numbers and format them as dates. Notice >the only difference is the formatting. To create a date cell type I would >have to fake it by looking at the styling of the record. I'm not really >sure this is a good idea. Andy? >
Ahh.. I think you're right. Perhaps just some util code (in a class somewhere) to take a format and a number and format them. >Glen Stampoultzis >[EMAIL PROTECTED] > 61 3 9753-6850 - 0402 835 458 (mob) >ICQ: 62722370 AIM: FubbleWobble > >----- Original Message ----- >From: "Thutika, Swamy" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, February 11, 2002 11:55 PM >Subject: RE: Can't read date cells > > >> While you are planning to add this to hssfcell , could it be possible to >> add another cell type date so that it is easier to find if a cell is of >> date type. >> >> thanks >> Swamy >> >> -----Original Message----- >> From: Glen Stampoultzis [mailto:[EMAIL PROTECTED]] >> Sent: Saturday, February 09, 2002 5:40 PM >> To: [EMAIL PROTECTED] >> Subject: Re: Can't read date cells >> >> >> Yes. I was thinking of doing that. The original patch came in that way >so >> I left it as is but really there's no reason why it shouldn't be changed >to >> something more obvious and convenient. >> >> -- Glen >> >> ----- Original Message ----- >> From: "Andrew C. Oliver" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Saturday, February 09, 2002 11:44 PM >> Subject: Re: Can't read date cells >> >> >> > should we maybe add that to HSSFCell.. meaning a function that calls >> > the date util... getValueAsDate() or something? >> > >> > -andy >> > >> > On Fri, 2002-02-08 at 21:11, Glen Stampoultzis wrote: >> > > Take a look at HSSFDateUtil. It will convert the numeric value to a >> valid >> > > date. >> > > >> > > Regards, >> > > >> > > Glen Stampoultzis >> > > [EMAIL PROTECTED] >> > > (03) 9753-6850 >> > > 0402 835 458 >> > > >> > > ----- Original Message ----- >> > > From: "Thutika, Swamy" <[EMAIL PROTECTED]> >> > > To: <[EMAIL PROTECTED]> >> > > Sent: Saturday, February 09, 2002 5:48 AM >> > > Subject: Can't read date cells >> > > >> > > >> > > > I am not able to read the cells with the date format. Is this not >> > > > implemented or is there a different way >> > > > of reading the date cells. >> > > > >> > > > I get the cell type as numeric for date cells. >> > > > >> > > > --Swamy >> > > >> > -- >> > www.superlinksoftware.com >> > www.sourceforge.net/projects/poi - port of Excel format to java >> > http://developer.java.sun.com/developer/bugParade/bugs/4487555.html >> > - fix java generics! >> > >> > >> > The avalanche has already started. It is too late for the pebbles to >> > vote. >> > -Ambassador Kosh >> > >
