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

image.png

danilang

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