I am using excel file as OUTPUT and same excel file used for multiple workflows. If all the workflows runs at same time, will that update all the workflows information ? all the workflow output should be captured, it shouldn't override. How can we achieve this?
Hey @arkimp,
you can definitely write to the same excel file without overwriting anything. For instance append to sheet will just add the new data to the bottom of the sheet. Have you encountered any issues writing to the same file?
Hi @arkimp,
if you try to write to the same excel file with multiple workflows workflows running at the same time. You may encounter different situations:
One workaround would be to combine both workflows into one (if possible) and you could use the crew macro parallel block until done which will do the trick.
If you can't merge workflows, you could also use a third one which will output to excel.
Hope it helped!