Dynamic Input - List of Excel Sheet Names

[mcha54]

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?

[Thableaus · Accepted solution]

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 

[kgordish]

@Thableaus 
Could I ask you post a screen capture of the formula in the config screen of the formula tool?

I am a visual learner. 

Currently, struggling with importing multiple Excel files (with multiple sheets). Only want to import one sheet.
Surprisingly, this problem has be scratching my head.

Thanks.

Kevin

[williamdilley]

My Dynamic input tool is requiring an Input Data Source Template