Select a specific sheet from an Excel file and exploit this one

Question

Hi ;)

I don't know how to do, to select and exploit data from a specific sheet in an Excel file.

I receive different excel files but always with the same name of sheets "DOC1", "DOC2", "DOC3". I want to select manualy my Excel file but select automatically the right sheet that i need (DOC3).

I started my workflow like this

I select the sheet "DOC3" but don't know how to exploit data from it to process in the container "data preparation"

Maybe i have to use macro tool ? if yes can you help me ?

Thank's a lot in advance

Imput specific sheet.yxwz

TEST.xlsx

danilang · Accepted Answer

Hello @Sousou

Since you know that you always want to read DOC3, setup your input Data to read from this sheet instead of Import the list of sheet names.

Then you can send this data further down the workflow  Import the list of Sheet Names only gives you a list of the names of the sheets and not the data within the sheets

Dan