Question

excel capabilities

  • 14 December 2023
  • 2 replies
  • 74 views

Badge +1

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.


2 replies

Userlevel 1
Badge +1

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

Badge +3

Hi @Jay 9932 

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