python 操作Excel（2）-------创建sheet

from openpyxl import Workbook

wb = Workbook()  #创建一个文件对象

ws = wb.create_sheet("Mysheet1")

ws1 = wb.create_sheet("Mysheet")
ws1.title = "New Title"  #Mysheet 设定一个sheet名

ws2 = wb.create_sheet("Mysheet",0) #插入一个sheet
ws2.title = u"天天向上"

#设置单元格背景颜色
ws2.sheet_properties.tabColor = "1072BA"

#获取某个sheet对象
print(wb["天天向上"])
print(wb["New Title"])

#获取全部的sheet名
print(wb.sheetnames)
for sheet_name in wb.sheetnames:
    print(sheet_name)


print("*"*30)

#遍历获取sheet对象，按照sheet顺序获取
for sheet in wb:
    print(sheet)


for sheet in wb:
    print(sheet.title)
    
#复制一个sheet
wb["New Title"]["A1"] = "good"
source = wb["New Title"]
target = wb.copy_worksheet(source)

#删除某个sheet
del wb["New Title"]
 
#保存
wb.save("e:\\sample.xlsx")