Directory Dynamic Input

[danielmaguire]

Hi,

I have a folder with circa. 70 different excels, each excel has 2-3 sheets (different names).

I am looking to list all sheet names as well as full file path (including sheet name). I am having difficulty listing all sheet names. I tried using using the configuration in the attached snippet however it only seems to output the first excel's sheets, presumably because in the second excel, the sheet names differ.

Any help would be greatly appreciated!

Thanks,

Daniel

[shreyanshrathod]

Hi @danielmaguire ,

This should help you out. Set the Directory location according to your system.

Regards,

Shreyansh Rathod

[danilang · Accepted solution]

Hi @danielmaguire 

That same config works for me

Of course the sheet names show up in the [Sheet Names] column.  You need a formula tool to replace "<List of Sheet Names>" in the filename with the values from the [Sheet Names] field

Dan