Module ImportFrom alias ImportFrom alias alias ImportFrom alias alias ImportFrom alias alias alias alias alias alias ImportFrom alias alias ImportFrom alias ClassDef bases NameLoad NameLoad body Expr Str Assign NameStore TupleLoad Str Str Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad Str Assign NameStore Call NameLoad FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad body Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr keyword NameLoad keyword 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 For NameStore AttributeLoad NameLoad attr body Assign NameStore Call NameLoad NameLoad NameLoad If NameLoad body Expr Yield TupleLoad NameLoad Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return UnaryOpNot AttributeLoad NameLoad attr decorator_list NameLoad Call NameLoad Str decorator_list ClassDef bases NameLoad body Expr Str Assign NameStore BinOpAdd AttributeLoad NameLoad attr TupleLoad Str Str Str Str Assign NameStore Call NameLoad Str Assign NameStore Call NameLoad Str Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults Num NameLoad NameLoad NameLoad NameLoad NameLoad Num NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad kwarg body If CompareIsNot NameLoad NameLoad body Assign NameStore NameLoad If CompareIsNot NameLoad NameLoad body Assign NameStore NameLoad Assign AttributeStore NameLoad attr NameLoad If CompareIsNot NameLoad NameLoad body Assign NameStore UnaryOpNot NameLoad If CompareIsNot NameLoad NameLoad body Assign NameStore NameLoad Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam defaults body Expr Str Return CompareIsNot AttributeLoad NameLoad attr NameLoad decorator_list NameLoad decorator_list ClassDef bases NameLoad body Expr Str Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword NameLoad Assign NameStore Call NameLoad Assign NameStore BinOpAdd AttributeLoad NameLoad attr TupleLoad Str Str Str Str Str Str FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults Str NameLoad NameLoad NameLoad Num NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad If CompareIsNot NameLoad NameLoad body Assign NameStore UnaryOpNot NameLoad If CompareIsNot NameLoad NameLoad body Assign NameStore NameLoad Assign AttributeStore NameLoad attr NameLoad If CompareIsNot NameLoad NameLoad body Assign NameStore NameLoad Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Return CompareIsNot AttributeLoad NameLoad attr NameLoad decorator_list NameLoad FunctionDef arguments args NameParam defaults body For NameStore AttributeLoad NameLoad attr body If CompareEq NameLoad Str body Assign NameStore AttributeLoad NameLoad attr orelse Assign NameStore Call NameLoad NameLoad NameLoad If NameLoad body Expr Yield TupleLoad NameLoad Call NameLoad NameLoad decorator_list decorator_list ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam NameParam NameParam defaults Str NameLoad body Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad Num NameLoad body Expr Str If CompareIs NameLoad NameLoad body Assign NameStore NameLoad Assign NameStore SubscriptLoad NameLoad Index NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign NameStore SubscriptLoad Call NameLoad NameLoad NameLoad Slice Num For NameStore NameLoad body If CompareIn NameLoad NameLoad body Delete SubscriptDel NameLoad Index NameLoad Assign TupleStore AttributeStore NameLoad attr AttributeStore NameLoad attr Call NameLoad NameLoad TupleLoad NameLoad NameLoad decorator_list decorator_list
N/A __future__ absolute_import openpyxl.compat safe_string deprecated openpyxl.utils get_column_interval column_index_from_string openpyxl.descriptors Integer Float Bool Strict String Alias openpyxl.styles.styleable StyleableObject StyleArray openpyxl.utils.bound_dictionary BoundDictionary Dimension N/A Strict StyleableObject N/A N/A Information about the display properties of a row or column. N/A __fields__ N/A hidden outlineLevel collapsed N/A index N/A Integer N/A hidden N/A Bool N/A outlineLevel N/A Integer allow_none True N/A outline_level N/A Alias outlineLevel N/A collapsed N/A Bool __init__ N/A N/A self index hidden outlineLevel collapsed worksheet visible style N/A True None N/A N/A N/A N/A N/A super Dimension self __init__ sheet worksheet style_array style N/A N/A self index index N/A N/A self hidden hidden N/A N/A self outlineLevel outlineLevel N/A N/A self collapsed collapsed N/A __iter__ N/A N/A self N/A N/A N/A key N/A self __fields__ N/A N/A value N/A getattr self key N/A value N/A N/A N/A N/A key N/A safe_string value N/A visible N/A N/A self N/A N/A N/A N/A N/A self hidden N/A property N/A deprecated Use `hidden` instead N/A RowDimension N/A Dimension N/A N/A Information about the display properties of a row. N/A __fields__ N/A N/A Dimension __fields__ N/A ht customFormat customHeight s N/A r N/A Alias index N/A s N/A Alias style_id N/A ht N/A Float allow_none True N/A height N/A Alias ht N/A thickBot N/A Bool N/A thickTop N/A Bool __init__ N/A N/A self worksheet index ht customHeight s customFormat hidden outlineLevel outline_level collapsed visible height r spans thickBot thickTop N/A 0 None None None None False 0 None False None None None None None None kw N/A N/A N/A r None N/A N/A index r N/A N/A height None N/A N/A ht height N/A N/A self ht ht N/A N/A visible None N/A N/A hidden N/A visible N/A N/A outline_level None N/A N/A outlineLevel outlineLevel N/A N/A N/A N/A super RowDimension self __init__ index hidden outlineLevel collapsed worksheet style s N/A customFormat N/A N/A self N/A N/A N/A Always true if there is a style for the row N/A N/A self has_style N/A property customHeight N/A N/A self N/A N/A N/A Always true if there is a height for the row N/A N/A N/A self ht None N/A property N/A ColumnDimension N/A Dimension N/A N/A Information about the display properties of a column. N/A width N/A Float allow_none True N/A bestFit N/A Bool N/A auto_size N/A Alias bestFit N/A index N/A String N/A min N/A Integer allow_none True N/A max N/A Integer allow_none True N/A collapsed N/A Bool N/A __fields__ N/A N/A Dimension __fields__ N/A width bestFit customWidth style min max __init__ N/A N/A self worksheet index width bestFit hidden outlineLevel outline_level collapsed style min max customWidth visible auto_size N/A A None False False 0 None False None None None False None None N/A N/A N/A self width width N/A N/A self min min N/A N/A self max max N/A N/A visible None N/A N/A hidden N/A visible N/A N/A auto_size None N/A N/A bestFit auto_size N/A N/A self bestFit bestFit N/A N/A outline_level None N/A N/A outlineLevel outline_level N/A N/A self collapsed collapsed N/A N/A N/A N/A super ColumnDimension self __init__ index hidden outlineLevel collapsed worksheet style style N/A customWidth N/A N/A self N/A N/A N/A Always true if there is a width for the column N/A N/A N/A self width None N/A property __iter__ N/A N/A self N/A N/A N/A key N/A self __fields__ N/A N/A N/A key style N/A N/A value N/A self style_id N/A N/A value N/A getattr self key N/A value N/A N/A N/A N/A key N/A safe_string value N/A N/A DimensionHolder N/A BoundDictionary N/A N/A 
    Allow columns to be grouped
     __init__ N/A N/A self worksheet reference default_factory N/A index None N/A N/A N/A self worksheet worksheet N/A N/A N/A N/A super DimensionHolder self __init__ reference default_factory N/A group N/A N/A self start end outline_level hidden N/A None 1 False N/A N/A allow grouping a range of consecutive columns together

        :param start: first column to be grouped (mandatory)
        :param end: last column to be grouped (optional, default to start)
        :param outline_level: outline level
        :param hidden: should the group be hidden on workbook open or not
         N/A N/A end None N/A N/A end start N/A new_dim N/A self N/A start N/A N/A new_dim outline_level outline_level N/A N/A new_dim hidden hidden N/A work_sequence N/A N/A get_column_interval start end N/A 1 N/A column_letter work_sequence N/A N/A N/A column_letter self N/A N/A N/A self N/A column_letter N/A N/A N/A new_dim min N/A new_dim max N/A map column_index_from_string N/A start end N/A N/A