Skip to main content
  • EN

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

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

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


Community Stats

30,353
Posts
115,359
Replies
38,089
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.