import openpyxlimport osif os

标题```python

if os.path.exists(‘excel/school.xlsx’):
wb = openpyxl.load_workbook(‘excel/school.xlsx’)
else:
wb = openpyxl.Workbook()
wb.save(‘excel/school.xlsx’)

if ‘student’ in wb.sheetnames:
sheet1 = wb[‘student’]
else:
sheet1 = wb.create_sheet(‘student’)
wb.save(‘excel/school.xlsx’)

sheet1.cell(1,1).value = ‘姓名’
sheet1.cell(1,2).value = ‘年龄’
sheet1.cell(1,3).value = ‘电话’
sheet1.cell(1,4).value = ‘分数’
sheet1.cell(1,5).value = ‘留级建议’
wb.save(‘excel/school.xlsx’)

from openpyxl.styles import Font,PatternFill,Border,Side,Alignment

font1=Font(
size=16,
color=‘1266AE’
)
font2=Font(
size=11,
color=‘EE050B’ #分数
)
font3=Font(
size=11,
color=‘C76365’
)
m_r = sheet1.max_row
m_c = sheet1.max_column

for i in range(1,6):
sheet1.cell(1,i).font=font1
wb.save(‘excel/school.xlsx’)

for j in range(2,m_r+1):
if sheet1.cell(j,4).value <60:
sheet1.cell(j,4).font = font2
sheet1.cell(j,5).value = ‘留级’
sheet1.cell(j,5).font = font3
wb.save(‘excel/school.xlsx’)

#设置单元格填充
fill=PatternFill(
fill_type=‘solid’,
start_color=‘C3D79A’
)

for k in range(1,6):
sheet1.cell(1,k).fill = fill

#设置单元格对齐样式
a1 = Alignment(
horizontal=‘center’, #水平方向
vertical=‘center’ #垂直方向
)
for a in range(1,m_r+1):
for b in range(1,m_c+1):
sheet1.cell(a,b).alignment = a1

#设置cell 宽度和高度
#设置指定列的宽度
sheet1.column_dimensions[‘A’].width = 20
sheet1.column_dimensions[‘B’].width = 20
sheet1.column_dimensions[‘C’].width = 20
sheet1.column_dimensions[‘D’].width = 20
sheet1.column_dimensions[‘E’].width = 20
#设置指定行的高度
for l in range(1,m_r+1):
sheet1.row_dimensions[l].height = 20
wb.save(‘excel/school.xlsx’)