import xlwt
# 创建一个workbook 设置编码
workbook = xlwt.Workbook(encoding = 'utf-8')
# 创建一个worksheet
worksheet = workbook.add_sheet('My Worksheet')
# 写入excel
# 参数对应 行, 列, 值
worksheet.write(0,0, label = 1)
worksheet.write(0,1, label = 1)
worksheet.write(0,2, label = xlwt.Formula('a1+b1') )
# 保存
workbook.save('Excel_tes2.xls')
参考
https://www.cnblogs.com/machangwei-8/p/10738244.html#_label6