BalaReva.Excel.Activities


#22

Hello @balupad14,

Is there a way to keep all formatting while using the Activity “CopyToFile” ? I am copying one sheet to another Excel file but losing all tables and colors.

Thank you for your help.

Regards,

Guilherme


#23

Hi, Can you attach the sample file to test at my side. Normally it won’t loose the format.

Regards

Balamurugan.S


#24

I solved this issue without needing to copy sheets, nevertheless, thanks for your quick reply !


#25

Hi Friends,

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

Namespace.
image


Properties
image


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

Regards
Balamurugan.S


How to remove hyperlink in excel
#26

Hi @hareshjindal1,

I have released a new version 13.0.0. Now it should not have the default sheet while creating the excel file automatically.

Regards
Balamurugan.S


#27

hi @balupad14 can you tell me how to upgrade to 13.0.0 version ? from where we will be able to get this version ??


#28

Yes. you can. Currently i am using 13.0.0.

you can download it here.

https://download.uipath.com/beta/UiPathStudioSetup.exe

More detail please check this.

Regards
Balamurugan.S


#29

hi @balupad14 hi thanks for setup file but due to some reason i am unable to install beta version can u give me whole activity folder from uipath packages somehow if you manage thank you so much !!


#30

Hi, i dont have Beta version so just wanted to confirm is there also any activity for updating cell value to hyperlink ?
Thanks in advance
Mohini


#31

hi @balupad14 , can you tell me how to write unit testing code for the particular custom activity using c# ?? can you give me some example so that it will be easy for me to figure it out …
thanks in advance.!!!1


#32

Hi @mohininemade301094

I think,don’t have. But I will try to give a custom activity in my next release.

Regards
Balamurugan.S


#33

Hi, I am getting an error.


image
I tried uninstalling and installing the package. And restarting UiPath Studio. But problem still persists. Pls help. Thank you.


#34

Hi @sangasangasanga,

Which version of UiPath Studio that you are working ?

Regards
Balamurugan.S


#35

Studio 2018.2.4


#36

Hi @sangasangasanga.

Don’t open the sample project that I have attached above.

1.Create a blank project
2.Install the package.
3.Save the project and close the UiPath studio
4.Reopen the project.

I am using the Studio Version 18.3.0 beta-1.

Regards
Balamurugan.S


#37

Hi Bala,

This version also have same issue .it is also creating default sheet name in copy to File Activity but now name is different.

image

Also when i am copy paste from one .xlsm file to another .xlsx file below popup is coming.

image

DO you know what can be the issue?

regards,


#38

Hi @hareshjindal1,

Regarding the Pop Message some the formula or reference cell duplication error. Below I have attached the video, can know about this.

Note :

We can not create a new workbook without sheet. So inside the custom activity I create a default worksheet called by the name “Sheet1” + DateTime.Now.ToString(“hh_mm_ss”);
If pop doesn’t appear , the custom activity will delete the default sheet automatically. Please check you excel sheet data . If possible can you attach the Excel file to test.

Regards
Balamurugan.S


#39

Hi @sangasangasanga,

I have tested at my side it is working well. Unfortunately I don’t have the version
2018.2.4. Please fellow the steps which is in the video. Here I have attached the source.
But it is developed by the version of 2018.03.0 beta-1

HideColumn.zip (7.3 KB)

Note :

After the Installation of package , please restart the Uipath studio.

Regards
Balamurugan.S


#40

It works. Thank you :slight_smile:


#41

Hi, Where can I find the documentation or sample for add sheet? As currently, the ‘add sheet’ activity isn’t working for me.
image