I have an excel sheet, and need to read the value that's displayed in the cell, rather than what the actual saved value is.
I haven't had much luck being able to find any way to do this. I was hoping the <attribute_name>.formatting attributes would contain this value, but it doesn't seem like it is.
This is messy data, and values in this column might be text, might be a number, might be rounded to different decimal places, or might be padded with .0 in case of integers. So any solution would have to be on a per cell basis rather than making any global assumptions on how a number ought to be formatted.
If there's a solution that works in FME Desktop 2017 that would be preferable, but I'm willing to use later versions if necessary.