Workbook Does Not exist

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)

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

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.

Hi @Krati_Rajoriya1

You can try giving delay before reading the excel.

Thanks.

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

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

@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.

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

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

@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