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”.

Hi,
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”.

Hey, @ALAM_MD
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
Thanks,
Vinit

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

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(int_colIndex)+":"+(int_rowIndex+2).ToString

FindRangeinExcel.xaml (5.8 KB)

Kind Regards,
Ashwin A.K

2 Likes

UiPath.Excel.Activities.ExcelLookUpRange

Thank you very much :slightly_smiling_face:

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