How to get Row number of particular value in Excel


#1

Hello I have a header in excel “leave_meter” I want to get row number of this. Position of header does not remains constant.
Please help.


#2

Please help @vvaidya


#3

Get the excel into datatable.

Foreach column in datatble.Columns

if column = “leave_meter”

get Column Index and convert to Alphabet (For eg: If Index is 3 (starts from 0) Header is D1)