Combine multiple excels into one with multiple tabs

As the inputs share the same schema, we just bring them all in together using a wildcard in the input. As part of the Input Data configuration, we output the filename which is then used as the sheet name in the final output.

The key parts of the aforementioned configuration are here - save the Excels into one directory and use the *.xlsx to bring in every Excel file. Then select 'File Name Only' in option 5:

Workflow.yxzp

Felipe_Ribeir0

Hi @selsset97

Try the attached workflow.

inputoutput.yxzp

ShankerV

Hi @selsset97

Please find one way of doing this.

Many thanks

Shanker V

selsset97

Hi, thank you for your response. Could you upload the code please?

DataNath

@selsset97 packaged workflow is attached to my original post which you can download and extract then use

selsset97

I put the same parameters you did but it still does not work.

This is the error message I have. The data I am trying to merge does not necessarily follow the same structure. Is this the reason why the error pops up? Thank you.

ShankerV

Hi @selsset97

No, its not because the data's in multiple files are not in the same structure.

That's why I have used macro to read the files with different structure/schema.

Can you please post few screenshots of workflow, not in need to share the data's if its sensitive information.

Need to know how its modified or to investigate further.

Many thanks

Shanker V

binu_acs

@selsset97 Make sure that your input files are having the sheet name 'Sheet1'. If not you need to create another batch macro to extract the tab names first

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703