My need your help to solve below issue.
- Open excel and read AG colum contents
- if AG column values contains “na”
- delete that data row from excel - do it for all rows
5.Do the same for next excel file in directory
I have tried to use “Remove data row” activity inside for each inside excel application scope but it didnt work.
Can someone suggest better way to do this ?