I am working on a use case to extract the data and update the same in excel and once reach to empty row, need to break the loop.
- I tried to use String.IsNullOrEmpty(“arg”) in IF activity so that once reach to empty row, process should stop the execution by executing Break loop activity. But its not working.
- I tried to add logic in TryCatch block so that once it go to catch block it should execute Break loop activity and end the process execution. But this is also not working. Process is getting stuck at Break Loop actvity.
- If I don’t use try catch block then process is failing by giving the error “object reference not set to an instance of an object”
Below is the excel am using in the process.
Please help to resolve this issue.
Thanks in Advance.