Activity for excel

good day guys,

how can i get cell location value(ex: A33), which is the null value of the A column? (the end of A column)

PS: each columns has difference of the rows.

Thanks

Hi @David_Choi, welcome to the uipath community!

Try the following:
Populate the excel in a data table (read range activity)
Loop through the rows using the for each row activity
Search for null value in each column.

Is that it what you had in mind?

Regards

Hi @David_Choi,

Try the below attachment file
test.xaml (6.7 KB)