Error in Output when trying to output in 3 different sheets of same Excel file

[Dheeru28]

Hi All,

I have three output streams in my workflow for three different cases. I have to output them in 3 different sheets of the same excel.

I have used three Block Until Done tools in the following way:

 

First time when I ran it, it gave the output as desired in three different sheets in the same excel file.

However, the next time I ran it, it gave an error. I have tried some fixes like keeping no space between sheet names. The path of the file is also correct.

The errors keep changing and I get the output file but only one or two of the sheets are there. The errors also keep changing.

Error: Output Data (95): Unable to open file for write:  - Attempt to open a file that is already open: The process cannot access the file because another process has locked a portion of the file. (33)

Unable to create backup of UBR.xlsx.bak: Access is denied. (5)

Can someone please help me on how to fix these errors? Or, can recommend any other way to get the desired output?

[SPetrie · Accepted solution]

If the extra columns caused by using a union and a single output tool are an issue, you can try to cascade them to force an order of operations.

Im not a huge fan of this type of solution because it adds extra tools and should be unnecessary (in a perfect world, the tools actually take their turns like we would all expect).

Basically, you alter your original output and blocks, but add extra steps after the output and append something from that step to the next branch. The block will finish the output and then add the info to the other branch. The other branch cant output until that happens, so it forces the order.

Again, I am not a fan of this method, but if its stupid and it works its probably not stupid.

[Dheeru28]

@pereisyd This is the configuration of the output tool:

 

[pereisyd]

since you're using "Change entire File Path" in the o/p, the SheetName column should have the absolute path of the XLSX|||SheetName, so I would suggest adding the absolute path to the formula tool!