UiPath Go ! BalaReva EasyExcel Activities

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

Then its below error.

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 :smiley: :smiley:

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

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?