Python XlsxWriter module 使用之列求和

求和示例数据如下：

expenses = (
    ['Rent', 1000],
    ['Gas',   100],
    ['Food',  300],
    ['Gym',    50],
)

操作代码如下：

>>> import xlsxwriter
>>> workbook = xlsxwriter.Workbook('demo.xlsx')#实例化工作簿
>>> worksheet = workbook.add_worksheet('test1')#为工作簿添加sheet，名称自定义
>>> expenses = (
...     ['Rent', 1000],
...     ['Gas',   100],
...     ['Food',  300],
...     ['Gym',    50],
... )
>>>
>>> row = 0
>>> col = 0
>>> for k,v in expenses:#遍历我们的数据，然后填充单元格（[row,col],[row,col+1])，然后行递增row += 1进入下一个循环，取得下一行数据进行填充
...     worksheet.write(row,col,k)
...     worksheet.write(row,col+1,v)
...     row += 1
>>> worksheet.write(row,0,'Total')#最后一行一列协商名称total
0
>>> worksheet.write(row,1,'=SUM(B1:B4)')后一行二列写入调用多行求和的结果
0
>>> workbook.close()#关闭工作簿

结果如下：