Problem
FitToPagesTall and FitToPagesWide settings do not take effect unless Zoom is explicitly set to false.
Solution
FitToPagesTall, FitToPagesWide and Zoom are properties of the PageSetup object of the ExcelWriter Application object.
The Page Setup dialog in Microsoft Excel allows you to select one of the following two options:
- Adjusting the worksheet so that it fits to the dimension of “x” number of pages width-wise and/or length-wise.
- Adjusting the worksheet so that it prints to a certain percentage of the original size, ranging between 10 and 400 percent.
The equivalent properties in ExcelWriter are:
- FitToPagesWide and/or FitToPagesTall.
- Zoom
The Zoom property has a default value of “True” and “100” percent. This means that even if the Zoom is not explicitly set in your code, these values will be assumed. Any values provided for FitToPagesTall or FitToPagesWide will be ignored. If you want to use these properties, you must explicitly change the value of Zoom to “False”:
worksheet.PageSetup.Zoom = false; worksheet.PageSetup.FitToPagesTall = 2; worksheet.PageSetup.FitToPagesWide = 2;