Collating Multiple Excel Data into one single Excel File

Hi All,

I got stuck in below given workflow where i am trying to read multiple excel files and collating in one single file. I'm facing an issue where it is not looping through all the files. Only the same file iterated twice and loaded in output file, its not reading the data from other file.

Below are the screenshots for the same. Kindly help me if there are any configuration that i have to modify to make it work and read from multiple excel files.

Batch Macro - Action ConfigurationInput Data - ConfigurationOutput message

Regards,

Ananthakrishnan S.

Macros

Accepted answers

Joe_Mako

Looks like you have a typo in your formula expression, is should be exactly:

[FullPath]+"|||`Sheet1$`"

Notice the individual character details and placement. Maybe try copy/paste instead of retyping, or opening the workbook attached in the prior message.

Yes, this expects that the sheet you want to load from each Excel file is named "Sheet1"

If you want to deal with sheets of different names from multiple Excel files, please see the links and video in the prior message.

All comments

Aguisande

Hi @ananth7358

I'm reviewing your workflow (and re-doing it to help).

I'm curious about the Select Records tool you have within the batch macro.. What is it for? How is configured?

Aguisande

Hi @ananth7358

I'm attaching a workflow and a macro that read files based on your sceenshots.

As you can see, reading the excels directly and through the macro, returns the same.

Multiple Excel.yxmc

Workflow that uses the macro.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703