Excel column row value is empty or not

I want to check how many rows have 0 value of a specifik column…

Tabel is: DT1

DT1 tabel have 6 column and 4 rows and 1 header row… so in total 5 rows in DT1 which has 6 column.

I want to check how many rows have 0 or null value of a specifik column or you can choose column number 6.

can someone help me… as i always have issue in excel :frowning:

Hello, I think you want a solution in UiPath:
A simple way would be to use a “for each”-loop over the DT1. Inside the loop you check the the value of that column and if it is empty you will increase a counter by 1.
In Excel you can filter the records by selecting/deselecting empty values and the remaining number of rows will be shown at the bottom of the screen.

The condition is check empty or null is given below:

If (String.IsNullOrEmpty(row(0).tostring) and String.IsNullOrEmpty(row(1).tostring) and String.IsNullOrEmpty(row(2).tostring) and String.IsNullOrEmpty(row(3).tostring) and String.IsNullOrEmpty(row(4).tostring) and String.IsNullOrEmpty(row(5).tostring))

EmptyCount = (From x in DT1.AsEnumerable Where x.Item(6) is Nothing or x.Item(6).ToString.Equals("") Select x).ToList.Count