Hi,
is is there a way to have separate output tools output to different sheets in the same excel file? I selected the same file with different sheet names, but I get an error that the file is in use.
i appreciate any pointers.
regards,
Alexis
Hi Alexis,
This is possible with the use of the 'Block until Done' tool. This will cause one write to finish before the next starts.
Kane
@KaneG or anyone else that has background, could you elaborate on how the Block Until Done tool could be used for this? I've got 3 separate data processes in my workflow. I am looking to write each of these as a sheet within 1 master excel file. The data is not structured the same in the 3 processes so they all need to be output independently.
Thanks!
Hi @jb,
I might see if I can get this question moved to the Data Prep & Blending section of the forum as it is a diversion from the KB article and will see more eyes in the forum.
You can put the Block Until Done tool back where your data splits or if you put a Block Until Done tool before each of your outputs, this should work also. The other option is to seek out @AdamR_AYX's Parallel Block Until Done tool from the CReW Macro Pack. There are other ways if your data is disconnected but they all basically involve either connecting your data streams in some way or splitting them out to separate Workflows/Apps.
Hi Kane
I am facing similar issue as well. Where I have an excel file called worksheet 1, and within it there are 3 tabs called sheet 1, sheet 2 and sheet 3.
I have used 'Block until Done' Tool. which is works fine to output tab names only to different excel files.
But the content are not included at all.
Could you be able to advise please?
Please see the attachment.
Thanks
Block Until Done isn't doing it for me.
I have three separate streams that each write to a (different) sheet in the Excel workbook.
Each of the three Output tools is preceded by a Block Until Done.Nevertheless,I'm still getting the error "...cannot access the file because it is being used by another process."
In the three Output tools, the output option is Overwrite Sheet (Drop) -- does that make a difference?
I like this option because it should save me from having to go back and delete the file each time I re-run the workflow. But, it seems like when I do delete the files, the workflow runs OK the next time, without the error.
Puzzled.
