How to find null values

Help Activities
,
1

A software interface for finding and replacing a value in an Excel sheet, specifying "null" as the value to find. (Captioned by AI)
A software interface for finding and replacing a value in an Excel sheet, specifying "null" as the value to find. (Captioned by AI)678×391 11.8 KB

May I ask how to find null values in Excel? I cannot directly input null values in this activities. My purpose is to search for the address in the last column

2

HI,

As workaround, how about using ReadRange then check count of columns?

image
image465×310 8.34 KB

Regards,

3

thank you very much！！

1 Like
4

This image shows the configuration settings in UiPath for the "Find First/Last Data Row" activity, with properties specified for source range, column name, and saved row indexes. (Captioned by AI)
This image shows the configuration settings in UiPath for the "Find First/Last Data Row" activity, with properties specified for source range, column name, and saved row indexes. (Captioned by AI)974×451 24.8 KB

You can also use ‘Find First/Last Data Row’ activity

There is properties to set tolerance limit of blank value cell in ‘Blank rows to skip’

5

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