How to search values using Find path in excel?

Help StudioX
, , ,
1

In excel lot of data, where we can find a unique name called RESULT the next cell value I should capture. please help me on this.
cell-1 cell2
RESULT 63%

Thank you.

2

Hi @Raghu_km

Try to use lookup activity

Regards

3

Hi @Raghu_km

Use lookup range activity you will get the address of result like “D1” Ina Variable1

Next use a read cell activity in the range Use this expression


UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(UiPath.Excel.Helpers.ExcelUtilities.CovertColumnLetterToColumnIndex(System.Text.RegularExpressions.Regex.Match(Variable1,”\D+”).ToString)+1)+”1”

This expresses will give you E1 as range
Store the values in a variable and use them

Regards
Sudharsan

4

Hi @Raghu_km

Can you share any sample excel file, so that we can check on and provide you the solution?

5

@Raghu_km

Read the data into datatable and use filter datatable and filter on result and then get next value by dt.Rows(0)(“Targetcolumn”).ToString

Or

Use the look up table activity and pss the Result as to be searched and the target column name as the column with 63%

Cheers

6

@Anil_G thanks for the information but the value would be dynamic. just i want to take the value after Result next cell.

7

Hi Manish,

Please find the attached copy of excel.
UiPath_Sample.xlsx (9.5 KB)

Note: rows from 12 to 14 would variable, it may increase or decrease.
Thank you.

8

Hi @Raghu_km ,

Please check to this sample workflow
GetCellRange.zip (12.1 KB)

Thankyou

1 Like
9

@Raghu_km

Look up or filter will be done on result whichis constant…and accordingly whatever is the value is next cell it would be raken…only constant thing here are the column names and result

Hope this helps

Cheers

10

Thanks for your help. finally its resolved.

11

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