Oct-04-2019, 10:30 PM
(This post was last modified: Oct-04-2019, 10:30 PM by curranjohn46.)
Hi,
The code below uses openpyxl and iterates through all rows and columns in a spreadsheet searching for a value in a list called subID. It then colors each cell it finds with that value light blue. I am trying to figure out how to color the whole row when a cell is found.
Any suggestions on how I can do this? I am not 100% sure but openpyxl may be forcing me to color each cell individually in the row.
The code below uses openpyxl and iterates through all rows and columns in a spreadsheet searching for a value in a list called subID. It then colors each cell it finds with that value light blue. I am trying to figure out how to color the whole row when a cell is found.
Any suggestions on how I can do this? I am not 100% sure but openpyxl may be forcing me to color each cell individually in the row.
#this colors the cell wherever sub id in list is found. lightblueFill = PatternFill(start_color='c9e1f8', end_color='c9e1f8', fill_type='solid') max_row=ws2.max_row max_column=ws2.max_column # iterate over all rows for ro in range(1,max_row+1): # iterate over all columns for co in range(1,max_column+1): # get particular cell value cell_obj=ws2.cell(row=ro,column=co) #searches all cell and columns for a value in a list called subID if cell_obj.value in subID: #colors the cells found light blue. cell_obj.fill = lightblueFill