Get cell color from .xlsx

by

Looks like the sheet is using the built-on colour index. The mapping for these is in the source of openpyxl.styles.color

COLOR_INDEX = (
    '00000000', '00FFFFFF', '00FF0000', '0000FF00', '000000FF', #0-4
    '00FFFF00', '00FF00FF', '0000FFFF', '00000000', '00FFFFFF', #5-9
    '00FF0000', '0000FF00', '000000FF', '00FFFF00', '00FF00FF', #10-14
    '0000FFFF', '00800000', '00008000', '00000080', '00808000', #15-19
    '00800080', '00008080', '00C0C0C0', '00808080', '009999FF', #20-24
    '00993366', '00FFFFCC', '00CCFFFF', '00660066', '00FF8080', #25-29
    '000066CC', '00CCCCFF', '00000080', '00FF00FF', '00FFFF00', #30-34
    '0000FFFF', '00800080', '00800000', '00008080', '000000FF', #35-39
    '0000CCFF', '00CCFFFF', '00CCFFCC', '00FFFF99', '0099CCFF', #40-44
    '00FF99CC', '00CC99FF', '00FFCC99', '003366FF', '0033CCCC', #45-49
    '0099CC00', '00FFCC00', '00FF9900', '00FF6600', '00666699', #50-54
    '00969696', '00003366', '00339966', '00003300', '00333300', #55-59
    '00993300', '00993366', '00333399', '00333333', 'System Foreground', 'System Background' #60-64
)

11L corresponds to 0000FF00 (hexadecimal) for which the rgb tuple would be green (0,255,0).

More Related Contents:

  1. Editing workbooks with rich text in openpyxl
  2. Pandas: Looking up the list of sheets in an excel file
  3. How to concatenate three excels files xlsx using python?
  4. How to copy worksheet from one workbook to another one using openpyxl?
  5. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  6. How to find the last row in a column using openpyxl normal workbook?
  7. how to write to a new cell in python using openpyxl
  8. Python openpyxl data_only=True returning None
  9. Insert row into Excel spreadsheet using openpyxl in Python
  10. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  11. How to write to an existing excel file without breaking formulas with openpyxl?
  12. Openpyxl max_row and max_column wrongly reports a larger figure
  13. Setting styles in Openpyxl
  14. Extract the data and modify an existing excel with openpyxl
  15. How can I open an Excel file in Python?
  16. Running an Excel macro via Python?
  17. How to convert a python datetime.datetime to excel serial date number
  18. xls to csv converter
  19. copy cell style openpyxl
  20. Error: Unsupported format, or corrupt file: Expected BOF record
  21. pandas xlsxwriter, format table header – not sheet header
  22. How can I see the formulas of an excel spreadsheet in pandas / python?
  23. Python: Open Excel Workbook using Win32 COM Api
  24. Copy pandas dataframe to excel using openpyxl
  25. How to save XLSM file with Macro, using openpyxl
  26. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  27. How do I call an Excel macro from Python using xlwings?
  28. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  29. How to return and download Excel file using FastAPI?
  30. Using openpyxl to read file from memory

Leave a Comment