Reading one sheet from 12 different excel files

Hi,

Does anyone have a standard Macro where Alteryx will read one sheet (same format in all excel files) from excel files with different schema? And then produce one output with all the sheet information underneath one another?

New to alteryx so any advice will be helpful

Macros

Accepted answers

atcodedog05

Hi @SlStephanieLouw

Which will be helpful for you and give an idea.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Guessing you have missed the step of adding sheetname to filename.

Hope this helps : )

All comments

Emil_Kos

Hi @SlStephanieLouw,

please Check this macro:

https://gallery.alteryx.com/#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172

i think this is the Best macro to read many files at the same time.

it will also work for files with difrent schemas.

SlStephanieLouw

Hi @Emil_Kos

Is there a simpler version?

I am looking at only xlxs workbooks (for some reason they have different schemas).

And I only need one sheet from each workbook.

I have created a macro that reads all the workbooks regardless of schema. But when I add the macro to my directory tool then the error 'No sheet specified' occurs.

Now I need to create full path that includes file path and sheet name - which I am struggling to incorporate properly in my workflow.

Any basic solution for this?

atcodedog05

Hi @SlStephanieLouw

Which will be helpful for you and give an idea.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Guessing you have missed the step of adding sheetname to filename.

Hope this helps : )

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703