Failed To Read Excel

Help Something Else
,
1

Hi All,

Bot is Getting failed. the reason is Excel is not in ready state. please make sure you are not editing cells and that no dialog windows are opened. Kindly help me fix the issue. I Could see excel is closed properly in some other machines but even though I’m getting this error any suggestion?

2

Hi @Buvaneshwaran_R
Kindly use workbook activities and give a try

Also I would recommend you to have kill process activity mention in properties process name as :EXCEL and continue on error set as true

Hope this helps
Thanks

3

Hi @nikhil,

I have included those condition as well but still it’s throwing as an error.

4

Can you share us the exact error message @Buvaneshwaran_R

5

Also try to upgrade the package and give a try @Buvaneshwaran_R

6

hello @Buvaneshwaran_R ,

Is it a shared excel? Or are you trying to open the excel which is in your local machine?

7

Hi…

First Check the file path.

Share the output Error Screenshot…

Thanks
Shyam

8

Did you met any problem with a shared excel? I have a shared Excel in a sharepoint folder, and when the robot tries to open it, it gets the same errror

image
image1152×98 4.82 KB

9

Hi @Buvaneshwaran_R

→ Just check once opening the Excel file manually and make sure that it opens without any errors. If the file does not open manually, then it is likely that the file is corrupted or that there is a problem with Excel on the machine.
→ And also Try running the bot on a different machine to cross check.

10

I got the same error, and was fixed by removing unnecessary links on the Excel file (File, Info , “Edit Links to File”). Hope this helps.