import xlrd
book = xlrd.open_workbook('E:/a.xlsx')
sheet = book.sheet_by_index(0) # 第几个Sheet
print(sheet.row_values(rowx=0)) # 行的内容
print(sheet.col_values(colx=1)) # 列的内容

import xlrd
book = xlrd.open_workbook('E:/a.xlsx')
sheet = book.sheet_by_index(0) # 第几个Sheet
print(sheet.row_values(rowx=0)) # 行的内容
print(sheet.col_values(colx=1)) # 列的内容