Find and replace black space in excel

New Microsoft Excel Worksheet.xlsx (7.9 KB)
image
I have to match column B, where we have to match the value of tiger
and from column E we have to match done from the status

if both value matches we have to write kolkata in cell c4. and cell c5
we have to left cell c3.

Hi @ashishmani

you can do this with single line code
Main.xaml (11.5 KB)

Regards,

Nived N
Happy Automation


is this code work here also i want to put some value in blank column.
this is critix enviroment.

Hi @ashishmani
i think it is not possible to do excel manipulations on citrix machine using excel activity using UiPath in another machine

if you can read the excel from citrix environment and store in dt1, then u can able to apply this code in datatable

for more queries i am putting certain, which u can check out

Regards,
Nived N
Happy Automation