Solved

Trouble reading Excel files into my workbench

Forum|Forum|5 years ago
April 27, 2020
3 replies
72 views

E

eva218

Hello,

I am struggling with reading Excel files into my workbench.

I built my workbench based on an Excel file with this format.

When adding the reader I set the 'field names row' at 3, so the names in row 3 are used as column headers in FME.

I want to use my workbench for other files as well. These files have the same format. Only the information from row 4 will be different. So I created two user parameters witin my workbench:

- Input File

- Output Directory

If I open my workbench and run the translation I can fill in the user parameters:

When I choose the original file which I used to create the workbench, all goes well.

But when I choose another file, I only get missing values:

I even made a copy of the original file, so it is exactly the same document with only a different file name. But even then I get missing values.

Can anyone explain to me what I need to change in my settings to overcome this?

Has the red indication in the User Parameters window something to do with it?

Thanks in advance!

Eva

Best answer by chrisatsafe

Hi @eva218,

Have you tried setting the Additional File Settings to Use Current Settings instead of Use FME Default Settings?

https://www.screencast.com/t/AAUjXryI

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.