community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Dynamic Input - List of Excel Sheet Names

Meteor

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?

 

 

 

2019-02-06_11-24-42.png

Alteryx Certified Partner

Hi @chanmar 

 

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,

Meteor

Worked like a charm, thank you!

Meteoroid

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 ?

Labels