代码
import openpyxl
from openpyxl.styles import Border,Side
# 导入填充类PatternFill
wb = openpyxl.load_workbook('/Users/test0712.xlsx')
ws = wb['Sheet1']
max_rows = ws.max_row # 获取最大行
max_columns = ws.max_column # 获取最大列
borders = Border(left=Side(style='thick'),bottom=Side(style='thick'),right=Side(style='thick'),top=Side(style='thick')) # 设置填充颜色为粉红色
# openpyxl的下标从1开始
for i in range(1, max_rows + 1):
for j in range(1, max_columns + 1):
ws.cell(i, j).border = borders
wb.save('/Users/test0712.xlsx')