1、示例代码：from openpyxl import load_workbook #读取excel需要的模块import os,sysfrom openpyxl.styles import Border, Side, Font #设置字体和边框需要的模块
3、bor蟠校盯昂der = Border(left=Side(style='medium',color='FF000000'),right=Side(style='medium',color='FF000000'),top=Side(style='medium',color='FF000000'),bottom=Side(style='medium',color='FF000000'),diagonal=Side(style='medium',color='FF000000'),diagonal_direction=0,outline=Side(style='medium',color='FF000000'),vertical=Side(style='medium',color='FF000000'),horizontal=Side(style='medium',color='FF000000'))
5、wsbbq["A35"] = "报表" #excel 表格 赋值wsbbq['A35'].font=font #设置单元格字体wsbbq['A38'].border=border #设置边框print(wsbbq['e35'].border) #这里仅仅是为了看看e35单元格的边框设置，起初按照官方设置（left=Side(border_style=None，color='FF000000'
