![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicGcq5CMwETLwATMtADN0EDM4ATMhJGMmFDMwAjZmNWM2ITY18CXt92YucmbhdXZrVXbuMzZtl2Lc9CX6MHc0RHaiojIsJye.jpg)
離島
2020-07-09 09:37
已采納
不太了解具體需求,提供一些示例代碼和思路供你參考:
整體思路:首先已知excel中的顔色值,根據編碼實作顔色篩選的功能
示例:
1、首先安裝pip install openpyxl
2、示例代碼可以擷取Excel中指定背景填充色或文字顔色的資料(具體顔色值網上有很多線上rgb顔色轉換的)
import openpyxl
filename = "colortest.xlsx" # 讀取excel
workbook = openpyxl.load_workbook(filename)
worksheet = workbook.get_sheet_by_name("Sheet1") # 讀取Sheet
rows, cols = worksheet.max_row, worksheet.max_column
reddata = []
yellowdata = []
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
# print(fill.start_color.rgb)
if fill.start_color.rgb == "FFEEFA50":
yellowdata.append(ce.value)
if fill.start_color.rgb == "FFFF1D1D":
reddata.append(ce.value)
# if font.color.rgb == "FFFF1D1D":
# reddata.append(ce.value)
print(yellowdata, reddata)