Skip to main content
Solved

Excel Reader: Any way to read the displayed, formatted values for number cells?

  • April 30, 2021
  • 2 replies
  • 71 views
tfcw
Contributor
Forum|alt.badge.img+1

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.

Best answer by connecter

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

connecter
Contributor
Forum|alt.badge.img+10
  • connecterContributor
  • Contributor
  • Best Answer
  • May 3, 2021

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.

tfcw
Contributor
Forum|alt.badge.img+1
  • tfcwContributor
  • Author
  • Contributor
  • May 3, 2021

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

Community Stats

32,154
Posts
122,044
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.