Are there any examples for these or better documentation of the GT-Excel layout? I am trying to use a G-T Excel format xls file to define a file format that has a header/detail/trailer fixed format. We have used these in the past. But now when I register one of these files as an object - it seems to ignore the format column (a/an/n for alpha/alphanumeric/numeric) - and sets all columns to be numeric.
The parsing and the formats that can be used in GT-Excel format column are:
a - VARCHAR
n - NUMERIC
d - DATE
There's no alphanumeric format there. The attached file works.