Delete Row error 0x800A03EC

Help Activities
,
1

I’m trying to delete the visible lines of an Excel as soon as I filter my table, but it generates an error that I can’t figure out, can someone help me with that, follow the two prints for a better view.

Uploading: Erro1.png…
Uploading: Erro2.png…

3

Erro1
Erro11522×822 46.3 KB

4

Erro2
Erro21522×515 10.9 KB

5

@brunoaugustofr

Try having a delay after filter and check if this works…looks like the filter is still processing and then delete is conflicting with it

cheers

6

I’ve tried that, but the error happens the same way, I’ve looked for it everywhere and I can’t find the solution, and it seems to me to be something simple to do in an automation software

7

@brunoaugustofr

is it possible to attach the file here…I am not getting that issue when I do from my end

cheers

8

@Anil_G ,

Here’s an example, the worksheet has 200 lines, it filters by “-EX-” and should delete these lines, but the error happens without explanation for me, interesting that I did a new test and removed the last 100 lines from that worksheet, and then it works for the first 100 lines, but when I have the complete file, it is attached

teste2.zip (19.3 KB)

9

@brunoaugustofr

I just tried with same file and it threw no error…

Can you try changing the excel packages from manage packages and try…It might help if any reference is missing

I am using 2.17.0 version can try 2.16.2 as well and check if issue persists

cheers

10

@Anil_G , where can i make this package version change?

11

@brunoaugustofr

Please check this

image
image1275×690 78.7 KB

cheers

13

I changed to several versions and the error remains the same, it did not resolve.

Another error also started to appear, which would be the number of processes being opened

Erro3

14

@brunoaugustofr

May be because it stopped in between you are getting this error…check in the task manager for any background excels and kill them(Microsoft Excel is the name)

And Also I rechecked the initial error screenshots and it appears to be coming from Use excel file…can you check the properties there…did you include any read only?

The error now does not appear to come on studio or excel as for me its working may be the version of excel or some issue is present in the excel app…you can try reinstallation if possible

This has couple of issues and resolution can check that

https://docs.uipath.com/studio/docs/microsoft-office-interop-issues

cheers

16

I had that issue with 2.16.x. With 2.24.4 it works perfect.