Answer

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

Forum|Forum|10 months ago
January 16, 2025
5 replies
66 views

+12

Semih 3318
Pathfinder Advocate | Tier 6

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.

+18

Tamil Arasu10
Most Valuable Pathfinder
Forum|Forum|10 months ago
January 16, 2025

Hi @Semih 3318,

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

_Tamil_

Like

S

+12

Semih 3318
Author
Pathfinder Advocate | Tier 6
Forum|Forum|10 months ago
January 16, 2025

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

Like

S

+12

Semih 3318
Author
Pathfinder Advocate | Tier 6
Answer
Forum|Forum|10 months ago
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.

Like

Y

+4

yssf
Cadet | Tier 2
Forum|Forum|10 months ago
January 17, 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.

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