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

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.

Workflow

Reporting

Accepted answers

binu_acs

@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.

All comments

binu_acs

@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 @binu_acs 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).

Screenshot.PNG

binu_acs

@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

@binu_acs 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?

Screenshot.PNG

binu_acs

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

sabihaS

@binu_acs 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.

Screenshot.PNG

binu_acs

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703