How to find the next cell value if the previous value is known

Help Studio
, ,
1

Hi guys,

I have a query.

How to find the next cell value in a excel file if the previous value is known

In this excel file suppose I have the value “Rishabh”.

Demo-2.xlsx (8.6 KB)

How can I get the value “Sardul” ??

Logic should be dynamic.

Regards
Nirmalya

2

Hi @nirmalya.sarkar

Here is the workflow

Sequence.xaml (8.4 KB)
Demo-1.xlsx (8.6 KB)

image
image1252×693 43.3 KB

Regards
Gokul

3

Hi @nirmalya.sarkar ,

Try with Get cell Value.

4

@Gokul001 ,

What is the activity you have used here??

image
image588×545 13.4 KB

Regards,
Nirmalya

5

Hi @nirmalya.sarkar

We can try using getting the index value using lookup datatable and by incrementing the index from the index we can get the desired result!

Please refer to the screenshot below!

Uploading: image.png…

Regards

6

Hi @nirmalya.sarkar

Go to Manage package → update the UiPath.System.Activities

Message Box

Regards
Gokul

7

@pravin_calvin ,

Please give me the screenshot once again.

It is not showing here.

Regards,
Nirmalya

8

@Gokul001 ,

By using this flow I am getting all the values under “profession” column.

But my requirement is little bit different.

How to find the next cell value in a excel file if the previous value is known

In column name “profession” the"developer" value is already known. How can I get the “Actor” value using dynamic logic.

Regards,
Nirmalya

9

Hi @nirmalya.sarkar

Refer to the screenshot below!

image
image1201×738 41.1 KB

Regards

10

Hi @nirmalya.sarkar

Here is the workflow

Sequence.xaml (8.5 KB)

image
image1251×737 46.4 KB

Regards
Gokul

1 Like
11

Hi @nirmalya.sarkar

If your query is resolved, Kindly mark the appropriate post as solved.

So it will help for others user

Regards
Gokul

12

@Gokul001 @pravin_calvin @KODI_SRIHARI

thank you guys for your continuous guide.

Regards,
Nirmalya

13

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