How to obtain the background color of a cell using xlrd?

[Krszt]

Hi all,

I wat to get the background color of a given cell with python from an xlsx. Iam new with it, could you please help me to finish this :

1 2 3 4 5 6 7

import xlrd workbook = xlrd.open_workbook('67.xlsx') worksheet = workbook.sheet_by_name('Oldal1') # read a cell cell = worksheet.cell(2,2) #print cell print cell.value

[hshivaraj]

First you need to open the sheet with the formatting_info set to true

1 2 3 4 5 6 7 8

import zlrd wb = xlrd.open_workbook(<filename>, formatting_info=True) ws = wb.sheet_by_name(<sheet name>) c = ws.cell(1, 1) cif = ws.cell_xf_index(1, 1) iif = wb.xf_list[cif] cbg = iif.background.pattern_colour_index print(cbg)

That should do the trick