Using try catch in the process of fetching data from the excel to website form filling?

excel
uiautomation
orchestrator
activities
studio

#1

Hi Team,
I know its possible without try catch , but i need to make use of it.
My task is to extract data from the excel sheet and finally enter those values into the form.
Eg:- Excel data may be (Name) : (Age) : (Country)
___________________John ____ 23 __ Sri lanka
____________________ Alex ____ 27 __ USA
____________________Melvin ____ 35 __ UK
And I want to make sure that I make use of try catch in order to handle the exceptions.
Please note that the exception that are encountered are

  1. age value is not numerical (this is just example please don’t find logic here)
  2. the age value cant be more than 100( again just example so don’t find logic here.)

If non of the exceptions occur (form is submitted). But if any of the exception is there then handle them. Like get out some message box(stating the particular exceptions are occured.) and proceed.

So far I have red the data into datatable variable and using the for each row loop to enter the values. Which is working fine.

I am not very much familiar with TRY-Catch. So I need to learn that.

Please let me know how do I do the above thing.

Thanks and Regards,
Engineering Fail


#2

You can alawyas put Throw activity to your process. When exception meet throw exception


#3

Well. I am very much thankful to you, that you responded on such a short notice. But as I said, I am not very much familiar with TRY catch thing.

Can you tell me how do I implement it in my case.
I’d appreciate hai friend.

Regards,
Engineering Fail.


#4

Or rather can you tell me if there are any exception in uipath which might handle these cases:-

  1. The age is not a numeric value
  2. the age value is more than 100