Dynamic Input - List of Excel Sheet Names

Hi there! I'm trying to get a list of sheet names for a sheet that I feed the filepath (eg C:\excel.xlsx) into a Dynamic Input tool. I receive a message saying "No sheet specified, you must specify a sheet". I don't know what the sheet names are, hence trying to get a list of sheet names. Is there a different configuration that I need to do for this?

Input

Best Practices

Accepted answers

Thableaus

Hi @mcha54

Try to add a Formula Tool before the Dynamic Input to your FilePath Field

Use this formula:

[FilePath] + "|||<List of Sheet Names>"

It should work.

Cheers,

All comments

Thableaus

Hi @mcha54

Try to add a Formula Tool before the Dynamic Input to your FilePath Field

Use this formula:

[FilePath] + "|||<List of Sheet Names>"

It should work.

Cheers,

mcha54

Worked like a charm, thank you!

8088

Hi !

Thanks for that tip - it helped me out too. Out of curiosity, where in the documentation can I find out more about <List of Sheet Names> and others like it ?

PoojaSingh88

Doing this ( adding formula ) before the dynamic input reads the sheet names from the excel file not the contents ..wham am i missing

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167