Hi, I have 2 Outputs that should be in same file but in different sheets. I'm unable to create new sheet for 2nd output in the same file using Render tool. How can I do that using render tool?
The Solution is Very easy refer Image
For reference Workflow attached,
You can also refer documentation here : Render Tool Documentation
Dear @Ayaanarjun-5885
As per your requirement I have tried the same thing,
Please confirm have you select Proper RENDER TOOL configuration mark in yellow colour ?
Under Report Data >> Seperator >> Insert section Break Between Records.
In my case I got this output;
Sheet 2 :
Hi, I have tried above, I have got 2 outputs in same file, whereas I want the data in different sheets of same file.
Hello.. I have tried it again. It worked. Thank you so much.
If you want multiple sheets within the same output file, you need a separate Output Tool per sheet. Then your file path will be the same for each Output tool and you will have to change the name of the sheet which is found after the 3 pipes. Example your output path : \\ ...........Output.xlsx|||sheet1. After that copy the same path to the next Output tool and only change the name at the end of the path |||sheet2.
Also, please configure the Output Tool option 3 Output Options to "Overwrite Sheet or Range"
