xlutils演练 修改表格内容

import xlrd
from xlutils import copy

# 读取工作簿
file_path = 'myexcel.xls'
read_book = xlrd.open_workbook(file_path)

# 复制工作簿，得到工作表
write_book = copy.copy(read_book)
write_sheet = write_book.get_sheet(0)

# 写入内容到复制工作簿的表中
write_sheet.write(0, 0, '修改的2')

# 往原路径上保存内容
write_book.save(file_path)