Workbook Does Not exist

Help Activities
, ,
1

the workbook is not exists in Read excel, this error is not coming continuously. I am not able to identify it. i have tried almost everything (TRY CATCH, Kill Excel , Checked variables)

1 Like
3

Hello, @Krati_Rajoriya1
Can you please provide more info about the error you are getting or even attach a printscreen?

Happy Automation :robot:
Hugo Varela

4

Hii ,
Thank you for the reply
I am running my flow which downloads an excel file and reads data from it, While reading data this error came “The workbook does not exist”. This error came sometimes, I have tried try-catch but still in the catch, it throws this error.

And the main problem is this error is not coming continuously, it’s coming sometimes only.

5

Hi @Krati_Rajoriya1

You can try giving delay before reading the excel.

Thanks.

6

you can use" do while " To control the abnormal situation，Use try catch in it ，If there is an exception, try again

7

WorkBookDoesNotExist
WorkBookDoesNotExist1284Ă—531 49.3 KB

Hi,
here is the Screenshot, I have tried all the above solutions. but the error remains the same.

8

@Krati_Rajoriya1

You can try using retry scope activity. So if in first run the excel doesn’t exist, it will retry to read the excel again. You can provide the times of retry in activity properties. Thanks.

Feel free to reach us at any time if you have doubts.

Happy Automation.

9

Hello, can you please tell or show me what’s your “FilePath” value?

10

Hi Krati,

Please use:
Wait for Download Activity.
image

This activity waits for the file to be downloaded completely and then proceeds with the other activities in your solution.

Hope this helps!

1 Like
11

@Krati_Rajoriya1
Make sure the file is downloaded properly before accessing it

U can use wait for download activity to make sure file is downloaded as suggested by @juveria.siddiqui