from xlutils.copy import copy
import xlrd
这两个都引入进来才能修改excel
book1=xlrd.open_workbook('new_stu.xls')
book2=copy(book1)#拷贝一份原来的excel
print(dir(book2))
sheet=book2.get_sheet(0)#获取第几个sheet页
sheet.write(1,3,0)
sheet.write(1,0,'小黑')
book2.save('new_stu.xls')
