Skip to content Skip to sidebar Skip to footer

Openpyxl: Determining Which Character In A Cell Value Is Strikethrough

I'll first mention that I'm using Python 2.7 and Openpyxl 2.4.1 Essentially I have a sheet in a workbook that I'm cleaning. I'm going through each cell and checking if there is Str

Solution 1:

No this is not possible: openpyxl does not deal with formatting below the level of the cell. You will need to write your own parser to do this.

Solution 2:

This is possible with the property Cell.font.strike:

if my_cell.font.strike ==True:
     #here's the tricky part

Post a Comment for "Openpyxl: Determining Which Character In A Cell Value Is Strikethrough"