Import excel file in python and identify cells of which the content is strikethrough

Question

I want to read in many Excel documents and I would like to receive at least one important bit of information on the format. However, I am afraid that there is no tool for it, so my hope is on you!

Each excel file that I am reading in contains a few cells that of which the content is strikethrough. For those who don't know the word (I didn't know it either), strikethrough means that there is a horizontal line through the content.

I have figured out that I will need to read in my documents with xlrd to be able to identify the fonts. However, I have been going over a list of possibilities and none of them contains a check on strikethrough.

create a file yourself with two cells, one is just a text second is a same text with strikethrough. Read both with xlrd and compare. — Alex, Oct 12 '16 at 13:44
Try `Font.struck_out` https://pythonhosted.org/xlrd3/font.html (Too short for an answer) — J Reid, Oct 12 '16 at 13:49
@Alex I will have to do it for 59 excel files with multiple sheets, so I prefer to not do something by hand. — Student NL, Oct 12 '16 at 13:57
It would have to be that or escapement. Strange struck_out seems most likely. — J Reid, Oct 12 '16 at 14:10

score 4 · Answer 1 · answered Oct 12 '16 at 14:13

You have to open the workbook with formatting_info kwarg as True. Then, get the XF object of the cells and get the Font object. The struck_out attribute is what you're looking for. An example:

workbook = xlrd.open_workbook(filename, formatting_info=True)
sh = workbook.sheet_by_name(sheet)
xf = workbook.xf_list[sh.cell_xf_index(row, col)]
font = workbook.font_list[xf.font_index]
if font.struck_out:
    print(row, col)

score 1 · Answer 2 · answered Apr 16 '20 at 13:18

from openpyxl import load_workbook
book = load_workbook('xyz.xlsx')
sheet = book.get_sheet_names()[0] #This will consider **Sheet1** of our excel file
ws = book.get_sheet_by_name(sheet)
for row in ws.iter_rows():
    for cell in row:
        if cell.font.strike:
            print(cell.value)

Import excel file in python and identify cells of which the content is strikethrough

2 Answers2