Find/Replace Excel activity

Help Studio
, ,
1

Hi,

I want to use this activity to find empty cells in a range on an excel sheet and put another value in it.
I know how to use the activity, but don’t know what to put in the field ‘Value To Find’ to detect empty cells. I tried “”, but this will not work, neither leaving the field empty. Any suggestions?
I can read the range to a datatable, replace the ‘empties’ with linq and write back to excel, but I want to avoid this. I prefer to work straight in excel and want to solve the initial wow.
image

2

@TALLIEU_Johan
U can use

String.Empty

Thanks
VP

3

Hi @TALLIEU_Johan ,

Can you use Nothing instead of “”

Thanks

4

UiPath translates this as “”, so same issue persists

image
image949×105 7.08 KB

5

With Nothing, UIPatch searches for null, but no sucsess
image

The error I get does not say a lot:
image

6

Under the “Find What” field, leave it blank to find all blank cells.

So you need to delete the “” and leave that field completely empty!!!

7

That does not work apparently

image

8

did you try this " " ?

if not give a try

Regards

9

Yes, I tried this. It don’t works because the cells are empty and containing no space.

10

Rather than using String.Empty, please use Type.Missing
I hope that works for you! :innocent:

Happy automation!