from openpyxl import load_workbook
wb = load_workbook("strikethrough.xlsx")
ws = wb.active # wb.sheetnames[0] will do, too
for row in ws:
for cell in row:
value = cell.value # Note, empty cells have a value of None
if cell.font.strike:
value = ""
print(value)
#print(cell.font) # See more attributes
wb.close()
将此作为我的电子表格:
我得到这个输出:
HeaderA
HeaderB
Row2 ColA
Row3 ColA
Row3 ColB
None
None
Above cell is empty
None
这也可以通过openpyxl完成。你知道吗
将此作为我的电子表格:
我得到这个输出:
相关问题 更多 >
编程相关推荐