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

[sparksun]

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?  

[Yoshiro_Fujimori]

Hi @sparksun ,

I guess this blog page by @DataNath may help.

https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015...

Good luck.

[sparksun]

thanks,actually I know how to render the data to multiple worksheets with the solution in this blog. What puzzle me is how to consolidate multiple existing formatted worksheets in different excel files into one file with multiple worksheets.

[aasmith8116]

Maybe this is must my brain but could you explain "each file has a worksheet with formated tables"

Do your excel files have multiple tabs? or does each tab contain multiple tables?

Do you have maybe a sample file? Could you explain any differences in each file (Do they contain different column headers or are they all the same)

[sparksun]

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.