openpyxl.styles package

Subpackages

• openpyxl.styles.tests package
  • Submodules
    • openpyxl.styles.tests.conftest module
      • FormatRule()
      • datadir()
    • openpyxl.styles.tests.test_alignments module
      • Alignment()
      • test_alias()
      • test_default()
      • test_round_trip()
    • openpyxl.styles.tests.test_borders module
      • Border()
      • Side()
      • TestBorder
    • openpyxl.styles.tests.test_cell_style module
      • CellStyle()
      • CellStyleList()
      • StyleArray()
      • TestCellStyle
      • TestCellStyleList
      • TestStyleArray
    • openpyxl.styles.tests.test_colors module
      • ColorList()
      • TestColor
      • TestColorList
      • test_argb()
      • test_color_descriptor()
    • openpyxl.styles.tests.test_differential module
      • DifferentialStyle()
      • DifferentialStyleList()
      • TestDifferentialStyleList
      • test_parse()
      • test_serialise()
    • openpyxl.styles.tests.test_fills module
      • GradientFill()
      • PatternFill()
      • Stop()
      • TestGradientFill
      • TestPatternFill
      • TestStop
      • test_create_empty_fill()
      • test_read_fills()
    • openpyxl.styles.tests.test_fonts module
      • Font()
      • TestFont
    • openpyxl.styles.tests.test_named_style module
      • NamedStyle()
      • NamedStyleList()
      • TestNamedCellStyle
      • TestNamedCellStyleList
      • TestNamedStyle
      • TestNamedStyleList
    • openpyxl.styles.tests.test_number_style module
      • test_builtin_format()
      • test_datetime()
      • test_is_date_format()
      • test_is_timedelta_format()
      • test_number_descriptor()
      • test_strip_quotes()
    • openpyxl.styles.tests.test_protection module
      • Protection()
      • test_default()
      • test_round_trip()
    • openpyxl.styles.tests.test_proxy module
      • dummy_object()
      • proxy()
      • test_add()
      • test_copy()
      • test_ctor()
      • test_non_writable()
      • test_repr()
    • openpyxl.styles.tests.test_styleable module
      • StyleableObject()
      • TestNamedStyle
      • Workbook()
      • Worksheet()
      • test_descriptor()
      • test_has_style()
    • openpyxl.styles.tests.test_stylesheet module
      • Stylesheet()
      • TestStylesheet
      • test_no_default_style()
      • test_no_styles()
      • test_no_stylesheet()
      • test_simple_styles()
      • test_write_worksheet()
    • openpyxl.styles.tests.test_table module
      • TableStyle()
      • TableStyleElement()
      • TableStyleList()
      • TestTableStyle
      • TestTableStyleElement
      • TestTableStyleList

Submodules

• openpyxl.styles.alignment module
  • Alignment
    • Alignment.horizontal
    • Alignment.indent
    • Alignment.justifyLastLine
    • Alignment.readingOrder
    • Alignment.relativeIndent
    • Alignment.shrinkToFit
    • Alignment.shrink_to_fit
    • Alignment.tagname
    • Alignment.textRotation
    • Alignment.text_rotation
    • Alignment.vertical
    • Alignment.wrapText
    • Alignment.wrap_text
• openpyxl.styles.borders module
  • Border
    • Border.bottom
    • Border.diagonal
    • Border.diagonalDown
    • Border.diagonalUp
    • Border.end
    • Border.horizontal
    • Border.left
    • Border.outline
    • Border.right
    • Border.start
    • Border.tagname
    • Border.top
    • Border.vertical
  • Side
    • Side.border_style
    • Side.color
    • Side.style
• openpyxl.styles.builtins module
• openpyxl.styles.cell_style module
  • ArrayDescriptor
  • CellStyle
    • CellStyle.alignment
    • CellStyle.applyAlignment
    • CellStyle.applyBorder
    • CellStyle.applyFill
    • CellStyle.applyFont
    • CellStyle.applyNumberFormat
    • CellStyle.applyProtection
    • CellStyle.borderId
    • CellStyle.extLst
    • CellStyle.fillId
    • CellStyle.fontId
    • CellStyle.from_array()
    • CellStyle.numFmtId
    • CellStyle.pivotButton
    • CellStyle.protection
    • CellStyle.quotePrefix
    • CellStyle.tagname
    • CellStyle.to_array()
    • CellStyle.xfId
  • CellStyleList
    • CellStyleList.alignment
    • CellStyleList.count
    • CellStyleList.protection
    • CellStyleList.tagname
    • CellStyleList.xf
  • StyleArray
    • StyleArray.alignmentId
    • StyleArray.borderId
    • StyleArray.fillId
    • StyleArray.fontId
    • StyleArray.numFmtId
    • StyleArray.pivotButton
    • StyleArray.protectionId
    • StyleArray.quotePrefix
    • StyleArray.tagname
    • StyleArray.xfId
• openpyxl.styles.colors module
  • Color
    • Color.auto
    • Color.index
    • Color.indexed
    • Color.rgb
    • Color.tagname
    • Color.theme
    • Color.tint
    • Color.type
    • Color.value
  • ColorDescriptor
    • ColorDescriptor.expected_type
  • ColorList
    • ColorList.index
    • ColorList.indexedColors
    • ColorList.mruColors
    • ColorList.tagname
  • RGB
    • RGB.expected_type
  • RgbColor
    • RgbColor.rgb
    • RgbColor.tagname
• openpyxl.styles.differential module
  • DifferentialStyle
    • DifferentialStyle.alignment
    • DifferentialStyle.border
    • DifferentialStyle.fill
    • DifferentialStyle.font
    • DifferentialStyle.numFmt
    • DifferentialStyle.protection
    • DifferentialStyle.tagname
  • DifferentialStyleList
    • DifferentialStyleList.add()
    • DifferentialStyleList.append()
    • DifferentialStyleList.count
    • DifferentialStyleList.dxf
    • DifferentialStyleList.styles
    • DifferentialStyleList.tagname
• openpyxl.styles.fills module
  • Fill
    • Fill.from_tree()
    • Fill.tagname
  • GradientFill
    • GradientFill.bottom
    • GradientFill.degree
    • GradientFill.fill_type
    • GradientFill.left
    • GradientFill.right
    • GradientFill.stop
    • GradientFill.tagname
    • GradientFill.to_tree()
    • GradientFill.top
    • GradientFill.type
  • PatternFill
    • PatternFill.bgColor
    • PatternFill.end_color
    • PatternFill.fgColor
    • PatternFill.fill_type
    • PatternFill.patternType
    • PatternFill.start_color
    • PatternFill.tagname
    • PatternFill.to_tree()
  • Stop
    • Stop.color
    • Stop.position
    • Stop.tagname
  • StopList
    • StopList.expected_type
• openpyxl.styles.fonts module
  • Font
    • Font.UNDERLINE_DOUBLE
    • Font.UNDERLINE_DOUBLE_ACCOUNTING
    • Font.UNDERLINE_SINGLE
    • Font.UNDERLINE_SINGLE_ACCOUNTING
    • Font.b
    • Font.bold
    • Font.charset
    • Font.color
    • Font.condense
    • Font.extend
    • Font.family
    • Font.from_tree()
    • Font.i
    • Font.italic
    • Font.name
    • Font.outline
    • Font.scheme
    • Font.shadow
    • Font.size
    • Font.strike
    • Font.strikethrough
    • Font.sz
    • Font.tagname
    • Font.u
    • Font.underline
    • Font.vertAlign
• openpyxl.styles.named_styles module
  • NamedStyle
    • NamedStyle.alignment
    • NamedStyle.as_name()
    • NamedStyle.as_tuple()
    • NamedStyle.as_xf()
    • NamedStyle.bind()
    • NamedStyle.border
    • NamedStyle.builtinId
    • NamedStyle.fill
    • NamedStyle.font
    • NamedStyle.hidden
    • NamedStyle.name
    • NamedStyle.number_format
    • NamedStyle.protection
    • NamedStyle.xfId
  • NamedStyleList
    • NamedStyleList.append()
    • NamedStyleList.names
• openpyxl.styles.numbers module
  • NumberFormat
    • NumberFormat.formatCode
    • NumberFormat.numFmtId
  • NumberFormatDescriptor
  • NumberFormatList
    • NumberFormatList.count
    • NumberFormatList.numFmt
  • builtin_format_code()
  • builtin_format_id()
  • is_builtin()
  • is_date_format()
  • is_datetime()
  • is_timedelta_format()
• openpyxl.styles.protection module
  • Protection
    • Protection.hidden
    • Protection.locked
    • Protection.tagname
• openpyxl.styles.proxy module
  • StyleProxy
    • StyleProxy.copy()
• openpyxl.styles.styleable module
  • NamedStyleDescriptor
    • NamedStyleDescriptor.collection
    • NamedStyleDescriptor.key
  • NumberFormatDescriptor
    • NumberFormatDescriptor.collection
    • NumberFormatDescriptor.key
  • StyleArrayDescriptor
  • StyleDescriptor
  • StyleableObject
    • StyleableObject.alignment
    • StyleableObject.border
    • StyleableObject.fill
    • StyleableObject.font
    • StyleableObject.has_style
    • StyleableObject.number_format
    • StyleableObject.parent
    • StyleableObject.pivotButton
    • StyleableObject.protection
    • StyleableObject.quotePrefix
    • StyleableObject.style
    • StyleableObject.style_id
• openpyxl.styles.stylesheet module
  • Stylesheet
    • Stylesheet.borders
    • Stylesheet.cellStyleXfs
    • Stylesheet.cellStyles
    • Stylesheet.cellXfs
    • Stylesheet.colors
    • Stylesheet.custom_formats
    • Stylesheet.dxfs
    • Stylesheet.extLst
    • Stylesheet.fills
    • Stylesheet.fonts
    • Stylesheet.from_tree()
    • Stylesheet.numFmts
    • Stylesheet.tableStyles
    • Stylesheet.tagname
    • Stylesheet.to_tree()
  • apply_stylesheet()
  • write_stylesheet()
• openpyxl.styles.table module
  • TableStyle
    • TableStyle.count
    • TableStyle.name
    • TableStyle.pivot
    • TableStyle.table
    • TableStyle.tableStyleElement
    • TableStyle.tagname
  • TableStyleElement
    • TableStyleElement.dxfId
    • TableStyleElement.size
    • TableStyleElement.tagname
    • TableStyleElement.type
  • TableStyleList
    • TableStyleList.count
    • TableStyleList.defaultPivotStyle
    • TableStyleList.defaultTableStyle
    • TableStyleList.tableStyle
    • TableStyleList.tagname