readexcel.py 文件源码

def readexcel(path):
    workbook = xlrd.open_workbook(path)
    sheets =  workbook.sheet_names()
    # ??????
    for sname in sheets:
        print(sname)
    #?????sheet
    worksheet = workbook.sheet_by_name(sheets[0])
    #??sheet???????
    print(worksheet.nrows)
    print(worksheet.ncols)
    #?????cell?
    print(worksheet.cell(0,1).value)
    #??????
    print(worksheet.row(0)[0].value)
    #??cell???
    print(worksheet.row(0)[0].ctype)
    #???????
    for cell in worksheet.row(0):
        print(cell.value)
    #???????
    for cell in worksheet.col(0):
        if cell.value is not None and cell.value !='':
            print(cell.value)