I am getting this error on “Remove Duplicates” modern Excel Activity - Remove Duplicates: 0x800A03EC
Please share more details like Studio version, package version, data you are trying and additional details which will help to reproduce the issue.
Have you checked the possible solutions suggested by @postwick ?
I searched in the forum and I could not find any good solution , can you point to that link suggested by @postwick please
Search with the error code. Here is what I found on forum try if not tried already.
Here is google search link:
That link is based on legacy Excel Activities , my issue is with modern Excel Remove Duplicates.
- Is the file very huge?
- is it a xlsx or xls file?
- if huge one alternate you can try is to read data and manipulate in datatable and write back
cheers
it is huge file like 97000 rows and I did test with less rows like 27000 rows and it did not fail with that error but did not remove dupes either. So for not until we have a fix from UiPath, I guess I have to use my old custom logic to remove dupes , kind of use Excel Scope > Use Excel > “Get Table Range” > custom “Remove Duplicates” library we have .. That works for now.
This is what not working
and this works
Did you get a chance to try the solution mentioned in the post I shared above?
That solution shared is for removing duplicates via modern activity.
I tried again not sure what i was doing wrong earlier, probably the range was not right I was using form A2 instead of A1 , may be that caused it .. but any how thank you all for looking into this but this code is working fine now , even on the original huge 97000 rows file..
1 Like
Make sure the Excel sheet or book should not be protected.
That’s good to know. Thanks for sharing.
Could you please close this topic now by marking a solution?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.