import openpyxl
import os
import datetime
"""
掌握内容
1、了解openpyxl的常用方法,及操作excel的步骤
"""
wb1 = openpyxl.Workbook()
wb1.save(filename = 'excel_name.xlsx')
wb2 = openpyxl.load_workbook('excel_name.xlsx')
sheet01 = wb2.active
sheet01['A2'] = 100
sheet01.append([1, 2, 3])
sheet01['A4'] = datetime.datetime.now().strftime("%Y-%m-%d")
sheet02 = wb2.create_sheet('Mysheet')
sheet03 = wb2.create_sheet('Yoursheet',0)
ws1 = wb2['Mysheet']
ws2 = wb2.get_sheet_by_name('Mysheet')
if ws1 is ws2:
print (True)
else:
print (False)
print (wb2.sheetnames)
for sheet in wb2:
print (sheet.title)
c = sheet02['A4']
print (c,'这是A4单元格')
d = sheet02.cell(row=4,column=2,value='定位访问单元格')
print (d)
for i in range(1,101):
for j in range(1,101):
sheet02.cell(row=i,column=j)
wb2.save(filename='excel_name.xlsx')
def Creat_excel(excel_name):
pwd = os.getcwd()
print (pwd)
wb = openpyxl.Workbook()
wb.save(filename = excel_name)
print (excel_name + "新建成功")
def Write(data,fields,sheetname,excel_name):
print ('写入excel...')
wb = openpyxl.load_workbook(filename = excel_name)
sheet01 = wb.active
sheet01.title = sheetname
field = 1
for field in range(1, len(fields) + 1):
row = sheet01.cell(row=1, column=field, value=str(fields[field - 1]))
row1=1
col1=0
for row1 in range(2,len(data)+2):
for col1 in range(1,len(data[row1-2])+1):
column=sheet01.cell(row=row1,column=col1,value=str(data[row1-2][col1-1]))
wb.save(filename=excel_name)
print("保存成功")
Creat_excel('excel01.xlsx')
Write('asdfgh','qwerty','sheet01','excel01.xlsx')