BalaReva.Excel.Activities


#62

Hi Friends,

I have included a new activity in this package is called “Remove Duplicates” .

Namespace
image


Properties

image


Sample File : RemoveDuplicates.zip (7.7 KB)

Let me if you have any error.
I would be happy to get more suggestions.

Note :
Special thanks to @varunk

Thank you
Balamurugan.S


Remove duplicates in an excel file
「Remove Duplicate Rows」アクティビティについて
To remove duplicates in excel
Remove duplicates in excel
How to remove duplicate from excel
#63

Hi @Bala,

Actually here we need to provide the range
For example now we know the certain range , but after development if the range exceeds then it will fail.
for this you have any solution


#64

Hi @varunk,

The range property is a dynamic string . If you come to know that the range exceeding.Assign the range in a variable .And you can assign it to the Cell Range Property.
Regards
Balamurugan.S


#65

Hi, I tried the Hyperlink Remove. The process run with no error but hyperlinks stay. Could you help me, thanks a lot


#66

Hi @tranthao240495,

For me it is working well. Can you attach the XL to do the test.

Regards
Balamurugan.S


#67

Hi, When i am trying to create chart through this, getting error

image
Whereas my excel file is not read only


#68

Hi @Aastha_Verma,

Can you please attach the XL Sheet to test at my side.

Regards
Balamurugan.S


#69

Task2.xlsx (9.0 KB)

Here is the attached sheet


#70

All other activities am able to perform , but not able to create chart


#71

I saw the XL I didn’t understand what you are trying. Can you please attach the xmal.

Regards
Balamurugan.S