python 查找excel内容所在的单元格_python 根据excel单元格内容获取该单元格所在的行号...

python 环境：Python 2.7.16

需要安装：pandas/xlrd (pip2 install pandas/ pip2 install xlrd)

import pandas as pd

def find_row(num_value,file_name):

"""

Returns the row number based on the value of the specified cell

"""

demo_df = pd.read_excel(file_name)

for indexs in demo_df.index:

for i in range(len(demo_df.loc[indexs].values)):

if (str(demo_df.loc[indexs].values[i]) == num_value):

row = str(indexs+2).rstrip(‘L‘)

return row

row_num = find_row(‘103.03‘,‘test.xlsx‘)

print(row_num)

以上代码实现：从‘test.xlsx‘中获取单元格’103.03‘所在的行号（注意：如果存在多个单元格的value是’103.03‘，只返回第一次读到的行号）

原文地址：https://www.cnblogs.com/njuptlwh/p/13070291.html