Run same workflow across all sheets in an excel simultaneously

Hi Community,

I have worked on a file and I wanted an output of all employee scores in different sheets. Sheets are named on their names. I have to copy 3 rows at the very last of the existing fields. These needs to be done on all sheets separately. And the output must be in different sheets only.

Please help me in this. I just want this needs to be done and hopefully my project will complete.

I have attached a screenshot for your reference.

In this workflow, I have taken one sheet of the main file as an input and have done following editing. I want this same thing to be ran on all the sheets separately.

Please help if possible.

Thanks in advance

16891620809964391395242468721471.jpg

Designer Cloud

Output

Batch Macro

Help

Accepted answers

JamesCharnley

Hi @avisingh96

Sort of guessing here based off what you've provided, but assuming the sheets within the excel have the same schema then something like this could work:

The initial input just imports a list of sheet names and the file path, after which we can create full paths to feed into the dynamic input (where schema needs to match). Then the table can be grouped by the sheet. I can't tell from the picture what the second input is supposed to do so mine is just a placeholder but if it's dealing with the '3 rows at the very last of the existing fields' I wouldn't expect it to mess it up.

You can render to multiple named excel sheets by following the steps in this blog: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015093

If the schemas aren't the same then you would need something different.

All comments

JamesCharnley

Hi @avisingh96

Sort of guessing here based off what you've provided, but assuming the sheets within the excel have the same schema then something like this could work:

You can render to multiple named excel sheets by following the steps in this blog: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015093

If the schemas aren't the same then you would need something different.

avisingh96

Hi @JamesCharnley

II think this could work.

What I understood from your solution is based on the file paths we can again get an output in different sheets based on Employee Names. This is the same I used previously as well. I am not sure if Render tool will help me get this kind of output because it was muvh easier with the output tool.

And yes, Schema of all the sheets are exactly same and even the rows that needs to be stacked below the existing data has same schema too.

Hope this works. Will try and let u know..

Thanks.

avisingh96

Thanks @JamesCharnley

The link that you shared worked as a charm.

This was the exact thing I required.

Thanks a lot mate!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703