Output in Excel files
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am building a workflow and I need to record 2 outputs:1 data output before a data transfomration in an Excel tab and another data output after the data transformation in another Excel tab but the same Exel file). When I run the workflow, I get an error: the excel file is used by another process and can not be opened. I tried to use th container, but it is not working.
Can someone help me out ?
Thank you.
Alex
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AlexZ91
use Block until done before writing second output
this will solve the issue
hope thishelps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Raj.
Thanks for your suggestion. I have been checking how to use this function, but it is still confusing.
In this workflow attached, where should I place the block untill done function ?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Raj,
I tried this at the end of my whole process. So the idea is
- to write into excel sheet 1 at anchor 1
- once finished, write into the same excel but in sheet 2
- once finished, write into the same excel but in sheet 3
When I run the workflow, it seems that the whole process stops at the entry of BUD and not writing at all any excel sheet. Is there anything wrong ?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AlexZ91 Guess the process is actually taking time but not stopped after writing to 1st output, the process has to join and then write to 2nd, 3rd outputs.
You can use all the joins before 'Block until done' tool and then output tools at the end.