from openpyxl import Workbook
import datetime
filePath = r'C:\Users\23263\Desktop\1.xlsx'
#创建Excel实例
myWb = Workbook()
#第一个sheet
myWs0 = myWb.active
#新建sheet表
myWs1 = myWb.create_sheet("第一个")
myWs2 = myWb.create_sheet("no 2")
myWs3 = myWb.create_sheet("第四个")
#打印所有sheet的名字
print (myWb.sheetnames)
#修改sheet的title
myWs2.title = "第二个"
#修改sheet名字的背景色
myWs2.sheet_properties.tabColor = "1042BA"
#当sheet有title后,可以直接用列表读取tilte名字
print (myWb.sheetnames[2])
myWs4 = myWb["第一个"]
#对每个sheet写入数据
myWs0['A1'] = "自带的"
myWs1['B2'] = "第一个"
myWs2['C3'] = "no 2"
myWs3['D4'] = "第四个"
myWs4['E5'] = "中国"
myWb.save(filePath) #保存excel