Python Forum

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 :

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

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

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