BalaReva.Excel.Activities

[Mchande (Minesh)]

Hi @balupad14 is there a way to pass dynamic in path value in “Copy To file” Activity? I have an excel file that gets generated every day with date at the end of file name and need to copy the sheet in that file to a separate excel file. The Second Excel file already has the same sheet name where i need to copy the content

[balupad14 (Balamurugan)]

Hi @Mchande,

Yes. My all activities are dynamic parameters. you can use it like below that i have attached sample xmal for you a sample.

CopyFile.zip (2.0 KB)

Regards
Balamurugan.S

[Mchande (Minesh)]

Thanks Bala

[varunk (Varun Kumar)]

HI @balupad14,

for removing duplicate & identify the duplicates in excel we have anything for that

[balupad14 (Balamurugan)]

HI ,
It doesn’t have now . But end of day I have a plan to upload the activity. Once it is uploaded,I will give a ping to you.

Thank you

Balamurugan.S

[balupad14 (Balamurugan)]

Hi Friends,

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

Namespace

---

Properties

---

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

[varunk (Varun Kumar)]

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

[balupad14 (Balamurugan)]

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

[tranthao240495 (Thao Tran)]

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

[balupad14 (Balamurugan)]

Hi @tranthao240495,

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

Regards
Balamurugan.S

[Aastha_Verma]

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

Whereas my excel file is not read only

[balupad14 (Balamurugan)]

Hi @Aastha_Verma,

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

Regards
Balamurugan.S

[Aastha_Verma]

Task2.xlsx (9.0 KB)

Here is the attached sheet

[Aastha_Verma]

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

[balupad14 (Balamurugan)]

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

Regards
Balamurugan.S

[Eric.163 (eric chen)]

Hi

I found a small problem, can you help solve it?
When “Get Sheets Name” is used in the loop, the output of “sheet name” is wrong…

Thanks!
B.R.

There is only one page in these xls file,but this activity will accumulate output.

[Paresh]

Hi @balupad14,

I want to use Rename work sheet activity in for loop of excel files. I want to rename sheet of each excel file with the name of excel. But when i am using it without for each it is working for single excel file. Using For each activity its not working and not even giving an error or exception. Please help me if you can. Thanks!

[balupad14 (Balamurugan)]

Hi @Paresh,

Apologies for the delay reply. Can you please share the error screen shot.

Regards
Balamurugan.S

[ndivya (Divya)]

I want to know whether if this package is removed from Uipath packages then our work flow will not be executed right,as this package is not created or authorized by Uipath Team.Can you please confirm on this

[balupad14 (Balamurugan)]

Hi @ndivya,

Thank you . Still now it is in the UiPath Gallery.I hope, UiPath will not remove this package from UiPath Gallery.Because it reached more 22,000 downloads. It is an alternative package place is called UiPath Go. I have submitted my package too. You can expect the very soon in UiPath Go. It is authorized by UiPath. I am also expected the opinion form @loginerror and @ovi .

To know more about the UiPath Go. Please take look this.

Thank you
Balamurugan.S