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

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.

@Kirigirisu_Coin

Check below

image

system.ArgumentException

Hope this will help you

Thanks

2 Likes

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”)

Regards

1 Like

Hi @Kirigirisu_Coin

You can implement like below,

Hope this will be helpful. Thank you.

1 Like

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

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.