This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I entered this topic because I am looking for the solution for below issue.
I am using reporting tools (table, layout, render) to create an excel report with multiple worksheets.
My problem is that I have to set up one page size for all worksheets when using render tool.
One of my worksheets has 2 columns of data and the other one has 50 columns. When I set the size to fit all 50 columns it is much too wide for the sheet with 2 coulmns, as table width adjusts to page width.
The reason I was using both a Render tool and an output tool is because one chart I am exporting is about 7 inches wide; the other chart I am exporting is 60 inches wide. I did not want the 7 inch chart to be 60 inches wide - that is a lot of scrolling. With your solution I am exporting the 60 inch chart into a normal excel export (which usually requires expanding), and exporting my 7 inch chart with the render tool.
I get the same issue. The block holds the output function (seemingly) correctly but when i open the excel it say there is a problem with the data and recovers it. All my rendered tabs are correct but the output tab is there correctly named but now with no data in it.