UiPath Go ! BalaReva EasyExcel Activities

Help Marketplace
, ,
118

Yess Bala.It worked now.Thank you so much :smiley: :smiley:

2 Likes
119

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

120

Dear All,

Here I have attached the sample with video that how to embed the Excel chart in PowerPoint.

image
image819×421 12.2 KB

Sample :
ExcelChartPowerPoint.zip (126.7 KB)

Video :

Thank you
Balamurugan.S

121

Hye @balupad14 I can’t find this activity in the update 2020.2.0

122

Hi @Eizzuddin_Zaid,

The package name is BalaReva.EasyExcel.Activities (25.0.0)

Here is the screenshot.

image
image1125×682 92.6 KB

Thank you
Balamurugan.S

2 Likes
123

Dear All,

I have added some new activity in this package (27.0.0).

  • Tab Color - Change the tab sheet color.

image
image1920×791 47.4 KB

  • Find Empty rows
  • Hideunhide empty rows.
  • Delete EmptyRows

image
image363×520 10.8 KB

Thank you
Balamurugan.S

124

Dear all,

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

image
image1862×795 145 KB

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

125

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

Appreciate your help. Your activities are really helpful.

126

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

Thank you
Balamurugan.S

127

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

Thank you
Balamurugan.S

128

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 …

image
image1852×809 79.4 KB

Here the sample is that to merge / append / combine the file2 to file1 by row .

File 2 :

image
image1895×785 92.7 KB

File 1 :

image
image1886×868 106 KB

Output :

image
image1894×935 127 KB

Sample :
MergeSheet.zip (72.2 KB)

Thank you

129

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.

image
image1819×744 61.5 KB

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)

130

Hi @sneha.kumar,

Check this.

Regards
Balamurugan.S

131

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!

132

Hi,

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

Thank you
Regards
Balamurugan.S

133

sure, can you send them to you privately?

134

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

135

Hi @spanct ,

Don’t use the activity inside the excel application scope (Uipath)…

use it outside of the scope…

Thank you
Balamurugan.S

136

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!

137

I am getting this error when I run it from their remote desktop.

error1
error1779×349 34.5 KB

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.