UiPath Go ! BalaReva EasyExcel Activities

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