UiPath Go ! BalaReva EasyExcel Activities

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

Dear All,

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

Thank you
Balamurugan.S

Dear all,

Now I have renamed the CellFont Activity to Set Range Style.

It has the below features .

FontName
FontSize
Font Style - None,Regular,Italic,Bold,BoldItalic .
FontColor
BackgroundColor
FontUnderLine - Double,DoubleAccounting,Single,SingleAccounting
Strikethrough
FontScript - Superscript,Subscript,RemoveScript

Regards
Balamurugan.S

Hi @balupad14
How can I use this activity to link between sheets in one workbook?

Appreciate your help. Your activities are really helpful.

Dear All,
Here is the video explanation about how to extract the hyperlink from Excel to Datatable.

Thank you
Balamurugan.S

Dear All,
Here is the video explanation about how to insert or update the hyperlink using datatable.

Thank you
Balamurugan.S

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 :

Output :

Sample :
MergeSheet.zip (72.2 KB)

Thank you

Hi Bala,

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,
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 @sneha.kumar,

Check this.

Regards
Balamurugan.S

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!

Hi,

Can you please send a sample one with .xmal,.proj, and excel file.

Thank you
Regards
Balamurugan.S

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…

Thank you
Balamurugan.S

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.

How to get hyperlinks of multiple cells. For single-cell, I can use get hyperlink by providing cell value. but dynamically how can we do.