Skip to main content
  • EN

Hi fme guys ;-)

 

 

I have to create an export tool that will have as reader an excel file...

 

The problem is that the worksheet used won't have the same name everytime...

 

 

The structure will remain the same... It's only the name of the worksheet that changes...

 

 

My question is, how could I handle this problem...

 

Thanks for you help...

Do you have multiple worksheets in each file and you want to read only the first sheet? Or multiple worksheets with different sheet names but only one sheet

Use the FeatureReader and the Generic port should work? Kick it off with a Creator before the FeatureReader

 

Or use the FeatureReader to get the Schema - use a Sampler to only get the first schema, the first sheet, and then use the FeatureReader_2 to read only that sheet selecting the fme_feature_type_name (or another attribute which contains the sheet name) as input

Thanks for you help guys ...

 

 

I used the "2 FeatureReader" method:

 

 

I the first one I set the Excel file to the prompted parameter:

 

 

this one will be set further in the project by webinterface (FME Server)

 

the second Reader is the same with the feature type to read set to fme_feature_type_name

 

And at the end I expose the parameter with the attributes from one excel...

 

Have a nice day (you made mine 🙂 )

 

Reply


Community Stats

30,109
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie 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.