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”>

footer

值的类型必须小于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”>

classmethod from_tree(node)[源代码]
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”>