BalaReva.Excel.Activities

Random and other categories Community Feed
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

1 Like
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

1 Like
65

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

Capture
Capture715×471 19.1 KB
Capture2
Capture21521×695 32.4 KB

2 Likes
66

Hi @tranthao240495,

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

Regards
Balamurugan.S

1 Like
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

1 Like
69

Task2.xlsx (9.0 KB)

Here is the attached sheet

1 Like
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

72

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.

image
image601×1089 18.8 KB

image

73

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!

75

Hi @Paresh,

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

Regards
Balamurugan.S

76

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

1 Like
77

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

1 Like
78

Thanks for your reply.Suppose i have used this package now in my work flow and in future if Uipath has added it in their library,Then whether should i go to my workflow and update it to latest added library or whether my workflow still works with this old package which is not yet added to Uiapth package list.

79

Hi, Is it possible to change color of pie chart and also paste the chart on other excel sheet?

80

Hello @ireberry,

To copy the chart as image , check it here that you can take the image.

To change the pie chart color , The color comes from excel.

Regards
Balamurugan.S

1 Like
81

Hi Balupad14 !

First of all, thank you for your amazing work.
Your activities are really usefull to me, especially the merge/unmerge/autofit ones since I’m working on VBA-protected excel files.

However, I am wondering if your activities can be integrated on an “Excel Application Scope” activity ?

I’m asking this because currently I have to create one “merge cells” activity for every merging actions I wan’t to make, and each activity takes like 15 secondes to execute (I feel like the reason is each activity searches for the file path).

I’m looking forward to your answer,

Best regards,

Likezor

2 Likes
82

Hello @likezor,

Welcome to UiPath Community. Thank you for using my package. My activities are working as individually.I understand your expectation.But I have more than 50 activities for Excel. I am also having a plan like what you are expecting. Soon I will give a new release which will work into the Excel application scope.

It works inside Excel Application Scope. But it will not use the base application object from Excel Application Scope. Soon it will.

Thank you
Balamurugan.S

2 Likes