Check each column value using row each if column value is msissing collect particular Column name

i want to check all column values using row each, in each row if any cloumn do not have value i want to collect column name whose value is empty and process to next column of same row untill it competes all the column of each row.


it is creating a report with the information on Blanks in any column of any row
it is dynamic will catch all rows / cols without further definition


FInd starter help here:
Statistic_BlankCol_RixCixCName.xaml (8.4 KB)


Hope these steps would help you resolve this

  1. use a excel application scope and pass the file path as input and get the output as datatable named dt

  2. Now use a WHILE LOOP and mention the condition as

Where counter is a int32 variable with default value as 0 defined in variable panel

  1. Inside the while loop use a FOR EACH ROW activity and pass the datatable variable dt as input

  2. Now in for each row loop use a IF condition and mention the condition like this


If true it will go to THEN block where use a ADD TO COLLECTIONS activity where mention in property panel like

Collections = list_columnname
Item = dt.Columns(counter).ColumnName.ToString

And change the argument as string

Where list_columnname is a variable of type
System.Collections.Generic.List(of String) with default value as New List(of string) defined in variable panel

  1. Very next to add to collections activity inside the THEN part use a BREAK activity

  2. Next to this if condition inside the for each row loop use a assign activity like this

Counter = counter + 1

Now the list variable we have will have the
Column name with empty cell values in it

Cheers @anishakotian400