Replace only one tab in multiple excel files

Hi everyone,

I need to replace only one tab in 1000 excel file and would like to create a workflow to do it.

So I have 1000 excel file in one folder. Every single excel file have the same shema, they have 3 tabs and one of them is called "Input".

I need to update the tab "Input" only in all the 1000 excel files. I have an other excel file that contain the updated "Input" tab.

How can I replace only the 1000 "Input" tab with the updated "input" tab without impacting the 2 other tab in the 1000 excel file? Thanks!

Developer Tools

Input

Reporting

Output

Tips and Tricks

Parse

Macros

Transformation

Dynamic Processing

Preparation

Interface Tools

Iterative Macro

Accepted answers

JosephSerpis

Hi @Afournier it is possible to keep the same number of row. I amended the workflow and added in a unique tool as the append tools was creating duplicates and multiplying your data.

Mutiple_Excels_130919.yxmd

All comments

benakesh

Hi @Afournier ,

In output don't overwrite file but overwrite sheet.

Afournier

Hi @benakesh

I understand that part, but that doesn't solve the fact that I want to create a flow that will replace it in multiple excel files? Thanks

JosephSerpis

Hi @Afournier I mocked up a workflow that I think will answer your question. Let me know what you think?

Mutiple_Excels_130919.yxmd

Afournier

Hi @JS420

It works! the only thing is that it doesn't keep the same number or rows.

In the 1000 excel file the Input tab contain a table with 10 rows and its exactly the same in the updated input tab. When I run the workflow, the new updated Input tab has 100 rows, seem like it multiple the number of rows (10*10). Do you know why? Is is possible to keep the same number of rows?

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703