Apply Sheet Name in the Render Tool

[KamenRider]

Hi,

I am having problem of providing a sheet name to a render tool and it gives me an of "invalid supported format" whenever I include it in the formula tool containing the destination of the file. Can someone to please help how to include "Page1" as its sheet name.

Here some screenshots for your reference.

 

 

 

Hoping to hear from someone.

Thanks,

Kamen

[KamenRider]

Hi @binuacs 

Thank you for this illustration. I am able to understand well although the structure of my workflow differs. I am able to apply your example to my workflow.

Kamen

[salimaelalouaji]

Hello, thanks for sharing.

What if we want to output multiple renders with different sheet names, but all within the same Excel file?

When using control containers, I end up with only one sheet in the final output file—the one from the last control container.

[apathetichell]

Go through the training --- it addresses this specific issue. You will need to use a union tool, and a layout tool  --- and then ONE render tool. ONE file. ONE render tool.