What is the Exception when a sheet does not exist in the Excel Read range activity?

[Kirigirisu_Coin]

I am currently using the Excel Read range activity to read a sheet, but I would like to be able to do certain things when the target sheet does not exist.

If the target sheet name does not exist in the Excel Read range activity, is it possible to get it with Try Catch?

Note: System.Exception has a wide range of exceptions that can be retrieved, so if possible, I would like to know what kind of Exceptions can be retrieved only by checking the existence of the sheet.

Thank you for reading.

[Srini84 (Srinivas)]

@Kirigirisu_Coin

Check below

system.ArgumentException

Hope this will help you

Thanks

[pravin_calvin (pravin kumar)]

Hi @Kirigirisu_Coin

Its falls around business rule exception generally!

And we can use throw activity to throw the exception!

by specifying new businessruleException(“YourComments”)

UiPath Automation : Exception Handling Techniques | RPA UIPATH

Regards

[Jobin_Joy]

Hi @Kirigirisu_Coin

You can implement like below,

Hope this will be helpful. Thank you.

[postwick (Paul)]

Don’t put it into a Try/Catch. Designate a sheet you know doesn’t exist. Debug. The error will be shown to you.

[Kirigirisu_Coin]

I had completely forgotten that this method existed.
Thank you for telling me about it.