As we know we have limitations in AA when it comes to excel. Please comment how do you handle excel operations like create pivot table, format cells, etc in your automation.
excel capabilities
Normally, I use vbscript for that kind of actions. Avoids Excel errors as well, with popups and enable edit warnings, etc.
I tend to record the actions as macros in excel, then convert it to VBscript syntax and use the VBScript native package of Automation Anywhere to invoke it
![Collaborator Gold Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/982deae3-0e64-47f2-9ee9-79efeafd9f34_thumb.png)
Hi
As we know we have limitations in AA when it comes to excel. Please comment how do you handle excel operations like create pivot table, format cells, etc in your automation.
VB script and macro is the alternate solution but there is another way we normally use which is creating a java package for the required commands.
We have created a Java package for formatting the cell, once to upload the package it will work as a command and you can use it in any of your bot.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.