Writing multiple sheets simultaneously in same excel workbook

Question

I have an alteryx workflow wherein I'm doing some data processing and trying to write into multiple sheets of an excel workbook. Now, I get the error that writing is not possible as the file is being used by another program.

How to avoid this error and make sure all sheets are written in the excel workbook simultaneously.

Thanks in advance!

cjaneczko · Answer

As other have mentioned you can use the Block Until Done on each of the outputs. If your paths are not part of the same flow you can also use Control Containers in place of the BUD's.

Raj · Answer

@234abhishek use block until done tool to first write data into your first sheet and then in next sheet .or look for a wait a second tool if you have access to it.

apathetichell · Answer

You cannot write to different sheets (or use mutliple output tools to write to the same sheet) in excel at the same time. Execl is not a database which supports concurrent transactions. You get around this by timing your outputs using block until done - and making sure that output 2) occurs after output 1) is done.