Merging multiple .xlsx workbook into single Excel workbook

Question

Hi,

I was trying to merge multiple .xlsx workbook with different format into single Excel workbook (with each excel file as separate sheet) without making changes to there format. Any suggestion on how I can achieve the above goal.

Note: The output's were generated using the multiple Render tools

Luke_C · Answer

@Vishal_95 I think my question still remains, if all of the data is already in your workflow I would think it's easiest to consolidate it there into a new output rather than make a new process to read in multiple excel files. The formatting is the tricky thing here. You could definitely use one of the approaches @ChrisTX mentioned, but you'd have to make a new render tool to control the format or output to a custom template depending on what this formatting is.

Vishal_95 · Answer

Hi @Luke_C

Sorry for confusion, currently the output generated are mix from multiple Macro Output & Render tool.

Luke_C · Answer

Hi @Vishal_95

You note that the sheets were created via multiple render tools. What is the reason for trying to combine the excel files rather than modifying your workflow to render them all together?