python中openpyxl修改excel中字体及读取字体
1 from openpyxl.styles import Font 2 3 from openpyxl import load_workbook 4 5 excel=load_workbook(r'文件名.xlsx') 6 7 sheet=excel.active 8 9 font=Font(name='黑体',size=12,bold=True,italic=True,color='rgb值转为hex') #bold指是否加粗,italic指是否倾斜 10 11 cell=sheet['A1'] 12 13 cell.font=font 14 15 #读取字体类型 16 17 cell2=sheet['A1'] 18 19 font2=cell2.font 20 21 print(font.name,font.size,font.bold,font.itallic)
