UiPath Go ! BalaReva EasyExcel Activities

Hi ,

Hi @uidonna.jones,

Use the excel application scope from BalaReva Easy Excel…

Regards
Balamurugan.S

1 Like

thanks yes I have already solved , it was my oversight

1 Like

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?

1 Like

Hi @rchernysh,

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

Thank you
Balamurugan.S

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.

1 Like

HI @rchernysh,

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

Thank you
Balamurugan.S

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…

1 Like

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

1 Like

Hi @c.ciprian,

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

Thank you
Balamurugan.S

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

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

1 Like

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

1 Like

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 )

Sample : UiPath.zip (3.1 MB)

Thank you
Balamurugan.S

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!

Hi @c.ciprian,

At present No. Maybe in future

Thank you
Balamurugan.S

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

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

Sample Project 28_DeleteRowColumnCopyAsPicture.zip (94.9 KB)

Thank you
Balamurugan.s

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)

1 Like

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.

1 Like

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)

1 Like