import pandas as pd
from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.styles import Alignment,Font,Side,Border
def mm(wb):
for sheet_name in wb.sheetnames:
ws = wb[sheet_name]
maxrows = ws.max_row # 获取最大行
for i in range(1,maxrows+1):
# print(my_list)
cells = ws[i]
font = Font(name='微软雅黑', size=10, bold=False, italic=False, color='FF000000')
alignment = Alignment(horizontal="center", vertical="center")
# 先定好side的格式
side_left = Side(style='thin', color='FF000000')
side_right = Side(style='thin', color='FF000000')
# 代入边线中
border = Border(left=side_left, right=side_right, top=side_right, bottom=side_left)
for cell in cells:
cell.font = font
cell.alignment = alignment
cell.border = border
wb.save('看看我变化了没.xlsx')
if __name__ == '__main__':
wb = load_workbook(filename=r'C:\Users\Administrator\Desktop\设置样式.xlsx')
mm(wb)