Excel Advanced Not Working

Hi ,

Could you please share what error you are facing while opening excel from advance package.

Excel Session - Once you open any excel file we can provide the session name so later on in middle of code if you want to preform any action on that same excel file then just give session name so that it will link on same excel file.

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-excel-command.html/p>

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-excel-open.html/p>

https://apeople.automationanywhere.com/s/question/0D52t00001C4PBQCA3/whats-the-use-of-session-variables-in-bot-development/p>

Hi @Caleb McCurdy​ ,

Hope you are not mix matching Excel Basic and Excel Advance commands? Please share the error Screenshot along with the Code to better help you?

Hi @Caleb McCurdy​ ,

Session variables are what the bot uses to keep track of open files/applications.

If you open two excel files, it needs to know what operation has to performed onto what file/application, which is achieved through the use of Sessions.

Another benefit of using session variables, is that you can share it between bots, i.e., you don't have to jam all your excel operations into a single bot. This allows us to modularize it, which makes it reusable and easier to manage.

Now for the error you are facing, we will need some screenshots of the error, and also of your workflow so that we will be in a better position to assist you.

Kind Regards,

Ashwin A.K

Hello! Apologies for the delayed response. Here is the error I'm encountering when attempting to use an Excel Advanced command. Here it is just the Open command.

Please make sure MS office is installed and license is not expired .Plz refer below same scenrio.

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-/p>

I have the same situation from many days, Adv. excel is not working and I am using community edition. I have office installed already. It was working last yr when I was using and have some bot designed in my login that are still available.

Please suggest.

I have the same situation from many days, Adv. excel is not working and I am using community edition. I have office installed already. It was working last yr when I was using and have some bot designed in my login that are still available.

Please suggest.

Hi @Mauzey ,

Kindly check and confirm whether you are using the same session names while Opening, Writing and Closing the Excel files. 

Its actually getting frozen at exact line where we need to put open advance excel command. and there is any error handler, then throws error. So that means advanced excel is not doing anything.