Skip to main content
Question

How to dynamically read excel sheets?

  • December 7, 2017
  • 5 replies
  • 176 views
arthy
Contributor
Forum|alt.badge.img+8
  • arthyContributor
  • 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

5 replies

ebygomm
Influencer
Forum|alt.badge.img+31
  • ebygommInfluencer
  • Influencer
  • 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

arthy
Contributor
Forum|alt.badge.img+8
  • arthyContributor
  • Author
  • Contributor
  • December 8, 2017
ebygomm wrote:

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.

 

 

 

arthy
Contributor
Forum|alt.badge.img+8
  • arthyContributor
  • Author
  • Contributor
  • 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.

ebygomm
Influencer
Forum|alt.badge.img+31
  • ebygommInfluencer
  • Influencer
  • December 8, 2017
arthy wrote:
HI @egomm

 

Not quite sure that I understand what you are saying.

 

Please could you elborate? May be wiith an example.

 

 

 

read-named-sheets.fmwt

 

 

A simplified example

 

 

david_
Contributor
Forum|alt.badge.img+8
  • david_Contributor
  • Contributor
  • September 3, 2024

Is there any way to read dynamically any excel file and that the header are simply the column name A, B, C, D...

Through a Reader I can read any Excel file but the problem is that it always takes the first row as the header.

Thank you!

Reply


Helpful Members This Week

Community Stats

30,942
Posts
117,253
Replies
38,742
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.