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.
I have added some new activity in this package (27.0.0).
- Tab Color - Change the tab sheet color.
- Find Empty rows
- Hideunhide empty rows.
- Delete EmptyRows
Now I have renamed the CellFont Activity to Set Range Style.
It has the below features .
Font Style - None,Regular,Italic,Bold,BoldItalic .
FontUnderLine - Double,DoubleAccounting,Single,SingleAccounting
FontScript - Superscript,Subscript,RemoveScript
How can I use this activity to link between sheets in one workbook?
Appreciate your help. Your activities are really helpful.
Here is the video explanation about how to extract the hyperlink from Excel to Datatable.
Here is the video explanation about how to insert or update the hyperlink using datatable.
Dear all friends ,
I have included a new activity called “Merge / Append Sheet ByRow” that append/combine the excel sheets with the format.
Here is the sample …
Here the sample is that to merge / append / combine the file2 to file1 by row .
File 2 :
File 1 :
MergeSheet.zip (72.2 KB)
I just want to change the font color in excel which seems to be very easy with the easyexcel activity, but when i am running it, getting an error.
Exception : RemoteException wrapping System.NullReferenceException: Object reference not set to an instance of an object.
at BalaReva.EasyExcel.Base.ExcelActivity.HandleException(Exception ex)
at BalaReva.EasyExcel.Sheets.CellFont.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance,
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor,
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor,
your “find/replace” example works for me. However, when I am applying this to my user case. It opens an excel file and save it at a different location, please help!
Can you please send a sample one with .xmal,.proj, and excel file.
sure, can you send them to you privately?
Within Excel application Scope, i read several values from a sheet, save them as variables. (i think the sheet is still open). then I use your Excel Scope/Find-Replace, the sheet is saved at a different location. However, if I insert “close Excel application” after “read cell” activity, the excel sheet will be overwritten
Hi @spanct ,
Don’t use the activity inside the excel application scope (Uipath)…
use it outside of the scope…
you are right, however, within a workbook, if i would like to replace a variable with another variable reading from each sheet, any suggestions? thanks!
I am getting this error when I run it from their remote desktop.
Currently I do not have access to Microsoft Excel on their remote desktop. However when I ran the process on my own system with Excel I had no problem. Would like to know if Excel must be installed onto the system for the “Excel Scope” to work or could this be because of a different issue.