#encoding=utf-8
from openpyxl import Workbook
from openpyxl import load_workbook
wb=Workbook()
ws=wb.active
ws.append(['Name','Sex','Age'])
ws.append(('Tom','male','29'))
ws.append(('Lily','female','20'))
ws.append(('Vivian','female','30'))
ws.append(('xiaoming','male','26'))
wb.save('D:/songhuajie/efforts/Python/testexcel.xlsx')
#创建一个新Sheet并写入数据
wb=load_workbook('D:/songhuajie/efforts/Python/123.xlsx')
ws1=wb.create_sheet('mysheet1')
ws2=wb.create_sheet("mysheet2",0)
sheet=wb['mysheet1']
sheet.append(['name2','age2','sex2'])
sheet.append(['name3','age3','sex3'])
sheet.append(['name4','age4','sex4'])
sheet.append(['name5','age5','sex5'])
sheet.append(['name6','age6','sex6'])
#访问单元格
ws=wb['mysheet1']
for row in range(1,4):
for column in range(1,4):
print(ws.cell(row=row,column=column).value)