学习Python纪录Day24 - 建立Excel及编辑试算表

新增工作表

使用create_sheet()方法新增工作表，title参数为工作表名称

wb = load_workbook("Excel成绩单.xlsx")
ws2=wb.create_sheet(title = "成绩表2")

ws2["A1"] = "座号"
ws2["B1"] = "姓名"
ws2["C1"] = "国文"
ws2["D1"] = "数学"
ws.append([21, "Chang", 80, 95])
ws.append([22, "Chen", 90, 85])

wb.save("Excel成绩单2.xlsx")
wb.close()

在excel储存格指定套用的公式

• 用SUM()计算两项成绩的和

wb = load_workbook("Excel成绩单.xlsx")
ws = wb.active
ws["E1"] = "总分"
ws["E2"] = "=SUM(C2:D2)"
ws["E3"] = "=SUM(C3:D3)"

wb.save("Excel成绩单3.xlsx")
wb.close()

合并excel储存格

• merge_cells()合并参数范围的储存格

wb= load_workbook("Excel成绩单.xlsx")
ws = wb["成绩表1"]
ws.merge_cells("B2:C2")
ws.merge_cells("B3:C3")

wb.save("Excel成绩单1.xlsx")
wb.close()