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))