openpyxl 安装
pip install openpyxl
读取.xlsx文件、获取富文本信息
import openpyxl
from openpyxl import load_workbook
from openpyxl.cell.rich_text import TextBlock, CellRichText
filePath = 'you Xlsx file path'
workbook = load_workbook(filename=filePath, rich_text=True)
sheet1 = workbook[workbook.sheetnames[0]]
for row in sheet1.iter_rows():
for cell in row :
if isinstance(cell.value, CellRichText) :
for e in cell.value :
if isinstance(e, TextBlock) :
print(e.font)
参考链接
openpyxl.cell.rich_text.CellRichText
openpyxl.cell.text.InlineFont