Nov-03-2017, 11:02 PM
Using openpyxl to manipulate Excel files, what is the best way to set the cell background colour?
I got this from stackoverflow:
All I want is for every other column to have a yellow background, makes reading the table easier somehow.
I got this from stackoverflow:
from openpyxl.styles import Color, Fill from openpyxl.cell import Cell _cell.style.fill.fill_type = Fill.FILL_SOLID _cell.style.fill.start_color.index = Color.DARKREDThis post in from 2011. Is there a better way to do it in python 3.5?
All I want is for every other column to have a yellow background, makes reading the table easier somehow.