Hi, Appreciate your advice and help on the below issue:
I am in the middle of Ui Path Course: “Excel Automation with the Modern Experience in Studio”, and one of the issue I encounter is the “remove duplicate” activity.
When the excel file has duplicate lines, this activity can run and save the duplicate-removed file without any issue.
However, when the Excel file does not have a duplicate line (this happens when I re-run my project to fix other issues, and the file is already duplicate-removed from previous runs), it will show the error message: Failed setting the current sheet XXX in the workbook: XXX.
My understanding and I believe the expected the result of “remove duplicate” activity should be: Removing any duplicates where applicable and do nothing when there is no duplicate, certainly not an error message when there is no duplicate.
Appreciate your help on how do fix this i.e. to make it work even when there is no duplicate lines.
Thanks Parvathy. However the Col Name is not the cause because I already changed the col Name for all my files and the project can run successfully before the duplicated rows are removed. The problem is I can’t run the project when the duplicated rows are already removed.
Main.xaml (33.0 KB)
Thanks in advance Parvathy. I have attached it.
I just don’t understand why the “remove duplicate” activity is showing the error message when there are no duplicates to remove, instead of saving the file as it is.
Hi @Gayathri_Ramanathan , thank you so much It finally worked! I added a delay and the problem disappeared. I was quite frustrated by this haha. Merry Christmas!