RE: Dates in POI Sql2Xls

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

Bob,

I've only ever used POI from Java but have you tried using an actual date data 
type to store the date? I know that storing dates works `cause I've done it 
before. You may want to take a look at the Javadoc for the method you're trying 
to call and make sure that you're passing an appropriate object type into it.

Matt

-----Original Message-----
From: Bob O. [mailto:otis_the_cat@xxxxxxxxxxx]
Sent: Tuesday, March 08, 2005 8:17 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Dates in POI Sql2Xls


   I have one more issue with the POI sql2xls programs. 

   I was trying to save an employee's hire date into a date data type field
   in a physical file and then move that date into the excel sheet the POI
   program creates.  It doesn't seem to do what I want it to do (of course).

   Is my issue with the date field in the physical file?  If so, how should I
   store the date in the physical file so the POI program can easily convert
   it to a date in the spreadsheet?  When I store it in a plain old 8/0
   numeric field, it just moves the text to the cell instead of formatting as
   a date.
-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.