Solved

Batch Deploy Read Uniquely Named Excel Sheets

  • 2 December 2016
  • 2 replies
  • 2 views
notmyname
Rank
Badge

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

icon

Best answer by itay 2 December 2016, 12:16

View original

2 replies

itay
Rank
Badge +16

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

notmyname
Rank
Badge

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

28,661
Posts
109,319
Replies
36,528
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.