Question

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


Badge +9

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

Userlevel 4
Badge +30

Hi @tnarladni

Could you share your Workspace?

 

Thanks,

Danilo

Badge +9

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

Reply