Thanks! Can you tell me why is a delay needed in Cell Font activity?
2 Likes
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
2 Likes
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
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)
2 Likes
Hi @Bhargavi_Gajula,
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)
Thank you
Balamurugan.S
Hi Bala,
My excel is closing before reaching ChangeCellType activity.What can i do for this?
2 Likes
Yes. The activity does the work in the background . You can’t see it visibility.
Thank you
Balamurugan.S
Hi @Bhargavi_Gajula,
You have to give the full path of file like below.
“C:\temp\Sample.xlsx”
Thank you
Balamurugan.S
Yess Bala.It worked now.Thank you so much 
2 Likes
Dear All,
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)
Thank you
Balamurugan.S
Dear All,
Here I have attached the sample with video that how to embed the Excel chart in PowerPoint.
Sample :
ExcelChartPowerPoint.zip (126.7 KB)
Video :
Thank you
Balamurugan.S
Hye @balupad14 I can’t find this activity in the update 2020.2.0
Hi @Eizzuddin_Zaid,
The package name is BalaReva.EasyExcel.Activities (25.0.0)
Here is the screenshot.
Thank you
Balamurugan.S
2 Likes