In the January 8, 2004, issue of this newsletter, I demonstrated how to use RPG and Java to parse an Excel spreadsheet. In this article, I will explain how to read dates from a spreadsheet using the same tools. An Excel date is a numeric cell that contains the number of days since January 1, 1900. You can apply many different formats to the number so that it appears as a date when people read it. The following subprocedure converts an Excel date to the date data type ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.