Skip to main content
Question

Using merged feature types in Excel reader and also get the formatting


tnarladni
Enthusiast
Forum|alt.badge.img+15

I have created an excel reader with the merged feature type because the source dataset as well as feature type (sheet name) changes with each run. But when I am using merged feature types, I cannot get the .formatting. THey are all coming over as "missing". I would have to specify a specific feature type (sheet name), but because it changes each time (not named Sheet 1), I cannot specify that at creation time.

Is there not a way to do this? Am I missing something?

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+41
  • Evangelist
  • July 11, 2020

Hi @tnarladni

Could you share your Workspace?

 

Thanks,

Danilo


tnarladni
Enthusiast
Forum|alt.badge.img+15
  • Author
  • Enthusiast
  • July 13, 2020
danilo_fme wrote:

Hi @tnarladni

Could you share your Workspace?

 

Thanks,

Danilo

I am not able to share the workspace. But you can add an excel reader, go into the parameters and check "Read formatting". If you run it with caching, you can see all the formatting for each cell. Now, go into the parameters for the feature type and tick on merge feature type and run it again. all the formatting will be <missing>.


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