Retrieving formatted value instead of numeric value

[bsnuggs76]

I need to retrieve a date field from a cell. If I view the cell in Excel it's displayed as '05/03/2010
'. If I use HSSFCell_getStringCellValue it fails because the date is stored as a numeric value. If I use HSSFCell_getNumericCellValue it retrieves the numeric value that Excel stores it in (which is 40301). Is there any way to retrieve the edited value so reformatting/converting doesn't have to occur in the RPG program?

[D.Abramowitz]

Unless I'm misreading your post, the date within Excel should convert easily to a date data type on the AS400. At this point the date can be read by an RPG(LE) program.

Dave

[T.Snyder]

You could try the getDateCellValue method for the HSSFCell class.

Here is a link to the JavaDoc

It returns a Date object, so you could retrieve what you're looking for from there, or use the toString method on the Date. This makes a perfect candidate for a custom procedure

Note: I do not have that version of POI currently installed, so I am not sure if it is available for the version you are using, but you could try it out.

Have Fun,
Tom

[T.Snyder]

I just reviewed the JavaDocs for version 3.0.2 and here is what is in the JavaDocs:
public java.util.Date getDateCellValue()

So, you can code this knowing that it is available for that version.

Enjoy,
Tom