主页 / 问题 / 1018645
Accepted
Alexander Koval
Asked:2020-08-29 21:26:37 +0000 UTC2020-08-29 21:26:37 +0000 UTC

获取excel文件中的单元格填充颜色

  • 772

有一个包含一百万行的文件，需要对其进行解析。我实际上是这样做的，但仍有检查此单元格中填充颜色的任务。

# -*- coding: utf-8 -*-
from openpyxl import load_workbook


wb_form = load_workbook("1.xlsx", data_only=True)
sheet_form = wb_form["1"]
wb = sheet_form["B2"].value
f = open("1.txt", "w+")
tmp = 0

for iter, row in enumerate(sheet_form.values):
    if iter == 0:
        continue
    for i in row:
         if i == None:
             continue
         print(i)




f.close()

找不到解决方案。如何在迭代期间检查单元格颜色？

python

1 个回答

  1. Best Answer

    例子：

    In [73]: from openpyxl import load_workbook
    ...:
    ...: wb = load_workbook(r"C:\Temp\1.xlsx")
    ...: ws = wb["Sheet1"]
    ...:
    ...: for row in ws.iter_rows(min_row=1, max_col=3, max_row=5):
    ...:     for cell in row:
    ...:         print(f"coordinate: {cell.coordinate}\tvalue: {cell.value}\tcolor: {cell.fill.start_color.index}")
    ...:
coordinate: A1  value: a        color: 00000000
coordinate: B1  value: b        color: 00000000
coordinate: C1  value: c        color: 00000000
coordinate: A2  value: 1        color: 00000000
coordinate: B2  value: 2        color: FFC6EFCE
coordinate: C2  value: 3        color: 00000000
coordinate: A3  value: 4        color: 00000000
coordinate: B3  value: 5        color: FFFFC7CE
coordinate: C3  value: 6        color: 00000000
coordinate: A4  value: 7        color: 00000000
coordinate: B4  value: 8        color: FFFFEB9C
coordinate: C4  value: 9        color: 00000000
coordinate: A5  value: 10       color: 00000000
coordinate: B5  value: 11       color: 5
coordinate: C5  value: 12       color: 00000000
    • 3

相关问题