Excel is stuck and not responding when use the excel application scope

Help Activities
, , ,
1

When the robot ran to the excel application scope, excel got stuck and did not respond, and could not continue to run the following activities.
I tried using the activity below the workbook and it worked, but I had to use excel application scope because my program used some lookup or vba operations. Finally, I solved this problem by developing excel activities in C# myself.
The problem has been solved now, but I want to know the cause of the problem, whether it is the defect of UiPath product or the computer environment problem, and which specific environment configuration error caused the problem.

2

Could you please share your error with excel scope
regards,

3

@wu_jiani -
It will be one of the scenario below

  1. Size - What is the file size of the excel?, Some time because of large amount of size it may got struck.
  2. Its a macro enabled excel, and you have macro to perform some action, because of that also it may got struck.

so can you please elaborate little bit more for this scenario?

thanks
Muthu

4

It did not have any errors at the excel application scope, but will remain on this activity and cannot continue to run the following activities.

5

The file size is less than 20kb and I have tried to disable macro in excel and disable the invoke vba activity in the program, but it still can’t open excel by using excel application scope.

6

Hi @wu_jiani ,
Is it possible that the file is too large?
If it’s too big, divide it up to read
According to my understanding, the number of lines is too large and it will crash
Regards,

7

Hi @Nguyen_Van_Luong1 ,
The file size is less than 20kb, about 10 columns and less than 500 rows of data.

8

With that quantity, I think it’s no problem
Could you please share it or if it private you can send demo for me in message
I will check it for you
Regards,

9

Hi @wu_jiani ,

i encounter this kind of situation , bot remains stuck in excel application scope unless we are not killing or stop process manually.
workaround:
keep excel application scope in seperate wf. enable isolate property and provide some timeout.
by doing this robot will not stuck in excel application scope and give error if it spent timeout time in wf

10

Hi @TUSHAR_DIWASE ,
thanks for your answer, I haven’t tried this solution yet, I will try it.

11

Hi @TUSHAR_DIWASE ,
Do you know why this happened? Is there something wrong with Excel?

12

don’t know the exact reason. but UiPath team suggested this workaround for such excel application scope stuck issue.

13

Alright.Thanks a lot.