Solved

Batch Deploy Read Uniquely Named Excel Sheets

Forum|Forum|8 years ago
December 1, 2016
2 replies
47 views

notmyname
Participant

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.