python xlrd获取excel数据

import xlrd
def readip(f):
    #校验文件是否存在，及文件格式
    data = xlrd.open_workbook(filename=f)
    print(type(data))
    #table = data.sheet_by_name('Sheet1')
    table = data.sheet_by_index(0) # 从0开始的sheet index，sheet1 计为0，类似数组索引
    print(type(table))
    nrows = table.nrows  #获取行数
    #nclon = table.nclon
    
    result = []
    for i in range(1,nrows):
        rows  = table.row_values(i)    #是一个数组来按行获取
        print(len(rows))
        
        result.append(rows[0]+':'+str(rows[1]).split('.')[0])
        
    print(result)

if __name__ == "__main__":

    readip("D:/workspace/test.xlsx")