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. [optional : Initial Sheet Name (":First"/":Last" ) ]
  • ColumnMove - Move the columns inside sheet.
  • Paste From Clipboard - It pastes the clipboard data into the excel sheet (like excel data ,sap data or image)
  • Copy ToClipboard - It copies the data to clipboard
  • Find - It finds text inside excel and return the cell info as array and row index as array
  • FindReplace - It replace the text with give the property.
  • FindLastRow - It finds the last row of the sheet. I never uses the cell range.
  • FindLastColumn - It finds the last column of the sheet. I never uses the cell range.
  • CellFont - Change the Font name, Size, Style, Underline, Font Color ,Effects to the cell or cell range.
  • Get Table Names - It gets the table from the sheet . It is very useful for sorting data activity.
  • Delete Column - It deletes contiguous Columns inside excel sheet.
  • Delete Rows - It deletes contiguous Rows inside excel sheet.
  • Get TableName - Return table name . it helps to very the table exists or not before do the sorting.
  • Cell Font - It is an activity to change the Font Name,Size,Style,Color,Underline,Strike through,Script.
  • Refresh all - It refresh the pivotal table.
  • Freeze Columns - To freeze and unfreeze the columns
  • Freeze Rows - To freeze and unfreeze the rows.
  • Insert Hyperlink
  • Get Hyperlink
  • Remove Hyperlink
  • Get Column Index - Get Column index by column name
  • Get Column Name - Get Column name by column index
  • Sorting - It has a great feature that can do the sorting by multiple columns.
  • RemoveFilter - Remove / Clear filter (Table Index : -1 = clear all table filter , 1= clear first table filter)
  • RemoveNonTableFilter - Remove / Clear which is not having the table format to filter
  • Copy As Picture - Copy as Picture to the selected range of cell (Optional: Save as picture file )
  • Format Painter - Copy the formatting from one item to another.


    image

Note :

All the activities work inside the BalaReva Excel Scope. Except Zesty activities

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.

Latest package :
BalaReva.EasyExcel.Activities.24.0.0.nupkg (48.3 KB)

Install the package in local :

Thank you
Balamurugan.S

18 Likes
Updating excel file
How to extract HyperLink/s from each cell in a excel Datatable
BalaReva.Externals.Activities
Display Datatable in a form
Body of the email
Excel sorting by similar name
Excel 列の取得方法
3 excel files with same headers but different data, needed to be inserted on an existing excel file
Copy data from Excel
How to get the datatable tablename in uipath
Can i change an Excel cell format without VBA plz?
Need to change the format of cells in EXCEL plz
How to go last row & last column of cell
Rearrange sheettabs in excel
Strike-through cell content in Excell
How to return a cell value in an excel file given the location of another cell with a specific search string in it
Delete Specific Rows in Excel Containing particular String
Excel Application Scope not showing Excel message boxes and errors
How to AutoFit All Columns in Excel
Copy Excel Sheet to Clipboard
How to use two read range with "Add header" using uipath
How to get Row and Colum index separately when searching a value in excel
How to copy one excel row to paste in another excel update row
How to copy data from one excel workbook to another excel workbook
Converting date format in an excel cell into another date format
Read url from excel
Excel automation rows and columns
How to write Data into excel without overwrite
Copy paste from notes to excel or database
Extract Charts from Excel & insert them in send exchange mail
Extract Charts from Excel & insert them in send exchange mail
Copy existing charts from excel to powerpoint

**

  • Move Sheet Activity

**
Properties

Regards
Balamurugan.S

5 Likes

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

4 Likes

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

4 Likes

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

2 Likes

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…)

Thank you
Balamurugan.S

2 Likes

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”)

Sample : ExcelCopyPaste.zip (26.4 KB)

Thank you
Balamurugan.S

3 Likes

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 and row indexes.

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

image

Regards
Balamurugan.S

5 Likes
Excel Search
Search for cell details and copy corresponding row in Excel
Split data in excel search in website
Excel Automation Delete the Cell Values
Find the perticular data in excel sheet
Find Range of cell using column Name
Urgent help
How to find the email address in a particular row and column of a datatable
EXCLE Automation and Selecetor Challange
How to get the columnname of a specific value in a row without getting knowing the column name or row
Copy Specific Excel Data to Another Worksheet?
Find position of a cell
Remove multiple Data column
Excel column operation
Get row index of a Selected Cell in Excel
How to search for a specific word from one excel to another excel and highlight that keyword
In Excel particular serial need to search and get the relevant data
Is there any way to search keyword in excel rather than to use Ctrl+f?
How to perform a keyword search in Excel
Excel : search a value and retrieve data
Excel内を検索して置換 Search and replace in Excel
Get column values
BalaReva.Externals.Activities
How to find and add subtotals of values in the data table
Excel Alignment Right and Replace
How to replace particular cell value in excel
Replace value in Excel
Delete rows from Cell (A) To Cell (B)
Remove all digits after ","
Find and replace string in whole excel file
Find and Replace in Excel
How to find correct value in one sheet using value in another sheet of excel?
Hide Excel Row Based on Cell Ref Name?
I want to find a particular value in column A and have to take corresponding coloumn B value and copy in other location
Find cell with String Value and get no. of row, name of column
How to check if a specific row in an excel table contains a specific alphabet or character?

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 .

Here is the video demonstration.

Regards
Balamurugan.S

5 Likes

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.

Regards
Balamurugan.S

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

4 Likes

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

5 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

2 Likes

I have developed a new activity to delete column . 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

2 Likes

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

2 Likes

I am using ur activity, it is like magic, thank you so much

1 Like

HI @Saranyajk,
Thank you…

2 Likes