I'm trying to write multiple sheets into a single Excel workbook using the Render tool. When the same paper size is applied to all sheets, those with fewer columns appear too wide and spacious, while others with more columns look well-balanced.
Is it possible to:
Use different Render tools for each sheet and still write them into one workbook?
Adjust paper size or scaling individually for each sheet?


Any alternative solutions or workarounds to handle this formatting issue are also appreciated.
Thanks