openpyxl表格样式设置

꧁ᝰ苏苏ᝰ꧂

已于 2022-07-14 11:46:58 修改

阅读量760

点赞数

分类专栏： Python自动化办公文章标签： python

于 2022-07-05 16:01:35 首次发布

本文链接：https://blog.csdn.net/qq_45396577/article/details/125621899

版权

Python自动化办公专栏收录该内容

19 篇文章 0 订阅

订阅专栏

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)