Dynamic input (sheet is not specified issue)

Hey,

I have an issue with dynamic input tools since I keep receiving the error "No sheet specified" even I have the sheet selected.

I need to use only the last file save in the folder therefore I use Directory and Dynamic input tools.

I attached printscreens to show the settings.

Thank you in advance!

Asia

Capture 2.png

Capture.PNG

Help

Accepted answers

IraWatt

Hey @joannasokolowska,

when you overwrite the full file path you need to include the sheet name in the file path. You can do this by adding it to the end of the excel workbook name eg. "Example.xlsx|||Sheet1" The three ||| are needed before the sheet name.

To get the sheet names dynamically you can use the dynamic input tool and just import the sheet names then append that to your file path field for your final dynamic input.

All comments

IraWatt

Hey @joannasokolowska,

To get the sheet names dynamically you can use the dynamic input tool and just import the sheet names then append that to your file path field for your final dynamic input.

joannasokolowska

Thank you! It fixed the issue!

IraWatt

No worries glad it worked for you !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703