Hi,
I need to output a table and chart from reporting tools to the same excel workbook on different sheets. Is there a way to do this through the rendering or output tools? Or another tool?
@ftorruella1 wrote: ...can i have the render tool render to different sheets based on grouping on the same excel file?
...can i have the render tool render to different sheets based on grouping on the same excel file?
That's what that workflow shows how to do. If there's something specific you're stuck on, post a sample workflow and I'm sure we can get it worked out for you.
There is!
The trick is to use a Layout tool to set up before the Render tool. The only problem with naming sheets is that you cannot control the order of sheets -- they will be output in alphabetic order no matter the input order. I suggest keeping this in mind while naming your sheets if order is a concern. For example: "1-Summary","2-2018 Results", "3-2017 Results","4-Appendix", etc.
In the Layout tool:
- Set the mode to "Each Group of Records" and select your sheet name field to group by
- Configure the orientation to "Vertical with Section Breaks". The section breaks are used as sheet breaks when outputting to an Excel file.
- Set the sheet name field in the "Section Name" field that appears at the bottom.
In the Render tool:
- Set the separator to "Insert Section Breaks Between Records" to use those sheet breaks you set in the Layout tool.
Check out the attached example and let me know if you have any questions.
Thanks! The union is what i was missing, but can i have the render tool render to different sheets based on grouping on the same excel file?
