I am reading an Excel spreadsheet which has a column containing date values using FME.
The problem is that all date value are encoded as normal text in Excel, except a few cells which are encoded as true date format. But when I open the .xlsx file, they all looks the same:
Here for example, the format of the second cell is 'date', while the two others are encoded as 'text'.
I'm using an XLSXR reader in FME. For that column, the reader tells me it is has a 'Char' type:
But once the file is read, these data becomes:
which is causing me some troubles in some following transformer, e.g. the
Is there a way to actually force the reading of that date column as 'text' everywhere? Because it seems that FME is taking into account the actual Excel encoding, even so it is saying its type is 'Char'...