Menu
I have a Python program that creates an excel sheet, but I have been asked by one of the users to modify it so that if he hits print it will print out to landscape mode, without him having to specify this. Is there some way to set the sheet to landscape in XLWT or some similar Python library for excel?
Thank you.
235
On the Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape.
Thus, you can set some as landscape and some as portrait and later just print the whole workbook. Excel keeps track and orients the printing properly for each worksheet. Here's the easy way to set orientation for a group of worksheets: Click the tab of the first worksheet.
With XLWT, I believe it's as easy as:
worksheetObject.portrait = False
I think Mark's answer was valid with previous versions of xlwt, it does not work as of version 0.7.5. The following works instead:
sheet.set_portrait(False)
Notice it is now a property of the sheet, not of the whole workbook.
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
