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-Excel-Macro/ba-p/9988

Dawn