different outputs in the same excel file

Hello community, good day, could someone help me know how, when generating the output in Excel format in an Alteryx flow, I could create more outputs but instead of creating more Excel files, they would be added to the same excel but creating different sheets with different names, since when I want to do it that way I get an error that the file is already open.

I attach an image of the configuration that I currently have in the excel output.

Thank you very much for the support

Salida.docx

Workflow

Accepted answers

binu_acs

@FernandoR one way of doing this

Excel_250924.yxzp

All comments

OTrieger

@FernandoR

What you will need to do to change the sheet names in your full path, so that will ensure that all the sheets will be saved on the same file.

You can do it in a batch macro then you will not have an issue, or split the data and use Parallel Block Until Done or Control Containers all these ways will ensure that the sheets will be saved on different intervals.

FernandoR

Thank you very much for the comment, but do you happen to have a small flow as an example, even if it is 2 sheets that are saved in the same Excel? To give me a more precise idea and be able to replicate it in my flow?

binu_acs

@FernandoR one way of doing this

Excel_250924.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703