python办公自动化——修改excel数据

import xlrd
from xlutils.copy import copy

# 打开excel
read_book = xlrd.open_workbook('01_电影数据.xls')

# 复制数据
wb = copy(read_book)

# 选择工作簿
sh1 = wb.get_sheet(0)

sh1.write(4, 0, '保家卫国')
sh1.write(4, 1, 113)
sh1.write(4, 2, 5.1)
sh1.write(4, 3, 490)

# 增加工作簿
sh2 = wb.add_sheet('汇总数据')

count = 0
rs = read_book.sheet_by_index(0)
for i in range(1, rs.nrows):
    num = rs.cell_value(i, 3)
    count += num

sh2.write(0, 0, '总票房')
sh2.write(0, 1, count)
wb.save('02_电影数据（修改）.xls')