Skip to main content

Hi everyone,

 

I have noticed a strange problem with the Excel Advanced package.

Usually reading an Excel File is quite fast with Automation Anywhere. I am using the Excel Advanced : get function.

I have a virtual machine for the PROD environment and another one for the TEST environment. On the TEST environment, it is particularly slow, it takes roughly half a second to a full second to get the value of a single cell. However, on the PROD environment it is still very fast. I have no explanation for that.

I have compared and the Automation Anywhere package versions are the same. The version of Excel is in both cases the same (Microsoft®️ Excel®️ for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 64-bit). Both have the same RAM amount, same CPU...

The only difference is that I am connected to Excel through a Microsoft Account different for the PROD and TEST env (typically username-prod@contoso.com vs username-test@contoso.com )

Has anyone ever faced the same problem ?

 

 

It may be worth checking what percentage of RAM and CPU are being consumed at the time of execution. Dev machines, by their nature, will have lots of background processes running which will likely affect the execution.

In these situations I also ensure that any delays I’ve implemented in the bot can be controlled via by config file i.e. longer delays for DEV/UAT and shorter ones in PROD.


It may be worth checking what percentage of RAM and CPU are being consumed at the time of execution. Dev machines, by their nature, will have lots of background processes running which will likely affect the execution.

In these situations I also ensure that any delays I’ve implemented in the bot can be controlled via by config file i.e. longer delays for DEV/UAT and shorter ones in PROD.

I have checked that and the RAM use is well below 100 %


Hi @Augustin 

Verify if the location of the Excel file (local vs. network drive) is the same in both environments. Accessing files over a network can sometimes be slower than accessing them locally.


Hi @Augustin 

Verify if the location of the Excel file (local vs. network drive) is the same in both environments. Accessing files over a network can sometimes be slower than accessing them locally.

In both environments it is a local file in the downloads folder, given the fact I have also developed the bot that downloads this Excel file


Hi @Augustin,

does this excel file has any formula or scripts? also tell me more about the file.


@Augustin, you can try to execute the same bot to the different VM. if you are not facing any problem in different VM then there might be some issue with that specific VM.


@Augustin, you can try to execute the same bot to the different VM. if you are not facing any problem in different VM then there might be some issue with that specific VM.

That is exactly what I explain in my first post.

Sorry if I was not easy to understand, English is not my mother tongue


Reply