Output set of data both on one sheet and several other sheets in the same existing file

[Victouf]

Hi all,

I am trying to do 2 things at the same time :

1) Write my set of data to an existing sheet (Base Scrap 2) of an existing excel file (Quality-Scrap 2021 Agosto W#2.xlsx)

2) Write this same set of data to the same file but in several sheets sorted by Area ("Incoming Quality (IQ)", "Predelivery", "GRC", "Vehicle Evaluation")

I am able to do 1) or 2) separately. Actually I can do both by re-running the workflow changing the config and it does the trick. But I am looking for a solution that allows to do both at once. 

Anyone who could help with this issue ?

Thanks a lot 

[RolandSchubert · Accepted solution]

Hi @Victouf ,

if I got you right, you want to write your results data to different sheets within the same Excel workbook. You could use a Block Until Done tool and connect the two Output Data tools to output anchor 1 and 2:

What do you think?

Best,

Roland

[Victouf]

Awesome, looks like it worked just fine. Thanks a lot !! Regards