Question

An unknown error occurred when executing the 'OpenExcel'

  • 12 May 2022
  • 4 replies
  • 62 views

I am encountering a common issue with opening an excel (.xlsx) file using excel advanced.

I'm running

AA Community Edition

Office365 Desktop version (licensed)

Windows 11

xlsx file is stored locally and path is correct, it was selected using the "browse" function.

xlsx file is empty, waiting to write data from rpademo site to excel

 

excel basic opens the file fine but I need functions inside excel advanced.

 


4 replies

Userlevel 3
Badge +7

Hi @Yew Kay Yan​ ,

 

  • No Excel installed: If you do not have Microsoft Excel installed on the device on which you are running bots to automate Excel-related processes, use the Excel basic package.
  • Desktop Excel installed: If you have a desktop version of Microsoft Excel installed on your computer, use the Excel advanced package in your bots.
  • Online Office 365 Excel only: If you are using Microsoft Excel 365 on a web browser, use the Office 365 Excel package for automating tasks related to Excel.

 

Note: If you are using Excel Advance Packages then you need an Office license should active.

 

https://apeople.automationanywhere.com/s/question/0D52t00000IdoYhCAJ/i-was-trying-to-run-excel-advance-package-to-read-excel-data-below-error-occurred-despite-following-the-right-steps-

 

 

If doesn't help, please upgrade or downgrade the packages then give it try.

 

 

Thanks!

Hi,

I have desktop Excel installed with paid license and I am using the Excel advanced package as mentioned in my starting post.

I have the same thing going on for a few days now, did you find a solution?

When I close the excel process in the background, it seems fixed, but when some bots have ran (using Excel), the error occurs again.

Userlevel 4
Badge +8

Hello @Yew Kay Yan​ 

 

There have been multiple fixes with Excel Advanced package. Kindly test in the latest package and let us know if you continue to face the issue. If yes, please open a case with support and share the bot agent logs (C:\ProgramData\AutomationAnywhere\Botrunner\Logs) and we can assist you further.

Reply