python xlrd 使用

1.获取单元格颜色

来自 stackoverflow

import xlrdbook = xlrd.open_workbook("sample.xls", formatting_info=True)sheets = book.sheet_names()print "sheets are:", sheetsfor 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

在sheet类中，有一个对应的_cell_xf_indexes二维数组来存储每个单元格对应的样式序号。

同时，在book的xf_list存储着与样式序号所对应的具体样式信息。