Reading one sheet from 12 different excel files

[SlStephanieLouw]

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

[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 · Accepted solution]

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 : )