1. 导入第三方包
import xlrd #只读
from xlutils.copy import copy #写
2. 打开一个excel
book = xlrd.open_workbook(test.xmls')
books = copy(book)#拷贝一份原来的excel
3. 获取sheet
sheet = book2.get_sheet(0)
4. 修改excel
sheet.write(row, col, value)#把第row行col列修改成value
5. 保存excel
book2.save('test.xls')