Dynamic excel sheets input

unknown

Hi All,

I want to import excel sheets(sheet1,sheet2,sheet3) not excel files, and dont want to combine sheets data in a single output instead want to read all sheets separately example sheet1 as one input sheet2 as another input and so on.I need help urgently, if anyone knows the solution pls rply.

Thanks in Advance

mceleavey

Hi @Inactive User ,

Yes, given you want to keep them all separate there would be no benefit in using a dynamic input, you would simply need separate input tools for each sheet.

When you use your input tool and select your Excel file, it will then prompt you for which sheet you want:

You just need to do this for each sheet in the workbook.

I hope this helps,

M.