随笔分类 - python excel操作
摘要:#encoding=utf-8 ''' excel基本操作整理 ''' #openpyxl 版本2.5.4 from openpyxl import * import datetime as dt from datetime import datetime as dtt #新建create_sheet、copy_worksheet wb=Workbook() wb.create_sheet(...
阅读全文
摘要:#coding=utf-8 ''' excel基本操作 ''' from openpyxl import Workbook wb=Workbook() ws1=wb.create_sheet('sh1') ws2=wb.create_sheet('sh2') ws3=wb.copy_worksheet(ws1) ws3.title='copy_sh1' ws1['A1']=1 ws1['A...
阅读全文