Want data in same excel file but different tabs

[Meghnagupta]

I have attached  a workflow and 2 output files.

I want these output files to be in 1 excel sheet but different tabs but no cell is common in between. Is it possible?

[ed_hayter]

This can be done by turning your tables into reporting tables - then unioning the two reporting snippets and when rendering them splitting them by a row of whitespace.

I couldnt run the workflow as you did not package it to include the input files. I have attached it have a look at how it runs for you.

Edit:

Not sure what you mean by excel tabs. If you want them in the same excel workbook but different sheets two output tools to the same file but specifying a different sheet name would work. hopefully this covers either interpretation of your request.

[Bren312]

If I'm tracking on your question correctly, you want one Excel sheet (WorkflowOutput.xlsx) with one tab labeled "Book1.1" and a second tab labeled  "Book2.1"; is that right?  If so, you will just need an Output tool for each section of the workflow; each will write to "WorkflowOutput.xlsx" but one will write to "Book1.1" and the other will write to "Book2.1".  You can replace "Sheet1" in the 'Write to File or Database' section with "Book1.1" or "Book2.1" (see attached screenshot).

Hope that helps!

[Meghnagupta]

@ed_hayter : I have two workflow, consider like I have two output which i want in same sheet but different worksheet on excel.

but the below workflow is not working the way I wanted 

[ed_hayter]

If you want them on the same excel sheet then making them reporting tables and then unioning them and rendering them as an excel file should work. My workflow above should achieve that for you.

[binu_acs]

@Meghnagupta One way of doing this