from openpyxl import load_workbook
def excel_print_setting(file=None):
wb = load_workbook(file)
ws = wb.active
ws.page_setup.scale = 80
wb.save(file)
if __name__ == '__main__':
excel_print_setting('./Demo.xlsx')
网上找了一下午这个属性设置...没找到..可能我方法有错误...
最后解压 ./xx.xlsx ,在xl/worksheets/sheet1.xml 的最下面找到:
...
<pageSetup orientation="landscape" paperSize="9" scale="100">
...
在openpyxl.worksheet.worksheet.py 中找到:
...
self.page_setup = PrintPageSetup(worksheet=self)
...
进入PrintPageSetup()看到 scale 把我高兴坏了~,查看下这个参数的属性:
# .\openpyxl\worksheet\page.py
# ...
# class PrintPageSetup(Serialisable):
scale = Integer(allow_none=True)
# ...
# .\openpyxl\descriptors\base.py
class Integer(Convertible):
expected_type = int
emmmm....
额,可能是我还没能理解openpyxl,哈哈,新手蛋子一枚, 不要见笑