How to get Cell range of specific data in excel

Hello Team,

I need to get Cell range value of specific data(Today) in excel sheet. Please find the screenshot to get more clarification.
Example : In this screenshot “Today” data available in Cell Number “APB2”.

Add the Read Range activity inside the Excel Application Scope activity.
Set the output value to dt_Excel from the Properties panel.
Then type row = dt_Excel in the for each activity.
Type row.Item(“Today”).ToString in the Writeline activity to write the values ​​in that column.

New Microsoft Excel Worksheet.xlsx (7.9 KB)
Main.xaml (6.7 KB)

Hello ridvanucok,

I want cell Range value of “Today” data. If you see the screen shot then you found that Cell range value of “Today” data is “ABP2”.

You can use Lookup range to find the cell range…
Test.xaml (10.3 KB)
Input.xlsx (8.3 KB)
Try this example, hope this will work for you

1 Like

Example usage.

Can you please send me Lookup Range package name.

1 Like

Hi @ridvanucok ,

Could you give this a try?

Row Index →

dt_sampleData.AsEnumerable().Where(Function(w) w.ItemArray.Contains("Today")).Select(Function(s) dt_sampleData.Rows.IndexOf(s)).First()

Column Index →

dt_sampleData.Rows(int_rowIndex).ItemArray.ToList().FindIndex(Function(i) i.ToString.Equals("Today"))+1

Range → column:row


FindRangeinExcel.xaml (5.8 KB)

Kind Regards,
Ashwin A.K



Thank you very much :slightly_smiling_face:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.