python读取exl

import xlrd
# 读取excel文件，返回行信息
def open_excel(file,rownum=1):

data = xlrd.open_workbook(file)
table = data.sheet_by_index(0)
return table.row_values(rownum)

# excel行数
def nrows(file):
data = xlrd.open_workbook(file)
table = data.sheet_by_index(0)
return table.nrows

# excel列数
def ncols(file):
data = xlrd.open_workbook(file)
table = data.sheet_by_index(0)
return table.ncols