处理表格
from openpyxl import load_workbook
import datetime
wb = load_workbook(r'D:\Pythontest\reptile\python-excel.xlsx')
#创建一个sheet
ws1=wb.create_sheet("mysheet")
#设定sheet的名字
ws1.title='newtitle'
读取.xlsx文件
# coding=utf-8
from openpyxl import load_workbook
#打开一个wo...



