要求:读取以下表格中所有字体为大红色或者单元格颜色为黄色的信息
利用到的模块是:openpyxl
import openpyxl
filename="colortest.xlsx"#读取excel
workbook=openpyxl.load_workbook(filename)
worksheet=workbook.get_sheet_by_name("试题2")#读取Sheet
rows,cols=worksheet.max_row,worksheet.max_column
yellow=[]
red=[]
for i in range(1,rows):
for j in range(1,cols):
ce=worksheet.cell(row=i,column=j)
fill = ce.fill
font = ce.font
if fill.start_color.rgb=="FFFFFF00" and ce.value!=None:
yellow.append(ce.value)
if font.color.rgb=="FFFF0000":
red.append(ce.value)
print(yellow,red)
结果: