Thanks! Can you tell me why is a delay needed in Cell Font activity?
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.
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)
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?
At present No. Maybe in future
Do you have any macro for filtering data in a excel , based on date range or value
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)
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.
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)
Welcome to UiPath Community !
Thank you for using the package. I saw your workflow. Don’t use the activity inside excel application scope activity from uipath. Here is the output.
ChangeCellType.zip (55.2 KB)
My excel is closing before reaching ChangeCellType activity.What can i do for this?
Yes. The activity does the work in the background . You can’t see it visibility.
You have to give the full path of file like below.
Yess Bala.It worked now.Thank you so much
I have explained in the video.
- how to copy paste data inside excel using UiPath studio
- how to copy paste data one excel file to another excel file using UiPath studio
- how to convert the clipboard data to datatable.
Sample : 29_CopyPastDataTable.zip (98.7 KB)
Here I have attached the sample with video that how to embed the Excel chart in PowerPoint.
ExcelChartPowerPoint.zip (126.7 KB)
Hye @balupad14 I can’t find this activity in the update 2020.2.0
The package name is BalaReva.EasyExcel.Activities (25.0.0)
Here is the screenshot.