import openpyxl
from openpyxl.utils import get_column_letter

#打开工作簿
wb = openpyxl.Workbook()
sheet = wb.active

#修改表单名
print(sheet.title)
sheet.title = '这个是我的新的表单'
print(wb.get_sheet_names())

#生成二个新的表单
wb.create_sheet(index=0, title='First Sheet')
wb.create_sheet(index=1, title='Middle Sheet')
print(wb.get_sheet_names())

#删除表单
wb.remove_sheet(wb.get_sheet_by_name('Middle Sheet'))
print(wb.get_sheet_names())

#给单元赋值
sheet['A1'] = 'test'
print(sheet['A1'].value)

#给多单元格赋值
ws1 = wb.create_sheet('range names')
for row in range(1,40):
    ws1.append(range(17))

ws2 = wb.create_sheet('List')
rows=[
    ['Number','batch1','Batch2'],
    [2,40,30],
    [3,60,32],
    [4,90,60],
    [5,560,378],
    [6,120,920],
]
for row in rows:
    ws2.append(row)

ws3 = wb.create_sheet(title='Data')
for row in range(2,10):
    for col in range(1,14):
        ws3.cell(column=col,row=row,value=get_column_letter(col))
print(ws3['AA10'].value)

#结果保存到文件里
wb.save('test.xlsx')