Using Built-in Styles

How to use Built-in Styles

The method Workbook.create_builtin_style and the enumeration BuiltinStyleType make it convenient to use built-in styles. Here is a list of all possible built-in styles:

  • TWENTY_PERCENT_ACCENT_1
  • TWENTY_PERCENT_ACCENT_2
  • TWENTY_PERCENT_ACCENT_3
  • TWENTY_PERCENT_ACCENT_4
  • TWENTY_PERCENT_ACCENT_5
  • TWENTY_PERCENT_ACCENT_6
  • FORTY_PERCENT_ACCENT_1
  • FORTY_PERCENT_ACCENT_2
  • FORTY_PERCENT_ACCENT_3
  • FORTY_PERCENT_ACCENT_4
  • FORTY_PERCENT_ACCENT_5
  • FORTY_PERCENT_ACCENT_6
  • SIXTY_PERCENT_ACCENT_1
  • SIXTY_PERCENT_ACCENT_2
  • SIXTY_PERCENT_ACCENT_3
  • SIXTY_PERCENT_ACCENT_4
  • SIXTY_PERCENT_ACCENT_5
  • SIXTY_PERCENT_ACCENT_6
  • ACCENT_1
  • ACCENT_2
  • ACCENT_3
  • ACCENT_4
  • ACCENT_5
  • ACCENT_6
  • BAD
  • CALCULATION
  • CHECK_CELL
  • COMMA
  • COMMA_1
  • CURRENCY
  • CURRENCY_1
  • EXPLANATORY_TEXT
  • GOOD
  • HEADER_1
  • HEADER_2
  • HEADER_3
  • HEADER_4
  • HYPERLINK
  • FOLLOWED_HYPERLINK
  • INPUT
  • LINKED_CELL
  • NEUTRAL
  • NORMAL
  • NOTE
  • OUTPUT
  • PERCENT
  • TITLE
  • TOTAL
  • WARNING_TEXT
  • ROW_LEVEL
  • COLUMN_LEVEL

Python code to use built-in styles