1、导入需要的库importxlrd----注意xlrdversion1.2.0importreimportos2。parameter参数详解pathxlsx文件路径sheet_index_number要查找的列名sheetrow_name3.代码部分#在excel中查找指定列并返回其所在的sheetindexvaluedeffond_excel_info(path,sheet_index_number,row_name):#处理路径r=re.sub(r'\\\\',r'\\',path)#后缀判断paths_file=r.split('.')[-1]file_path_xlsx="xlsx"ifpaths_file!=file_path_xlsx:print("要提取的Excel文件的后缀应该是.xlsx",flush=True)os._exit(0)#打开excel文件并创建工作簿对象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)#获取session记录的索引index_number=-1result_index=0#在read_sheet.get_rows()中查找第一个sheet中的name列forrow:try:whilerow:index_number+=1price_column=row[index_number]price_value=price_column.valuetext_name=str(price_value)iftext_name==str(row_name):result_index=index_number#字段索引except:passifresult_index==0:print("Thiscolumnwasnotfound",flush=True)returnresult_indexprint(fond_excel_info(r'test.xlsx',1,'name'))4.test.xlsx索引为1
