Skip to main content
Question

Reading Excel formatting


tnarladni
Enthusiast
Forum|alt.badge.img+15

Is there to read in the formatting of the excel? I need to find all the records that are filled in red and exclude them. I tried fme_fill_color and fme_color but those weren't it. Thanks!

4 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • June 22, 2020

Have you got the read formatting parameter ticked?


tnarladni
Enthusiast
Forum|alt.badge.img+15
  • Author
  • Enthusiast
  • June 22, 2020
ebygomm wrote:

Have you got the read formatting parameter ticked?

Ah. I had to add a new reader in order to tick that. Thanks. Is it possible to tick that after the reader has been created?


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • June 22, 2020
tnarladni wrote:

Ah. I had to add a new reader in order to tick that. Thanks. Is it possible to tick that after the reader has been created?

If you've already got the reader on the canvas you should be able to go to Update Feature Types on the Reader menu to get back to the option where you can select the formatting parameter


pmcpherson
Contributor
Forum|alt.badge.img+9
  • Contributor
  • June 25, 2020

Should we expect the fill color to always be read correctly with the "read formatting" checkbox checked and with an XLSX file? I'm working an example now that seems to honor the correct color sometimes but not always. For example, it reads the Excel fill color RGB 146,208,80 correctly as 0.5725,0.8157,0.3137; but it reads the Excel fill color RGB 142,169,219 as 1,1,1. Any thoughts?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings