关于python:python查找excel文件指定列返回所在索引值

1.导入须要的库

import xlrd----留神xlrd版本1.2.0import reimport os

2.参数

3.代码局部

# 找excel指定列返回所在sheet索引值   def fond_excel_info(path,sheet_index_number,row_name):    # 解决门路    r = re.sub(r'\\\\', r'\\', path)        # 后缀判断    paths_file = r.split('.')[-1]    file_path_xlsx = "xlsx"    if paths_file != file_path_xlsx:        print("待提取Excel文件后缀应为.xlsx",flush=True)        os._exit(0)    # 关上excel文件，创立一个workbook对象    try:        rbook = xlrd.open_workbook(r)          except:        print("文件异样或门路有误,请查看！",flush=True)        os._exit(0)    rbook.sheets()    # sheet_index_number-1因为索引是0开始    read_sheet = rbook.sheet_by_index(sheet_index_number-1)    # 获取会话记录所在索引    index_number = -1     result_index = 0    # 在第一个sheet找name列    for row in read_sheet.get_rows():        try:            while row:                index_number+=1                price_column = row[index_number]                price_value = price_column.value                text_name = str(price_value)                 if text_name == str(row_name):                    result_index = index_number  # 字段索引        except:            pass           if result_index == 0:             print("没有找到此列",flush=True)    return result_index print(fond_excel_info(r'test.xlsx',1,'name'))

4.test.xlsx

索引为1