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
Solved! Go to Solution.
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
Hello Dan
Thank's for your help