Viewing the Contents of the Excel File with Specific Tab

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

Workflow

Common Use Cases

Accepted answers

Luke_C

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/ta-p/24946

All comments

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

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/ta-p/24946

KamenRider

Hey @Luke_C it works.

Thanks,

Kamen

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703