Writing Result in Excel file via output data tool

[Vikas038]

Hi Team,

I am writing my wf result in excel file via output data tool. But after run, wf giving error that "Attempt to open a file that is already open". But I checked that file is closed at my end.

Please let me know what is causing this issue

[JagdeeshN]

@Vikas038 are you trying to write to multiple sheets within the same excel in the workflow?

Can you please share a sample.

[binuacs]

@Vikas038 please share your output tool configuration

[Vikas038]

Hey Guys. Block untill done has worked in this case very well. Please consider this case as closed.

[atcodedog05]

@Vikas038 

Solution authors are Happy to help : )

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day!

[JagdeeshN · Accepted solution]

@Vikas038  glad you got it resolved. From the looks of it, this was happening because you you accessing the same file multiple times in the same workflow.

The blockUntilDone tool resolves this because this prevents simultaneous access/write from happening.