20190611 Python3 操作excel文件

#encoding=utf-8

from openpyxl import *

file_name='D:/songhuajie/efforts/Python/testexcel.xlsx'
exist_file='D:/songhuajie/efforts/Python/testdata.xlsx'
#1创建文件并写入数据
wb= Workbook()  #创建Excel对象
ws=wb.active    #激活Worksheet
ws['A1']='123'
ws['A2']='456'
ws['A3']=789
wb.save(file_name)  #保存内容

#2打开一个已存在的excel文件
file= load_workbook(exist_file)

#4储存数据
ws['B1']=3
ws.append([1,2,3])

#5创建sheet
ws=wb.create_sheet('mysheet1')
ws=wb.create_sheet('mysheet2')
wb.save(file_name)

#6获取sheet名称
print(wb.sheetnames)
for sheet in wb:
     print(sheet.title)

#访问单元格
content=ws.cell(row=2,column=3)
print(content)