Skip to main content
Solved

Batch Deploy Read Uniquely Named Excel Sheets

notmyname
Participant
Forum|alt.badge.img

Hello,

I have hundreds of excel books to read one sheet of (they each have only one sheet) then write the data to a database table. I thought this would be simple using batch deploy, I then realized the excel sheet names are different and in the basic way I set up my batch deploy it expects a specific excel sheet name. Is there any way for FME to simply read any excel sheet in an excel book at run time? All the excel sheets have the same column structure.

To be clear:

Excel book= A xlsx file

Excel Sheet= A tab of a excel file

Thanks

Best answer by itay

Hi @notmyname ( what is your name then?) :) anyway its possible have a look at the attached template.

View original
Did this help you find an answer to your question?

2 replies

itay
Supporter
Forum|alt.badge.img+17
  • itaySupporter
  • Supporter
  • Best Answer
  • December 2, 2016

Hi @notmyname ( what is your name then?) :) anyway its possible have a look at the attached template.

notmyname
Participant
Forum|alt.badge.img
  • notmynameParticipant
  • Author
  • Participant
  • December 2, 2016
itay wrote:

Hi @notmyname ( what is your name then?) :) anyway its possible have a look at the attached template.

Awesome, I knew there would be way! I really appreciate it!

 

 

Reply


Helpful Members This Week

Community Stats

31,341
Posts
118,851
Replies
38,930
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.