UiPath Go ! BalaReva EasyExcel Activities

Hi,
I have developed some activities to make easy the excel automation.

An activity library that makes Excel automation very easy

This package contains activities that will help automate your work with Excel. The below activities are available:

  • ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images.
  • ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet.

The extracted information will be saved in a given folder.

  • MoveSheet - Order or arrange sheets inside a workbook.

image

Note :

All the activities work inside the BalaReva Excel Scope.

If the Sheet Name is empty , Automatically it will take the first sheet.
If the Cell Rang is empty. It will take the used range automatically.

UiPath Go Version : 4.0.0
Package Last version : BalaReva.EasyExcel.Activities.6.1.0.nupkg (33.5 KB)

Install the package in local :

Thank you
Balamurugan.S

6 Likes

**

  • Move Sheet Activity

**
Properties

Regards
Balamurugan.S

The new release 2.0.0. It contains the

  • ColumnMove

I have attached the package in the thread begin.
(It is a package before upload to UiPath Go).


image

Regards
Balamurugan.S

1 Like

Hello Balamurugan, nice to meet you!

I’m trying to use your “Move Sheet Activity” (on package EasyExcel.Activities, v2.0.0), but I get these error: “RemoteException wrapping System.NullReferenceException: Object reference not set to an instance of an object.”


My Workbook Sheets:

Thanks in advance, Marcelo.

1 Like

Hi @Marcelo_Vina,
Thank you for you feedback. I saw your first image. It says that you are using the Move Sheet Activity inside UiPath Excel Scope. But it should be used inside the BalaReva Excel application Scope like below.

image

Regards
Balamurugan.S

Hello Balamurugan,

Thank you for your time! Issue resolved!

I didn’t realize about the “Excel Scope”.

Regards, Marcelo.

image

The new WB:
image

1 Like

Thank you @Marcelo_Vina

Hi,
I have developed the new activity in the package of BalaReva EasyExcel Activities. It is called “Paste Clipboard” . It paste data from the clipboard . That means you can copy the data anywhere(SAP,text editors and etc…)

I have attached the package in the thread begin.
(It is a package before upload to UiPath Go).

Thank you
Balamurugan.S

Hi,
I have developed the new activity in the package of BalaReva EasyExcel.Activities .It is called “Copy ToClipboard” .It copies the excel data to the clipboard. (The BalaReva.Excel.Activities have the same activity called “CopyData”)

I have attached the package in the thread begin.
(It is a package before upload to UiPath Go).

Thank you
Balamurugan.S

Hi ,

One my friend @VanessaCova having the situation to find and replace the text inside the excel. For that purpose I have developed some activities below.

Find - Find the text inside the sheet. It will return the cell info as a array string.

FindReplace - Find and replace the text inside the excel sheet.

image

Regards
Balamurugan.S

1 Like

Hi ,
I have developed 2 new activities.

  • Find LastColumn that to find the last column Index and Column Name of the sheet .
  • Find LastRow that to find the last row of the sheet and it returns the row index.

Find LastColumn’s Properties :

image

Find LastRow Properties :
image

Note :

If the sheet name is empty , It will take the first sheet name .

I have attached the package in the thread begin.
(It is a package before upload to UiPath Go).

Regards
Balamurugan.S

1 Like

Hi ,
I have developed new activity called “Cell Font” in the version 5.0.0 . In this activity that can able to change the below things inside excel sheet.

  • Font Name
  • Font Size
  • Font Style { None,Regular,Bold,Italic,Underline}
  • Font Color - System.Drawing.Color
  • Font UnderLine { None,Double,Double Accounting,Single,Single Accounting }
  • Strikethrough { None,Yes,No}
  • Font Script { None, Superscript,Subscript }

Namespace

Properties :

Before Sheet :

After Sheet :

If the Sheet is empty , It will take the first sheet.
If the Cell Range is empty , It will take the used range.

This activity will do what it has in the below.

I have attached the package(5.0.1) in the First thread.
(I have uploaded the package in UiPath Go. Once it is published , I will remove the attachment)

Regards
Balamurugan.S

2 Likes

I have developed a new activity called “Get TableName”. It retrieves table name from the excel sheet. It returns it as List string.

Excel

Namespace :

Design Screen :

I have attached the package(5.1.0) in the First thread.
(I have uploaded the package in UiPath Go. Once it is published , I will remove the attachment)

1 Like

Good work bro @balupad14 :clap::clap:

Many people are looking for this and it will helps a lot to them.

1 Like

Thank you @lakshman… I am do many things like you people giving the appreciation and support.

Thank you
Balamurugan.S

2 Likes

Hi ,
I have developed a new activity to delete the contiguous rows in side excel sheet in the package version 6.0.0. You can get the package Here.

Important Property :

Row Range : { “1”,“3:5”,“11”,“20:35” }

Namespace :

Activity and Properties :

Regards
Balamurugan.S

I have developed a new activity to delete the contiguous Columns in side excel sheet in the package version 6.0.0. You can get the package Here .

Important Property :

Columns Range : { “C:C”,“D:F”,“G:G”,“K:O” }

Namespace :

Activity and Properties :

Note :
Let me if you have any errors.
I would be happy to get more suggestions and feedback (Possibly likes ).

Regards
Balamurugan.S

Hi ,
I have added new feature in Find activity that will show distinct Row indexes in the version 6.1.0.

Thank you
Balamurugan.S