Workflow output as different sheets in one Excel sheet

Question

Hello all,

I have a workflow with multiple outputs. Is there a way to extract all these output in one excel sheet on different sheets without creating different outputs then combining them together?

Thanks!

echuong1 · Answer

For your outputs, configure them all to write to the same file name. You can specify the specific sheet name after you set the overall file name.

In the example attached, they are both writing to a file called "data." The top stream is writing to Sample 1 and the bottom to Sample 2. You may get an error saying the file is being used by another process because it is trying to write both sheets simultaneously. You will need to use the block until done tool, shown below.

New Workflow1.yxzp

Emil_Kos · Answer

Hi @dinaselim1,

I am assuming that one of the column would be used to specify a sheet name so I have build a workflow that does that:

Workflow.yxmd

dinaselim1 · Answer

Hi @wdavis

Thanks for your reply!

Yes to the first option. I'm looking for a way to write multiple outputs in one excel workbook with different sheets.