BalaReva.Excel.Activities

#49

hi @sangasangasanga,

First of all I say sorry. Some where I have missed to add the documentation for the Add sheet. I found the problem in you xaml. You are passing the generic variable in the sheet parameter. But it has to be a string. Below I have attached the sample for the add sheet.

Note :

I really appreciate your interest. I feel so inconvenient to respond you at right.

Thank you
Balamurugan.s

2 Likes
#50

Hi Friends,

Here I have added the Documentation for the activity called “Add Sheet”

Installation Guide
InstallationGuide.zip (121.4 KB)


Properties
image


Namespace
image


Sample : AddSheet.zip (60.9 KB)


Thank you

1 Like
#51

Hi @balupad14, thanks for response. I changed the variable into string. However, the sheet isn’t adding, Is it because the excel sheet is open at the time adding sheet? Pls advise.
2808 - v5.xaml (2.1 MB)

Thank you.

#52

Hi @sangasangasanga,

If the excel sheet opened, It will not add the sheet into the excel sheet.

I saw “1409 part2”. You are adding the excel sheet inside the for loop. But before that you have opened the Excel file by Excel Application scope. Inside that you are not doing anything. My advise is that you can remove that if it is unnecessary…

image

Regards
Balamurugan.S

#53

Hi @balupad14, I cannot remove it as I am doing so that I can have an output as a workbook. Thus, i can check if the particular named sheet exists then add sheets. There is no other activity that outputs a workbook for me to check.

#54

Hi,
when we try to launch Robot on the process from Orchestrator that uses “Delete Sheet”, we have this error:

workflow: UiPath.Core.Activities : Cannot create unknown type ‘{clr- namespace:BalaReva.Excel.Sheets;assembly=BalaReva.Excel}DeleteSheet’

when the process runs from UiPath Studio works fine

Could we miss some configuration on Orchestrator or Orchestrator machine that is different from robot machine?
Note that the robot run on the same machine where we test the process with Studio

thank you
Guido

BalaReva.Externals.Activities
#55

Hi @gg_avanade,

It says that the package is missing.

Regards
Balamurugan.S

#56

Hi,

thank you, after post I found other answer and resolved with manual copy-and-paste on Orchestrator Activities directory

Regards

Guido

1 Like
#57

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

#58

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

1 Like
#59

Thanks Bala

#60

HI @balupad14,

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

#61

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

#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 Duplicate Rows」アクティビティについて
Remove duplicates in an excel file
Remove duplicates in excel
Remove duplicates in excel while its in lowercase or uppercase
How to remove duplicate from excel
To remove duplicates in 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