import xlrd
wb = xlrd.open_workbook('../Stu_pack/school.xls')#打开指定位置的文件工作薄school.xls,并创建对象wb
sheet = wb.sheet_by_index(0)#指定工作薄中的表单sheet,根据索引获取表单(0:第一个,1:第二个)
#根据行列序号读取内容
schools = [] #定义一个二维列表school存放行和列
for row in range(sheet.nrows):
school = [] #定义一个一维列表存放单元格具体的值
for col in range(sheet.ncols):
content = sheet.cell_value(row,col)#将单元格具体的值写入列表school[]
school.append(content) #通过列表方法append追加写入读取内容
schools.append(school)
for school in schools:
print(school)