import xlsxwriter
# 创建一个excel文件
workbook=xlsxwriter.Workbook('保存图片xls格式04.xlsx')
# 创建一个工作表对象
worksheet=workbook.add_worksheet('sheet001')
worksheet.write(3,0,15)
worksheet.write(2,0,20)
worksheet.write(4,0,'=sum(A3:A4)')
#另一种求和的方法
worksheet.write('A6',25)
worksheet.write('A7',30)
worksheet.write('A8','=sum(A6:A7)')
workbook.close()