Hi ,
Hi @uidonna.jones,
Use the excel application scope from BalaReva Easy Excel…
Regards
Balamurugan.S
Hi ,
Hi @uidonna.jones,
Use the excel application scope from BalaReva Easy Excel…
Regards
Balamurugan.S
thanks yes I have already solved , it was my oversight
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?
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.
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…
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
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?
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
Dear all,
Here i have attached a video demonstration for
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
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
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)
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.
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)