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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamic Input - List of Excel Sheet Names

Highlighted
Asteroid

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
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,

Asteroid

Worked like a charm, thank you!

Meteor

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 ?

Meteoroid

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

Asteroid

@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

Labels