Question

How to dynamically read excel sheets?

Forum|Forum|8 years ago
December 7, 2017
5 replies
244 views

+8

arthy
Contributor

Hi,

I have the values of an attribute which corresponds to the names of sheets of an excel file. In other words, the attribute of interest has the values attrib1, attrib2, ..., attribn that also corresponds to the sheet tab names of another excel file.

What I would like to do is to be able to dynamically read the sheet tab names of the excel file based on the values attrib1, attrib2, ... attribn that varies per feature. Those values are unique per feature so I won't need to read the same excel sheet twice.

Any ideas?

Thanks

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.

+46

ebygomm
Influencer
Forum|Forum|8 years ago
December 7, 2017

If you use a feature reader to read the excel file, you can use the attribute containing your sheet names as the feature type to read

Upvote

+8

arthy
Author
Contributor
Forum|Forum|8 years ago
December 8, 2017

If you use a feature reader to read the excel file, you can use the attribute containing your sheet names as the feature type to read

HI @egomm

Not quite sure that I understand what you are saying.

Please could you elborate? May be wiith an example.

Upvote

+8

arthy
Author
Contributor
Forum|Forum|8 years ago
December 8, 2017

Looking for an alternative, is there a way to read the sheet name as parameter in an excel reader?

I would like to use a workspace runner and pass the attribute value (which corresponds to the sheet name) as a parameter to the second workspace used for reading the excel file.