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
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
Hi, Can you attach the sample file to test at my side. Normally it won’t loose the format.
Regards
Balamurugan.S
I solved this issue without needing to copy sheets, nevertheless, thanks for your quick reply !
Hi Friends,
I have included a new activity in this package is called “Remove HyperLink”.
Namespace.
Properties
Let me if you have any error.
I would be happy to get more suggestions.
Regards
Balamurugan.S
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
hi @balupad14 can you tell me how to upgrade to 13.0.0 version ? from where we will be able to get this version ??
Yes. you can. Currently i am using 13.0.0.
you can download it here.
More detail please check this.
Regards
Balamurugan.S
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 !!
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
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
I think,don’t have. But I will try to give a custom activity in my next release.
Regards
Balamurugan.S
Hi, I am getting an error.
I tried uninstalling and installing the package. And restarting UiPath Studio. But problem still persists. Pls help. Thank you.
Studio 2018.2.4
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
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.
Also when i am copy paste from one .xlsm file to another .xlsx file below popup is coming.
DO you know what can be the issue?
regards,
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
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
It works. Thank you
Hi, Where can I find the documentation or sample for add sheet? As currently, the ‘add sheet’ activity isn’t working for me.