Using Directory tool to upload certain sheet on multiple files

Hi,

Greetings !

I have multiple files ( up to 20 xls format file ) and I use Directory tool to upload all files, then filter require file :

The result show as below (which is correct) :

However, i have difficulties to use dynamic input tool, since all above file contain multiple tabs on each files.
I would like to input data from 'Sheet1' tab from each related files.

Kindly find dummy files as per attached.
Thank you in advance !

Dummy source files.zip

Tips and Tricks

Accepted answers

Qiu

@fikrizahari
Lets try this Macro.

https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750

All comments

Qiu

@fikrizahari
Lets try this Macro.

https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750

fikrizahari

Hi @Qiu ,

Thank you for you sugesstion.
It is definitely a great macro tool to read xls and specific sheet.

However, since i already have existing directory tool which link to another workflow,

do you know how to combine filter tool ( yellow highlighted ) with the Macro tool ?

binu_acs

@fikrizahari You don't need to use a separate directory tool for this macro, all options available in this macro, check the Folder and Options tab in the macro

Qiu

@fikrizahari
I am sorry if I misunderstand your question.
but do you mean something like this?

Or you want to stick to your directory tool?

Qiu

Right.
I just realized that we can not really import the Sheet List for XLS files.

So using above Macro might the only choise we have.

fikrizahari

Hi @binu_acs,

As per my first posting, there's much more different files that require different preparation and massaging.
So, I already have existing workflow which start with Directory tool, however i find difficulties on filtering 'specific' tabs for xls file type.

Currently i was able to figure out how to connect with the 'Excel File Opener' macro tool with some changes on that macro.
Below is my current workflow :

Hi @Qiu,

I would like to combine the existing filter tool with the new 'Excel File Opener' macro tool.
As per mentioned above, below is the changes I have done on the macro to suit my requirement :

The existing tool on the 'Excel File Opener' macro tool :

My version of the 'Excel File Opener' macro tool :

Hence I was able to link the macro tool with my existing Filter tool
Hope its clarify !

Thank you once again !

Qiu

@fikrizahari
good to know it works for you.
Thanks for the feedback!

Laksh345

It is not working. i am trying to import multiple excel file from the same folder with same header.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335