Setting styles in Openpyxl

by

As of openpyxl version 1.5.7, I have successfully applied the following worksheet style options…

from openpyxl.reader.excel import load_workbook
from openpyxl.workbook import Workbook
from openpyxl.styles import Color, Fill
from openpyxl.cell import Cell

# Load the workbook...
book = load_workbook('foo.xlsx')

# define ws here, in this case I pick the first worksheet in the workbook...
#    NOTE: openpyxl has other ways to select a specific worksheet (i.e. by name
#    via book.get_sheet_by_name('someWorksheetName'))
ws = book.worksheets[0]

## ws is a openpypxl worksheet object
_cell = ws.cell('C1')

# Font properties
_cell.style.font.color.index = Color.GREEN
_cell.style.font.name="Arial"
_cell.style.font.size = 8
_cell.style.font.bold = True
_cell.style.alignment.wrap_text = True

# Cell background color
_cell.style.fill.fill_type = Fill.FILL_SOLID
_cell.style.fill.start_color.index = Color.DARKRED

# You should only modify column dimensions after you have written a cell in 
#     the column. Perfect world: write column dimensions once per column
# 
ws.column_dimensions["C"].width = 60.0

FYI, you can find the names of the colors in openpyxl/style.py… I sometimes I patch in extra colors from the X11 color names

class Color(HashableObject):
    """Named colors for use in styles."""
    BLACK = 'FF000000'
    WHITE = 'FFFFFFFF'
    RED = 'FFFF0000'
    DARKRED = 'FF800000'
    BLUE = 'FF0000FF'
    DARKBLUE = 'FF000080'
    GREEN = 'FF00FF00'
    DARKGREEN = 'FF008000'
    YELLOW = 'FFFFFF00'
    DARKYELLOW = 'FF808000'

More Related Contents:

  1. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  2. Python convert csv to xlsx
  3. Editing workbooks with rich text in openpyxl
  4. Pandas: Looking up the list of sheets in an excel file
  5. How to concatenate three excels files xlsx using python?
  6. How to copy worksheet from one workbook to another one using openpyxl?
  7. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  8. How can I see the formulas of an excel spreadsheet in pandas / python?
  9. How to find the last row in a column using openpyxl normal workbook?
  10. how to write to a new cell in python using openpyxl
  11. Python openpyxl data_only=True returning None
  12. Insert row into Excel spreadsheet using openpyxl in Python
  13. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  14. Get cell color from .xlsx
  15. How to write to an existing excel file without breaking formulas with openpyxl?
  16. Openpyxl max_row and max_column wrongly reports a larger figure
  17. Append existing excel sheet with new dataframe using python pandas
  18. Read Excel cell value and not the formula computing it -openpyxl
  19. How to call python script on excel vba?
  20. Driving Excel from Python in Windows
  21. check if a file is open in Python
  22. Import multiple excel files into python pandas and concatenate them into one dataframe
  23. How do I read a date in Excel format in Python?
  24. How to access the real value of a cell using the openpyxl module for python
  25. Openpyxl 1.8.5: Reading the result of a formula typed in a cell using openpyxl
  26. How to read SharePoint Online (Office365) Excel files in Python with Work or School Account?
  27. Use Python to Inject Macros into Spreadsheets
  28. Identifying Excel Sheet cell color code using XLRD package
  29. python-win32com excel com model started generating errors
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment