How to find in which column the particular value found

I have excel sheet, in that around 8 tables are there which are unstructured. I need to find in which column the particular value(“Total”) found. please help me

Hi @reshmaprabh
Do you need to know where the column named total is present?

it is not the column name. just a value present in somewhere of excel sheet. i need to find in which column it is present

Use "lookup range " activity .
It will locate you to the cell where the value Is present.

Thanks

First check column Test exists or not - by using

dtExcelData.Columns.Contains(“Test”)

after that use below to get the column index.

dtExcelData.Columns.IndexOf(“Test”)

@reshmaprabh, Is it possible for you to attach sample excel file? It will help us to give optimal solution.

yes i got the cell address where it present eg: BA3. but i need the column index of that eg: 51. how can i convert that column letter to number

Thanks