1#-*- coding:utf-8 -*-2#__author__ = 'liu-ke'3importxlrd4fromxlutils.copyimportcopy5mybook = xlrd.open_workbook("E:\liu-ke\user.xls")6mysheet = mybook.sheet_by_name("name")7j=mysheet.nrows8b=copy(mybook)9c=b.get_sheet(0)10c.write(9,1,"liu-ke")11b.save("E:\liu-ke\user.xls")121314foriinrange(1,j):15PRintmysheet.cell(i,0).value