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

Forum|Forum|1 year ago
January 16, 2025
5 replies
114 views

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?

Excel Packages

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.

Tamil Arasu10

Most Valuable Pathfinder

Hi @Semih 3318,

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

_Tamil_

S

Semih 3318Author

Pathfinder Advocate | Tier 6

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

S

Semih 3318AuthorAnswer

Pathfinder Advocate | Tier 6

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.

Y

yssf

Cadet | Tier 2

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

B

Brady Principe

Cadet | Tier 2

Hola!,

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

Cabecera1 cabecera2 cabecera3

Dato 1 dato2 dato3 dato4