1.xlrd读取excel
请参考上篇博客https://www.cnblogs.com/shapeL/p/9075843.html
2.xlwt生成excel
安装下载:pip install xlwt
导入:import xlwt
参考:
生成excel文件test1.xls
file_name = '../dataconfig/test1.xls'wbk= xlwt.Workbook() #初始化workbook对象
sheet = wbk.add_sheet('My_Worksheet') #创建表
sheet.write(0,0,'ok') #往单元格写入内容
wbk.save(file_name) #保存
如果对同一单元多次操作,报错
file_name = '../dataconfig/test1.xls'wbk=xlwt.Workbook()
sheet= wbk.add_sheet('My_Worksheet')
sheet.write(0,1,'ok')
sheet.write(0,1,'hhok')
wbk.save(file_name)
报错:
Exception: Attempt to overwrite cell: sheetname='My_Worksheet' rowx=0 colx=1
解决方案:使用cell_overwrite_ok=True来创建worksheet
sheet = wbk.add_sheet(&#