Skip to main content
  • EN

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

Eva,

if u can attach your xls file to your post or a sample / similar file it will help community members come up with a solution for you

@eva218

............

Regards

Howard L'

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

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

Thanks @chrisatsafe. That solves my problem :-)

Reply


Community Stats

30,112
Posts
114,307
Replies
37,745
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.