Skip to main content
Question

How to read the data from excel file from a directory

  • January 30, 2025
  • 3 replies
  • 39 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+54
  • 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!


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