获取第一个工作表

import xlrd

data = xlrd.open_workbook('name.xlsx')
sheet = data.sheet_by_index(0)

获取sheet下的有效行数

import xlrd
data = xlrd.open_workbook('name.xlsx')
sheet = data.sheet_by_index(0)
print(sheet.nrows)

获取指定行数单元格对象组成的列表

import xlrd
data = xlrd.open_workbook('name.xlsx')
sheet = data.sheet_by_index(0)
print(sheet.nrows)
print(sheet.row(1))