I am trying to combine multiple excel files into one output file

Edgar_Ryan_C

Dear Experts,

I am humbly asking for help. I tried using directory input to import multiple excel files (wildcard). Is there a way to export these files into a single output file but in different sheets according to its filename? Assuming each files have different format.

sample.yxmd

Should be output.xlsx

ArtApa

Hi @Edgar_Ryan_C - You will need a batch macro to read files with different schema. I created a quick sample for you:

Please note:

-For a new sheet to be created in the output file, your Alberta files must have some values. That's why as you can see above I added 1's.

-This workflow only reads "Sheet1". You would need to create one more batch macro to read all files with all sheets before combining them into one output.

Hope that helps.

Files2SheetsAA.yxmd

Files2SheetsAA.yxmc