Merge 3 render outputs in 3 tabs of 1 excel sheet

[ShantanuDagar]

Hey Guys,

So I have 3 files which are getting created as part of 1 workflow. Formatting has been done on all 3 files through table and then render tool for output.

Is there any way to merge all 3 output files in 1 final excel file with 3 different worksheet tabs in the same workflow?

Also any way to change render file path?

[ShankerV · Accepted solution]

Hi @ShantanuDagar 

Answering Question 1:

Also any way to change render file path?

Instead of Temporary Excel 2007 Spreadsheet, you can use the Specific Output File.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @ShantanuDagar 

Answering Question 2:

You can output the 3 output into 3 different sheets in the same excel file.

Have created and attached a sample to help you.

You need to create a sheet name using formula tool, union all the 3 sheets and then use the Layout "vertical"

The below setting will help to create 3 different sheets.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShantanuDagar]

woah, thanks bro. Works brilliantly.