Skip to main content
  • EN

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.

1I 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.

2 

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.

Hi @tfcw​ ,

I tested it with the new Version 2021. Here is how it looks like:

Excel_readerExcel_reader_2Maybe someone @safe can help here, why it looks so different and how it have to look like.

Hi @tfcw​ ,

I tested it with the new Version 2021. Here is how it looks like:

Excel_readerExcel_reader_2Maybe someone @safe can help here, why it looks so different and how it have to look like.

Thank you! I've installed FME 2021 and I'm getting the number_format_string text in the .formatting attributes, I think this is exactly what I need

Reply


Community Stats

30,162
Posts
114,512
Replies
37,820
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.