How to handle different Report Style for different sheets in same excel output

[sabihaS]

Hello Everyone,

I am trying to render 5 sheets into a single excel sheet with specific sheet order and report style, for one specific sheet paper size needs to be as 'Custom Size'
to handle columns width properly and for rest 'A3 paper size' is working perfectly fine. I tried few things but I am not able to able to handle both report style together.
Please can some one advise?

Thank you.

[binuacs]

@sabihaS I dot think you can apply different report style on the same render tool, im just wondering how are you adjusting custom size in one sheet and A3 size in another sheets, usually render tool only support one paper size on all the sheets. Can you post your render tool settings screen shot here

[sabihaS]

Thank you @binuacs for your reply. Sorry if I was not very clear in my query. Actually I am not able to achieve this and I was hoping someone can help me but from your reply I understand this is not possible. I have one sheet whose columns width looks funny while loading in a excel(attached screenshot).

[binuacs]

@sabihaS you need to change the render tool paper size to custom and increase the size (may be 50x50 or more) to change the width

[sabihaS]

@binuacs Thanks for the advice. However, I have 4 more sheets that will be render in the same excel file and if I choose i.e. 50x50 or more it will make other sheets look funny. So I was hoping if there is way e.g(screenshot attached).: if True case can be render in excel whose size will be 50x50 and false cases will be render in same excel but with A3 size?

[binuacs]

@sabihaS are you trying to write same excel file with different sheets using 2 render tool?

[sabihaS]

@binuacs yes, that's exactly what I am trying to do however I am not sure if that is possible or not.. I tried block until done to see if that helps but no luck.

[binuacs · Accepted solution]

@sabihaS that is not possible with render tool, you should use one render tool for creating one excel with different tabs, also the same paper size will be applied to all the tabs, you cannot specify different paper size for different tabs.