python处理excel
1,合并单元格
import xlwt
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet("sheet1")
worksheet.write_merge(4, 6, 0, 5, '合并')#合并第五行到第七行,合并第一列到第六列
workbook.save('test.xls')
2,新增sheet,不覆盖原有sheet(参考:官方说明文档)
import pandas as pd
sheetnamelist=['sheet1','she
原创
2021-03-04 16:57:57 ·
221 阅读 ·
0 评论