UiPath Go ! BalaReva EasyExcel Activities

[balupad14 (Balamurugan)]

Let me check with data and ping you…

Thank you
Balamurugan.s

[rchernysh (Roman_Ch)]

Thank you @balupad14!
On a side note. The “clipboard to datatable” will produce string-type columns, which will make the “Native group aggregation” unusable. Is there a better way to workaround it, other than looping through each column with the group by aggregation and building another data table?
Roman

[balupad14 (Balamurugan)]

Hi ,
Here is the video demonstration for find , find and replace.

Sample Project :
23FindReplace.zip (94.8 KB)

Video :

Uipath Excel Find | Search | Find and Replace (BalaReva)

Thank you
Balamurugan.S

[Haleem_Muhammad]

Hey is there a way i can use a loop to insert all the hyperlinks into an excel file

[balupad14 (Balamurugan)]

Hi @Haleem_Muhammad,

Yes it is possible …

Check this video

UiPath Excel Hyperlink Automation| Add Hyperlink| Get Hyperlink| Remove Hyperlink

Thank you
Balamurugan.S

[Parveen_Shaikh]

Hi @balupad14,

I am trying to use Freeze Rows activity to freeze output excel file header row but its giving me following error:

can you please help me on this?

[balupad14 (Balamurugan)]

Hi @Parveen_Shaikh,

Welcome to UiPath Community !

use the application scope from balareva easy excel like below.

Thank you
Balamurugan.S

[Parveen_Shaikh]

Thank you for your email. It’s working now. Thanks for your help and guidance.

[balupad14 (Balamurugan)]

You are always welcome !!!

[salvatore.quimi]

Hi @balupad14, i follow your steps but gives me the following error:

How can i do that? thanks in advance

[balupad14 (Balamurugan)]

Hi ,

Hi @uidonna.jones,

Use the excel application scope from BalaReva Easy Excel…

Regards
Balamurugan.S

[salvatore.quimi]

thanks yes I have already solved , it was my oversight

[rchernysh (Roman_Ch)]

Hi @balupad14, what is your recommendation if I need to combine Excel Application Scope to say ‘write cell’ in a loop and BalaReva ExcelScope for the same file to e.g. find a replace?

[balupad14 (Balamurugan)]

Hi @rchernysh,

Can you share a sample workflow. Maybe I can share my logic…

Thank you
Balamurugan.S

[rchernysh (Roman_Ch)]

Thank you, I found a workaround, now I have another task/issue.
I need to make a copy of the excel sheet in the same file. Do you have a solution for that? I tried CopyToFile, but it didn`t work.

[balupad14 (Balamurugan)]

HI @rchernysh,

If you want to copy in the same file, you have to use the activity “copy to workbook” .

Excel Copy Sheet 질문

HI @ssong, To copy the sheet with in file . Here is an activity called “Copy to Workbook” … Install package : [image] Usage : [image] Thank you Balamurugan.S

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Thank you
Balamurugan.S

[rchernysh (Roman_Ch)]

Thank you! Silly me… I was trying to do it within the BalaReva Excel Scope. ughh… could`ve saved so much time, had I looked at the sample first…

[c.ciprian (Ciprian Constantinescu)]

Hi @balupad14,

Your package (Easy Excel) is great, but the Excel Scope does not handle relative paths. Can you please make this work?

Thanks,
Ciprian

[balupad14 (Balamurugan)]

Hi @c.ciprian,

Thank you for your valuable feedback.I have noted your point. I will do it.

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Dear All,
I have added an activity called “Format Painter”, It is an equal functionality of excel format painter. you can copy a format from one sheet to another sheet inside the workbook.

FormatPainter.zip (33.9 KB)

Thank you
Balamurugan.S