Match excel column value with varaible

[ashishmani (ashish mani tripathi)]

visitid.xlsx (7.9 KB)
hello everyone I have a variable in which visit id is store,
we have to search that variable value to excel, and mark “searched done” in the status column
please help me with xmal

[Yameso (Jakub Swiderski)]

Read range to data table. Then look up data table:

Type searched target column where this value should be found. Place that variable which you want to find. Place int_var in row found. Then you can write cell to F column with row equals int_var + 2

[ashishmani (ashish mani tripathi)]

i did same, but after first run no data will filled

[Srini84 (Srinivas)]

@ashishmani

Check as below

How to check value exists in Excel Sheet using UiPath (Part-1) || RPA UseCase

OR you can use using the Filter Data Table also

How to check value exists in Excel Sheet using UiPath (Part-2) || RPA UseCase

Once that done in If condition you can write to Datatable back as

Dt.Rows(index).Item(“status”) = “searched done”

where index is the counter

Hope this helps you

Thanks

[ashishmani (ashish mani tripathi)]

hi i also try this but the problem is remain change, at first run it works but at second run it goes to else part

[Srini84 (Srinivas)]

@ashishmani

Do you have anyother sheet for VisitID?

As you are searching for the Visit Id, VisitID will have multiple ID’s ?

where are you getting the VisitID value?

Thanks

[ashishmani (ashish mani tripathi)]

from the same excel,
first i take visit id from same excel, then i have check that visit it in software, if that value matched, then i have to come in same excel and and marked done in status column

[Srini84 (Srinivas)]

@ashishmani

Sorry, I didn’t get you clearly

If you are taking the visit ID from excel and entering the visit ID in a software, but where are the steps of checking the visit ID into software?

Also row(“PID”) the header is not available in the excel you attached

Thanks

[ashishmani (ashish mani tripathi)]

[ashishmani (ashish mani tripathi)]

i also try filter data table

i get this error Write Cell: The range AT does not exist.

[ashishmani (ashish mani tripathi)]

all the step i done already, the thing is that i unable to mention done status in same excel after first run

[vignesh.ks]

Hi @ashishmani

Please try the below method.

1, Use read range activity, and make output as dt.

2, Use Assign activity, create variable as 'compareDT ’ and variable type as DataTable. Assign value as below.
dt.select(“[visit id]=”+Visit_ID+“”).CopyToDatatable

3, Use another assign activity, under ‘To’ give compareDT.rows(0)(“status”) and under ‘value’ give “searched done”.

[ashishmani (ashish mani tripathi)]

can you help me with a xaml file

[vignesh.ks]

Please find the below screen shot, try this method.

Thanks.

[ashishmani (ashish mani tripathi)]

Object reference not set to an instance of an object. (i get this error)

[vignesh.ks]

Hi @ashishmani

This error will occur since no values as been passed in your variable. It means your variable is nothing.

Can you share exactly where you got this error.

Thanks.

[ashishmani (ashish mani tripathi)]

i change the code but still have same issue

when status get “already” it flow well, but when status is done, its give object refernce issue

[vignesh.ks]

Is it possible to share the xaml and excel file. So that I can validate and solve the issue.

Thanks.