Read Range in Try Catch

Help
, , ,
1

Hello everybody!
Why it doesn’t work?
Безымянный

2

Hi
May I know the error that comes with that
Cheers @RPA3

3

Read Range: The sheet does not exist.

4

Kindly check whether the excel file been mentioned has that sheet in it
Or if it has that sheet then use KILL PROCESS activity and mention the process name as “EXCEL” and then use excel application scope

@RPA3

5

Not now. But I also need that if the file does not fit - try catch

6

If there is an error while reading the file, then I go to another process through invoke

1 Like
7

Then make sure
that you are not running in debug mode and if so it won’t get into catch block
So Run in normal mode and try once pls
Cheers @RPA3

8

What?
What change?

9

I think you are running in debug mode that’s why not getting into catch block
@RPA3

1 Like
10

not in debug mode.
Maybe the wrong exception is selected?

11

Fine what is the exception that we get along this error
We can choose that as exception type in the catch block

Cheers @RPA3

12

I do not understand. What should I change?

13

Fine
Can I have the screen shot of the error message that comes
@RPA3

14

Безымянный

15

@RPA3

use in place of “Sheet1” > ExcelWorkbookScope.GetSheets(0)

in ExcelException > worked when gives error.

Hope it will work for you!!

1 Like
16

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