Skip to main content
Question

How to read the data from excel file from a directory

  • January 30, 2025
  • 3 replies
  • 44 views

pauline1985
Contributor
Forum|alt.badge.img+2

Hi,

I need your help.

I would like to read the data from an excel file that change every week.  Moreover the excelfile have a different name every week.

I would like to try to automate the process and as an input i would like to have the directory instead of the file.

 

How can I do that?

 

Thank you for your answer.

Pauline

 

3 replies

hkingsbury
Celebrity
Forum|alt.badge.img+55
  • Celebrity
  • January 30, 2025

An old article, but still relevant - http://docs.safe.com/fme/2013/html/FME_QuickTranslator/content/fme%20configuration/dataset_wildcards.htm

 

You can use wildcards in your paths to read everything in a folder


pauline1985
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • February 6, 2025

Thank you for the article.

Where should i use the wildcards? in a reader excel?

 

Thank you.


pauline1985
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • February 7, 2025

I find it!


Reply


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