Skip to main content
Solved

Excel basic:Open gets error, how to solve this problem?


Forum|alt.badge.img+11

Excel basic:Open command gets error. Description: An unexpected error occurred. 
This task was running without error in production, but it gets error for a few days.

In development it has no error on this step.

Filepath for excelbasic:open is correct

What should I do?

Best answer by Semih 3318

I figured out that this may get error because of  the excel file capacity. Excel file is 6214kb. It was not opening with Excel basic:open
I decreased the data, then it started to run.

View original
Did this topic help answer your question?

5 replies

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+16
  • Most Valuable Pathfinder
  • 3274 replies
  • January 16, 2025

Hi ​@Semih 3318,

Any packages have been updated recently? please compare both version of package (DEV, PRD)


Forum|alt.badge.img+11
  • Author
  • Navigator | Tier 3
  • 519 replies
  • January 16, 2025

Hi ​@Tamil Arasu10 they are same version. Thanks for the reply


Forum|alt.badge.img+11
  • Author
  • Navigator | Tier 3
  • 519 replies
  • Answer
  • January 16, 2025

I figured out that this may get error because of  the excel file capacity. Excel file is 6214kb. It was not opening with Excel basic:open
I decreased the data, then it started to run.


Forum|alt.badge.img+4
  • Cadet | Tier 2
  • 5 replies
  • January 17, 2025
Semih 3318 wrote:

I figured out that this may get error because of  the excel file capacity. Excel file is 6214kb. It was not opening with Excel basic:open
I decreased the data, then it started to run.

Interesting that this was the solution, because on the documentation page it is stated that the maximum Excel file size in the Excel basic package is 30 MB not ~6 MB.

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-excel-action.html#d170493e307


Forum|alt.badge.img+1

Hola!, 

A mi me paso cuando deje un fila sin cabecera, ejemplo:

Cabecera1 cabecera2 cabecera3

Dato 1            dato2       dato3           dato4


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings