Exception Handling for Excel Automation

[Luffy]

Greetings to all.

I’m trying to validate two excel files, but if the data isn’t there after the two files are matched, how can I handle the exception for this process?

[raja.arslankhan]

@Luffy put that activity in Try block of “Try Catch Activity” and put systems exception and put throw activity and give it proper log message.

[prateek.mehandiratta9 (Prateek Mehandiratta)]

@Luffy

this process?

Another work around:

You can read both excels, figure out the row count and then put a ocndition on the row count and throw the exception with a custom message.

Thanks.

[Luffy]

@raja.arslankhan in Catche Block along with log messages what else we can do?

[Luffy]

@prateek.mehandiratta9 In Catche Block i want to handle the error more effectively, So what else i can do?

[raja.arslankhan]

@Luffy You can Send Email.