Search code examples
pythonxmlms-wordpython-docx

How to get cell background color in python-docx?

I'm trying to read data from MS Word table using python-docx. There is a way to set background color of a table cell:

tcPr = cell._tc.get_or_add_tcPr()
shd = OxmlElement("w:shd")
shd.set(qn("w:fill"), rgb2hex(*color))
tcPr.append(shd)

My task is contrary, I need to get the existing color. I'm not skilled in xml and I tried this:

cell = table.cell(row, col)
tcPr = cell._tc.get_or_add_tcPr().get(qn('w:shd'))

How ever it returns me None for each read cell regardless of its color.

Solution

  • As scanny proposed, I used parsing cell._tc.xml:

    pattern = re.compile('w:fill=\"(\S*)\"')
match = pattern.search(cell._tc.xml)
result = match.group(1)

    If there is data on color it returns either "auto" or hex code of background color which can be converted to RGB.