python 读execl文件

# coding:utf-8
import xlrd



def save():
    # db, cur = dbconnect()
    file_name = "xxxx.xls"
    file = xlrd.open_workbook(file_name)
    # 输出Excel中表的个数
    # print(file.nsheets)
    # 读取某张表
    sheet = file.sheet_by_name("sheet1")
    # 获取表的行数
    nrows = sheet.nrows
    # 获取表的列数
    ncols = sheet.ncols
    print("nrows: %d, ncols: %d" % (nrows, ncols))
    for nn in range(nrows):
        # print(nn)
        ll1 = sheet.row_values(nn)
        print(ll1[0])

save()