How to Read an Excel File with different Sheets correctly?

Hi,
i have followed the routine for this task, but don´t get the result i would like to have
image

My Example ist i have the following Excel File with two Sheets:
image
image

But I always get Sheet 1 doubled as output:
image
Would be great if someone could help me :slight_smile:
Greatings
Julian

Hi @Julez and welcome to the Knime Community.

This is because you are reading the same sheet twice :slight_smile:

You have to set the sheet variable to the sheet name. As it stands, you are sending the file variable to read the file, so you end up reading the file twice and reading the same sheet.

So, the first thing to do in your Excel Reader is to choose the option “Select sheet with name”:
image

Then go to the Flow Variables tab, and assign your variable to the sheet_name variable:

One additional information. If your sheets have different columns, the Excel Reader might complain. In this case, use the “Support changing file schemas” in the “Advanced Settings” tab:
image

EDIT: Also, please avoid using deprecated nodes. Deprecated nodes mean that they have newer versions that should be better or have new features, which you can take advantage of. Also, deprecated nodes are removed in newer versions of Knime

4 Likes

thank you for the warm welcome and for solving my problem :slight_smile:

2 Likes

No problem @Julez , happy to help

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.