xlrd技巧 import xlrd data=xlrd.open_workbook("大学信息.xls") table=data.sheets()[0] names=[] nos=[] for i in range(1,table.nrows): no=table.row_values(i)[0] nos.append(no) name=table.row_values(i)[1] names.append(name) print(names) print(nos)