别搜了 openpyxl打印设置 中文最全

整理了个把小时

每次设置个打印格式来回找累死了,干脆搞出来分享给大家

转载注明出处

import openpyxl as pyxlnfrom openpyxl.worksheet.pagebreak import Breaknwb=pyxl.Workbook()nws=wb.activen#源码worksheet->worksheet->Worksheet()n#设置打印区域nws.print_area = 'A1:F10'nn#设置打印标题和打印列nws.print_title_rows='1:1'nws.print_title_cols="A:B"nprint(ws.print_titles)#只读属性nn#冻结窗格 冻结第一行第一列nws.freeze_panes = 'B2'nn#未测试 分页符 适用于openpyxl 3.0.4以后nrow_number=20 #需要插入分页符的行号nnext_page_horizon, next_page_vertical = ws.page_breaks # 返回2个变量 后期版本可能取消nnext_page_horizon.append(Break(row_number)) # 通过help可以查到append属性nn#设置打印A3横向nws.set_printer_settings(ws.PAPERSIZE_A3,ws.ORIENTATION_LANDSCAPE)n"""n #所有默认设置如下 worksheet 类属性n # Paper sizen PAPERSIZE_LETTER = '1'n PAPERSIZE_LETTER_SMALL = '2'n PAPERSIZE_TABLOID = '3'n PAPERSIZE_LEDGER = '4'n PAPERSIZE_LEGAL = '5'n PAPERSIZE_STATEMENT = '6'n PAPERSIZE_EXECUTIVE = '7'n PAPERSIZE_A3 = '8'n PAPERSIZE_A4 = '9'n PAPERSIZE_A4_SMALL = '10'n PAPERSIZE_A5 = '11'nn # Page orientationn ORIENTATION_PORTRAIT = 'portrait' #纵向n ORIENTATION_LANDSCAPE = 'landscape' #横向n"""nn#参照源码 worksheet->page->PrintPageSetup()n#设置缩放所有列到一页,直接设置fitToWidth=True无效,需采用如下方法n#所有列设置为一页 逆向思维,先缩放到页面 然后适合高度改为FLASEnws.sheet_properties.pageSetUpPr.fitToPage = True#此行必须设置nws.page_setup.fitToHeight = Falsen#其他打印设置nws.page_setup.orientation = "landscape"#设置打印方向 values=("default", "portrait", "landscape")nws.page_setup.paperSize = "8" #纸张尺寸参见上表nws.page_setup.firstPageNumber = 1#页码起始页nws.page_setup.useFirstPageNumber = True #使用起始页 不知道啥意思 未测试nws.page_setup.paperHeight = 297#纸张高度nws.page_setup.paperWidth = 410#纸张宽度nws.page_setup.pageOrder = "downThenOver"##页面设置->工作表->打印顺序values=("downThenOver", "overThenDown") 先列后行,先行后列 nws.page_setup.usePrinterDefaults = True #使用默认打印机nws.page_setup.blackAndWhite = True #页面设置->工作表->单色模式nws.page_setup.draft = True #页面设置->工作表->草稿质量nws.page_setup.cellComments = True #页面设置->工作表->批注和注释values=("asDisplayed", "atEnd") 如工作表所示,工作表末尾nws.page_setup.errors = True #页面设置->工作表->错误单元格打印为values=("displayed", "blank", "dash", "NA") 显示值,空白,--,"#N/A"nws.page_setup.horizontalDpi = True #页面设置->工作表->打印质量nws.page_setup.verticalDpi = True #页面设置->工作表->打印质量nws.page_setup.copies = True #文件->打印->份数 未测试nnn#参照源码worksheet->header_footer->_HeaderFooterPart()n#设置页眉 左中右 left center rightnws.oddHeader.center.text = "XXX" #文本nws.oddHeader.center.size = 24 #字号nws.oddHeader.center.font = "微软雅黑" #字体nws.oddHeader.center.color = "000000" #16进制RGB颜色 参照PSn#设置页脚nws.oddFooter.center.text = "第&[Page]页 共&[Pages]页"nws.oddFooter.center.size = 12nws.oddFooter.center.font = "微软雅黑"nws.oddFooter.center.color = "000000"nn#其他页眉页脚设置 未测试nws.differentOddEven=True #页面设置->页眉/页脚->奇偶页不同nws.differentFirst=True #页面设置->页眉/页脚->首页不同nws.scaleWithDoc=True #页面设置->页眉/页脚->随文档自动缩放nws.alignWithMargins=True #页面设置->页眉/页脚->与页边距对齐nws.evenHeader.center.text="XXX" #偶数页眉nws.evenFooter.center.text="XXX" #偶数页脚nws.firstHeader.center.text="XXX" #奇数页眉nws.firstFooter.center.text="XXX" #奇数页脚nn# 页眉页脚自动文本n"""nIndividual left/center/right header/footer partnnDo not use directly.nnHeader & Footer ampersand codes:nn* &A Inserts the worksheet name #工作表名n* &B Toggles bold #加粗n* &D or &[Date] Inserts the current date #日期n* &E Toggles double-underline #双下划线n* &F or &[File] Inserts the workbook name #文件名n* &I Toggles italic #斜体n* &N or &[Pages] Inserts the total page count #总页码n* &S Toggles strikethrough #删除线n* &T Inserts the current time #当前时间n* &[Tab] Inserts the worksheet name #当前工作表名n* &U Toggles underline #下划线n* &X Toggles superscript #上标n* &Y Toggles subscript #下标n* &P or &[Page] Inserts the current page number #当前页码n* &P+n Inserts the page number incremented by n #当前页码+nn* &P-n Inserts the page number decremented by n #当前页码-nn* &[Path] Inserts the workbook path #当前文件路径n* && Escapes the ampersand character #转义字符和符号n* &"fontname" Selects the named font #选择字体名n* &nn Selects the specified 2-digit font point size #选择指定的两位字体点大小?nnColours are in RGB Hex #颜色是十六进制RGBn"""nn#源码worksheet->page->PrintOptions()n#页面设置->页边距->居中方式 水平/垂直nws.print_options.horizontalCentered=Truenws.print_options.verticalCentered=Truen#未测试 nws.print_options.headings=True #页面设置->工作表->行和列标题nws.print_options.gridLines=True #页面设置->工作表->网格线nws.print_options.gridLinesSet=True #猜不出来什么意思nnn#源码worksheet->page->PageMargins()n#未测试 页边距nws.page_margins.left=0.75 #左nws.page_margins.right=0.75 #右nws.page_margins.top=1 #上nws.page_margins.bottom=1 #下nws.page_margins.header=0.5 #页眉nws.page_margins.footer=0.5 #页脚