How to consolidate all the worksheets in multiple excel files into one excel file?

Question

I've created 30 excel files in a workflow,each file has a worksheet with formated tables, I want to know how to consolidate all the worksheets into a single excel file.I learned from Chatgpt that VBS or Python code can do it, but I'm not a coding man,anyone know how to run VBS or Python code in Alteryx? Or any other no-code solution?

dreldrel · Answer

You can use a dynamic tool or a batch macro to help you achieve it. If this helps, feel free to like the comment and select it as the solution

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

lwolfie · Answer

Were you able to figure this out?

sparksun · Answer

I've attached three sample files and my expected result file for clarification of my requirement.

You can see three worksheets in three excel files have been consolided into one excel file while the original worksheet formatting is kept well (I use Visual Basic codes to generate the file).What I want to know is how to use Alteryx workflow to make it happen with Python,Run Command or any other tools or solutions.

1.xlsx

2.xlsx

3.xlsx

expected result.xlsx