Marco needed to read xlsx format with multiple criteria

[SH_94]

Hi Community,

May i know if anyone have the macro to read the xlsx format with the criteria below:

1. Multiple tab in one excel file

2. Different schema between one excel with another excel file

3. Multiple excel file in one folder.

My current macro only can perform the step 2 and 3.

Is there anyone have the marco ready for the above criteria?

Many thanks 

[DawnDuong]

hi @SH_94 

You already have type 1 macro (multiple tabs in one excel file) working, so it is a matter of updating the "Action" Tool so that

you update the FileName instead of changing the TabName in the path.

Check this out for the ultimate guide in reading multiple tabs/files from Excel:

https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...

Dawn