Re: RPG reading Excel with Scott Klement's routines

[Steve Jones <sjones@xxxxxxxxxxxxxxx>]

Cell = SSRow_GetCell(Row: 0);
Type = SSCell_getCellType(cell);
If Type = CELL_TYPE_NUMERIC;
  do numeric
else;
  do text
endif;

On Tue, Feb 28, 2017 at 9:41 AM, Englander, Douglas <
Douglas_Englander@xxxxxxxxxxxxx> wrote:

> Does anyone know if there is a java method or function to return the
> format of a particular cell [as opposed to forcing a cell to a specific
> format]? We have multiple spreadsheets used as input from a vendor.
> Sometimes a column is formatted as text, sometimes it is formatted as a
> date. If it is formatted as text, I would need to process the value one
> way, versus if it is formatted as a true date, then I process the value a
> different way.
>
> Does anyone know if this function exists?
>
> Thank you,
>
> Doug
>
> --
> This is the RPG programming on the IBM i (AS/400 and 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD