UiPath Go ! BalaReva EasyExcel Activities

[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

[c.ciprian (Ciprian Constantinescu)]

Thanks! Can you tell me why is a delay needed in Cell Font activity?

[balupad14 (Balamurugan)]

Hi @c.ciprian,

Some situations we use delay activity base on the previous activity, for example if you are executing a big bulk insert inside for loop. we use a little delay to close the connection to the sql server after that we use other activities. So the delay is having 3 default value. If you don’t want , you can put it as 0.

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Dear all,

Here i have attached a video demonstration for

• how to move the sheet in excel using uipath studio.
• how to move column (s) in excel using uipath studio.
• how to use the format painter between sheets inside excel using uipath studio.
• how to do the conditional formatting ( color scale , icon set )

Uipath excel move sheet | move column | format painter

Sample : UiPath.zip (3.1 MB)

Thank you
Balamurugan.S

[c.ciprian (Ciprian Constantinescu)]

Hi again @balupad14,

Could you have the activities done without Excel scope, like it’s done on WriteRange, so I can use it on a machine that does not have Excel installed?

Thanks!

[balupad14 (Balamurugan)]

Hi @c.ciprian,

At present No. Maybe in future

Thank you
Balamurugan.S

[Thinakar_Angappan]

Hi
Do you have any macro for filtering data in a excel , based on date range or value

[balupad14 (Balamurugan)]

Dear all,
I have uploaded a video for

• how to delete rows in excel using uipath studio
• how to delete columns in excel using uipath studio
• how to copy as picture in selected range in excel using uipath studio

Uipath | excel delete rows | excel delete columns | excel copy as picture...

Sample Project 28_DeleteRowColumnCopyAsPicture.zip (94.9 KB)

Thank you
Balamurugan.s

[Alopez (Andres Lopez)]

Hi @balupad14, first of all thank you for your amazing work. I have been using your activities for a while and they are amazing. I have ran into a problem using CopyAsPicture activity. I have a robot that goes and fetches a CSV from a website. Gets the data, puts it in an excel template I have that generates some dashboards. I then take a screenshot of part of the dashboard and send it out to some people. The robot works great while the computer is not locked but the moment I lock it and schedule the robot to run unattended it always fails at the moment it has to generate the picture from the dashboard. Below is the error it spits out. Do you have any idea what may be causing this?

Info: There’s a problem with the clipboard, but you can still paste your content within this workbook.

RemoteException wrapping System.Runtime.InteropServices.COMException: There’s a problem with the clipboard, but you can still paste your content within this workbook.
at BalaReva.EasyExcel.Sheet_Images.CopyAsPicture.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

[Alopez (Andres Lopez)]

Hi @balupad14, ignore my last comment other than the fact that you are doing amazing work. I got it to work by putting your excel scope with the activities within the uipath excel scope.

[Bhargavi_Gajula]

Hi Bala,

PFB details as i told you Change cell type activity is not working for me.Please let me know if i have to do any changes to the code.

ChangeCellType.zip (15.4 KB)