Module ImportFrom alias ImportFrom alias ImportFrom alias alias alias alias alias ImportFrom alias ImportFrom alias ImportFrom alias alias ImportFrom alias ClassDef bases NameLoad body Expr Str Assign NameStore Str Assign NameStore Call NameLoad keyword TupleLoad Str Str Str Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword TupleLoad Str Str Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword TupleLoad Str Str Assign NameStore Call NameLoad keyword TupleLoad Str Str Str Str Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Pass decorator_list Call NameLoad Str FunctionDef arguments args NameParam defaults body Pass decorator_list Call NameLoad Str FunctionDef arguments args NameParam defaults body Pass decorator_list Call NameLoad Str FunctionDef arguments args NameParam defaults body Pass decorator_list Call NameLoad Str FunctionDef arguments args NameParam defaults body Expr Str Return AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr decorator_list NameLoad FunctionDef arguments args NameParam defaults body Return AttributeLoad AttributeLoad NameLoad attr attr decorator_list NameLoad FunctionDef arguments args NameParam NameParam defaults body Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam defaults body Return AttributeLoad AttributeLoad NameLoad attr attr decorator_list NameLoad FunctionDef arguments args NameParam NameParam defaults body Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore BinOpMod Str NameLoad If CompareIn NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Return Call NameLoad NameLoad decorator_list NameLoad FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad NameLoad If CompareIn Str NameLoad body Assign SubscriptStore NameLoad Index BinOpMod Str NameLoad SubscriptLoad NameLoad Index Str Delete SubscriptDel NameLoad Index Str Return Call NameLoad AttributeLoad NameLoad attr NameLoad decorator_list decorator_list ClassDef bases NameLoad body Expr Str Assign NameStore Str Assign NameStore BinOpAdd BinOpMod Str NameLoad NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad NameLoad body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list decorator_list ClassDef bases NameLoad body Expr Str Assign NameStore Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad Assign NameStore Call NameLoad Assign NameStore Call NameLoad Assign NameStore Call NameLoad Assign NameStore Call NameLoad FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults Num Num Num Num Num Num body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list decorator_list
N/A __future__ absolute_import openpyxl.descriptors.serialisable Serialisable openpyxl.descriptors Float Bool Integer String NoneSet openpyxl.descriptors.excel UniversalMeasure openpyxl.xml.functions Element openpyxl.xml.constants SHEET_MAIN_NS REL_NS openpyxl.compat deprecated PrintPageSetup N/A Serialisable N/A N/A  Worksheet print page setup  N/A tagname pageSetup N/A orientation N/A NoneSet values N/A default portrait landscape N/A paperSize N/A Integer allow_none True N/A scale N/A Integer allow_none True N/A fitToHeight N/A Integer allow_none True N/A fitToWidth N/A Integer allow_none True N/A firstPageNumber N/A Integer allow_none True N/A useFirstPageNumber N/A Bool allow_none True N/A paperHeight N/A UniversalMeasure allow_none True N/A paperWidth N/A UniversalMeasure allow_none True N/A pageOrder N/A NoneSet values N/A downThenOver overThenDown N/A usePrinterDefaults N/A Bool allow_none True N/A blackAndWhite N/A Bool allow_none True N/A draft N/A Bool allow_none True N/A cellComments N/A NoneSet values N/A asDisplayed atEnd N/A errors N/A NoneSet values N/A displayed blank dash NA N/A horizontalDpi N/A Integer allow_none True N/A verticalDpi N/A Integer allow_none True N/A copies N/A Integer allow_none True N/A id N/A String allow_none True __init__ N/A N/A self worksheet orientation paperSize scale fitToHeight fitToWidth firstPageNumber useFirstPageNumber paperHeight paperWidth pageOrder usePrinterDefaults blackAndWhite draft cellComments errors horizontalDpi verticalDpi copies id N/A None None None None None None None None None None None None None None None None None None None None N/A N/A N/A self _parent worksheet N/A N/A self orientation orientation N/A N/A self paperSize paperSize N/A N/A self scale scale N/A N/A self fitToHeight fitToHeight N/A N/A self fitToWidth fitToWidth N/A N/A self firstPageNumber firstPageNumber N/A N/A self useFirstPageNumber useFirstPageNumber N/A N/A self paperHeight paperHeight N/A N/A self paperWidth paperWidth N/A N/A self pageOrder pageOrder N/A N/A self usePrinterDefaults usePrinterDefaults N/A N/A self blackAndWhite blackAndWhite N/A N/A self draft draft N/A N/A self cellComments cellComments N/A N/A self errors errors N/A N/A self horizontalDpi horizontalDpi N/A N/A self verticalDpi verticalDpi N/A N/A self copies copies N/A N/A self id id N/A setup N/A N/A self N/A N/A N/A N/A N/A deprecated this property does not exists anymore options N/A N/A self N/A N/A N/A N/A N/A deprecated this property does not exists anymore horizontalCentered N/A N/A self N/A N/A N/A N/A N/A deprecated this property has to be called via print_options verticalCentered N/A N/A self N/A N/A N/A N/A N/A deprecated this property has to be called via print_options sheet_properties N/A N/A self N/A N/A N/A 
        Proxy property
         N/A N/A N/A N/A self _parent sheet_properties pageSetUpPr N/A property fitToPage N/A N/A self N/A N/A N/A N/A N/A self sheet_properties fitToPage N/A property fitToPage N/A N/A self value N/A N/A N/A N/A N/A self sheet_properties fitToPage value N/A N/A fitToPage setter autoPageBreaks N/A N/A self N/A N/A N/A N/A N/A self sheet_properties autoPageBreaks N/A property autoPageBreaks N/A N/A self value N/A N/A N/A N/A N/A self sheet_properties autoPageBreaks value N/A N/A autoPageBreaks setter from_tree N/A N/A cls node N/A N/A N/A attrs N/A node attrib N/A id_key N/A {%s}id REL_NS N/A N/A id_key attrs N/A N/A N/A N/A attrs pop id_key N/A N/A cls attrs N/A classmethod to_tree N/A N/A self N/A N/A N/A attrs N/A dict self N/A N/A id attrs N/A N/A N/A attrs N/A N/A {%s}id REL_NS N/A attrs N/A id N/A N/A attrs N/A id N/A N/A Element N/A self tagname attrs N/A N/A PrintOptions N/A Serialisable N/A N/A  Worksheet print options  N/A tagname printOptions N/A tag N/A N/A {%s} SHEET_MAIN_NS tagname N/A horizontalCentered N/A Bool allow_none True N/A verticalCentered N/A Bool allow_none True N/A headings N/A Bool allow_none True N/A gridLines N/A Bool allow_none True N/A gridLinesSet N/A Bool allow_none True __init__ N/A N/A self horizontalCentered verticalCentered headings gridLines gridLinesSet N/A None None None None None N/A N/A N/A self horizontalCentered horizontalCentered N/A N/A self verticalCentered verticalCentered N/A N/A self headings headings N/A N/A self gridLines gridLines N/A N/A self gridLinesSet gridLinesSet N/A N/A PageMargins N/A Serialisable N/A N/A 
    Information about page margins for view/print layouts.
    Standard values (in inches)
    left, right = 0.75
    top, bottom = 1
    header, footer = 0.5
     N/A tagname pageMargins N/A left N/A Float N/A right N/A Float N/A top N/A Float N/A bottom N/A Float N/A header N/A Float N/A footer N/A Float __init__ N/A N/A self left right top bottom header footer N/A 0.75 0.75 1 1 0.5 0.5 N/A N/A N/A self left left N/A N/A self right right N/A N/A self top top N/A N/A self bottom bottom N/A N/A self header header N/A N/A self footer footer N/A N/A