Question

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

Forum|Forum|5 years ago
July 6, 2020
2 replies
13 views

+23

tnarladni
Enthusiast

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?

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.

+52

danilo_fme
Celebrity
Forum|Forum|5 years ago
July 11, 2020

Hi @tnarladni

Could you share your Workspace?

Thanks,

Danilo

Partner Solutial Brazil - www.solutial.com.br

Upvote

+23

tnarladni
Author
Enthusiast
Forum|Forum|5 years ago
July 13, 2020

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