使用XLRD包识别Excel Sheet单元格颜色代码 [英] Identifying Excel Sheet cell color code using XLRD package

问题描述

我正在使用 xlrd 编写一个python脚本来从excel表中读取数据。工作表中的几个单元格以不同的颜色突出显示，我想识别单元格的颜色代码。有什么办法吗？

I am writing a python script to read data from an excel sheet using xlrd. Few of the cells of the the work sheet are highlighted with different color and I want to identify the color code of the cell. Is there any way to do that ? An example would be really appreciated.

推荐答案

这是一种处理方式：

import xlrd
book = xlrd.open_workbook("sample.xls", formatting_info=True)
sheets = book.sheet_names()
print "sheets are:", sheets
for index, sh in enumerate(sheets):
    sheet = book.sheet_by_index(index)
    print "Sheet:", sheet.name
    rows, cols = sheet.nrows, sheet.ncols
    print "Number of rows: %s   Number of cols: %s" % (rows, cols)
    for row in range(rows):
        for col in range(cols):
            print "row, col is:", row+1, col+1,
            thecell = sheet.cell(row, col)      
            # could get 'dump', 'value', 'xf_index'
            print thecell.value,
            xfx = sheet.cell_xf_index(row, col)
            xf = book.xf_list[xfx]
            bgx = xf.background.pattern_colour_index
            print bgx

有关 Python-Excel Google Group 。

这篇关于使用XLRD包识别Excel Sheet单元格颜色代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！