openpyxl查找含有某字符串的行进行整行格式设置
例如查找含有“合计”的行并对整行数据进行填充色和字体颜色设置
import numpy as np
import pandas as pd
from openpyxl import *
import openpyxl as xl
from openpyxl.styles import *
fills = PatternFill('solid', fgColor="00FF0000")
fonts = Font(u'微软雅黑', size=14, bold=True, color="00Ffffff")
def format_search_value(sheet,keyword):
rows = []
columns = []
for i in range(start_row,end_row+1):
for j in range(start_col,end_col+1):
if keyword in str(sheet.cell(i,j).value):
rows.append(i)
columns.append(j)
for k in rows:
for l in range(start_col, end_col+1):
sheet.cell(k, l).fill = fills
sheet.cell(k, l).font = fonts
return sheet
format_search_value(sn,"合计")
得到结果