Viewing the Contents of the Excel File with Specific Tab

[KamenRider]

Hi Guys,

I have a file with multiple tabs. Can you help me view the contents of the file with a specific tab, for example tab Price. From there i am going to choose A2 to F100 to create another file in another shared drive.

Hoping for your assistance.

Thanks,

Kamen 

[Luke_C]

Hi @KamenRider 

Can you say more about your use case? When you set-up an input tool it asks you to define the tab. 

When processing multiple excels with multiple tabs, it's common to pass the list of files through to a batch macro configured to "Get all sheet names", then filter those sheet names and construct a file path with the sheet name appended that another macro uses to read in. 

[KamenRider]

Hi @Luke_C 

I am using the directory tool since it consist of multiple excel files being saved everyday. Since this is an everyday report, what I needed only is the latest file with the latest date included in the filename which is being filtered. I already have the file shown (for example, Balance report.xlsm) but what I needed is to produce the contents of the file for a specific tab like price tab (sheet). Below is the structure of the workflow.

 

I hope you can help me with this.

Thanks,

Kamen

[Luke_C · Accepted solution]

Hi @KamenRider 

If you're always looking for the 'Price' tab just append '|||Price' to the fullpath and run it through a dynamic input

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Tool-Mastery-Dynamic-Input/...

[KamenRider]

Hey @Luke_C  it works. 

Thanks,

Kamen