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
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
1 Like
Thank you very much 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.