import os
import openpyxl
from openpyxl.styles import Font, PatternFill, Side, Border, Alignment
# 创建工作簿
if os.path.exists('../StudyData/学生信息.xlsx'):
wb = openpyxl.load_workbook('../StudyData/学生信息.xlsx')
else:
wb = openpyxl.Workbook()
wb.save('../StudyData/openpyxl_hw.xlsx')
# 获取表格
sheet = wb['students']
# 添加列名
sheet.cell(1, 5)
Python基础小练习_openpyxl设置单元格样式
于 2023-02-15 00:03:35 首次发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)