Python-Excel-openpyxl-07-单元格边框设置

zishendianxia

发布于 2019-10-23 17:40:48

6.5K0

发布于 2019-10-23 17:40:48

文章被收录于专栏：Python工程师 Python工程师Python工程师

系统：Windows 7 语言版本：Anaconda3-4.3.0.1-Windows-x86_64 编辑器：pycharm-community-2016.3.2 openpyxl：2.6.2

这个系列讲讲Python对Excel的操作
使用openpyxl模块
今天讲讲单元格边框的设置

Part 1：代码

from openpyxl import load_workbook
from openpyxl.styles import Border, Side, colors

excel_address = r"E:\Coding\E_PythonWriting\Excel\openpyxl示例_7.xlsx"
wb = load_workbook(excel_address)
sht = wb.worksheets[0]

sht["D5"] = "测试"

border_set = Border(left=Side(style='thick', color=colors.RED),
                    right=Side(style='medium', color=colors.BLACK),
                    top=Side(style='double', color=colors.BLUE),
                    bottom=Side(style='dotted', color=colors.BLACK))

sht["D5"].border = border_set

wb.save(excel_address)

代码截图