转载:https://www.jianshu.com/p/fc97dd7e822c
import xlwt #导入模块
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('sheet1')
#通过worksheet调用merge()创建合并单元格
#第一个和第二个参数单表行合并,第三个和第四个参数列合并,
#合并第0列到第2列的单元格
worksheet.write_merge(0, 0, 0, 2, 'first merge')
workbook.save('students.xls')
import xlwt #导入模块
workbook = xlwt.Workbook(encoding='utf-8') #创建workbook 对象
worksheet = workbook.add_sheet('gongzuo') #创建工作表sheet
# 通过worksheet调用merge()创建合并单元格
worksheet.write_merge(0, 0, 0, 2, 'first merge') # 合并第0列到第2列的单元格
workbook.save('C:\\Users\\del\\Desktop\\students.xls') #保存表为students.xls