openpyxl.worksheet.page模块¶
- class openpyxl.worksheet.page.PageMargins(left=0.75, right=0.75, top=1, bottom=1, header=0.5, footer=0.5)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
有关视图/打印布局的页边距的信息。标准值(英寸)左,右=0.75上,下=1页眉,页脚=0.5
- bottom¶
值的类型必须小于class“float”>
值的类型必须小于class“float”>
- header¶
值的类型必须小于class“float”>
- left¶
值的类型必须小于class“float”>
- right¶
值的类型必须小于class“float”>
- tagname = 'pageMargins'¶
- top¶
值的类型必须小于class“float”>
- class openpyxl.worksheet.page.PrintOptions(horizontalCentered=None, verticalCentered=None, headings=None, gridLines=None, gridLinesSet=None)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
工作表打印选项
- gridLines¶
值的类型必须小于class'bool'>
- gridLinesSet¶
值的类型必须小于class'bool'>
- headings¶
值的类型必须小于class'bool'>
- horizontalCentered¶
值的类型必须小于class'bool'>
- tagname = 'printOptions'¶
- verticalCentered¶
值的类型必须小于class'bool'>
- class openpyxl.worksheet.page.PrintPageSetup(worksheet=None, orientation=None, paperSize=None, scale=None, fitToHeight=None, fitToWidth=None, firstPageNumber=None, useFirstPageNumber=None, paperHeight=None, paperWidth=None, pageOrder=None, usePrinterDefaults=None, blackAndWhite=None, draft=None, cellComments=None, errors=None, horizontalDpi=None, verticalDpi=None, copies=None, id=None)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
工作表打印页设置
- property autoPageBreaks¶
- blackAndWhite¶
值的类型必须小于class'bool'>
- cellComments¶
Value must be one of {'atEnd', 'asDisplayed'}
- copies¶
值的类型必须小于class“int”>
- draft¶
值的类型必须小于class'bool'>
- errors¶
Value must be one of {'displayed', 'dash', 'blank', 'NA'}
- firstPageNumber¶
值的类型必须小于class“int”>
- fitToHeight¶
值的类型必须小于class“int”>
- property fitToPage¶
- fitToWidth¶
值的类型必须小于class“int”>
- horizontalDpi¶
值的类型必须小于class“int”>
- id¶
值的类型必须小于class'str'>
- orientation¶
Value must be one of {'portrait', 'default', 'landscape'}
- pageOrder¶
Value must be one of {'downThenOver', 'overThenDown'}
- paperHeight¶
- paperSize¶
值的类型必须小于class“int”>
- paperWidth¶
- scale¶
值的类型必须小于class“int”>
- property sheet_properties¶
代理财产
- tagname = 'pageSetup'¶
- useFirstPageNumber¶
值的类型必须小于class'bool'>
- usePrinterDefaults¶
值的类型必须小于class'bool'>
- verticalDpi¶
值的类型必须小于class“int”>