This package contains more than 30 custom activities that can be applied to any Workbook, Worksheet, and Sheet data. All the components can be easily configured as they are created in a user-friendly manner.

Below you can find details about some of the activities:

Pie, Column, Line, Bar charts for the excel data Generate different chart types

Rename Work Sheet - Update the worksheet name

Hide/Unhide Apply a hide/unhide command to a sheet

Column Hide/Unhide Apply a hide/unhide command to a column

Row Hide/Unhide Apply a hide/unhide command to a row Copy Data 

Copy data to Clipboard. After the information is copied you will be able to paste it  herever you need it.

Clipboard To Datatable Convert Clipboard data to a data table

Delete Data Delete or Clear data from a specified sheet range

Merge Cells Combine multiple adjacent cells into a single larger cell

Unmerge Cells Change a merged cell back into standard cells

Comment Activities Add, delete, get, show and hide comments in specific cell

Add/Delete Sheet Add or delete new sheet to the existing workbook

Change Cell Type Change the cell range data type like (number and date ....etc )

Export WorkBook Using this activity can save as pdf

Extract Graph Image Extract all the graph save as images

In the Resources Tab I have attached the details of all the components in the document (Guide.docx).

This package consists of multiple Custom Activities that simplify processes in Excel

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Senior RPA Consultant

Visual Basic

Hi,I Need to replace multiple string in a single column. While using Find and replace activity, seems to be this activity is not working.....Can you help me how to use this activity

Hello Bala, This activity is very much useful in my scenario. But, i cannot choose/pass a particular cell information to which the image needs to be inserted into. Is there a way where i get this functionality using this custom activity?Thanks in advance!

This is great, thank you so much. Any chance you can add changing tab colours and changing tab positions? Great work!

Is this custom activity is compatible with Microsoft Office 365? Please check and advise. Thank you.

Can I format a cell to "Accounting" Option with $ with this activity? Please suggest.

Does Compataibilty Affects If I am using 2019 + Version of Studio .

I was referred to you from the forum... I have downloaded your Excel package and wan to use the EasyExcel.HyperLinks.InsertHyperlink.  

I am not sure which process to use to accomplish my task.  I have a hyperlink I scraped from a website but the hyperlink is too long so when it comes in excel it is a text string. 

We are trying to use the AutoFit Column activity within a loop but it continues to fault and gives the error that the file is already in use. Do you have any additional guidance on how to properly use this activity?

I just cant find the activitity that change the cell type...

BalaReva activities are helpful - I am a fan of BalaReva activities. It makes my work easier :)


Your activities make our automation easy - Thanks a lot bro.
These activities are very useful for us and its make our automation easier.


So much useful stuff - I found here so much useful stuff that I used to automated that took me even few hours to do (For Example Replace activity).


Keep the good work !


 - This an exhaustive list of activities that can be used! thanks


Your stuff is awesome. Along with the installation guides, it makes everything easier! Cheers.

Thank you for the very well made package - it is really helpful!

Best excel activities for begginers, functional and easy to use.

2020.1.1 - Delete sheet [remove invalid message box]

2020.3.0 - Adding ContinueOnError for all activities.

2019.10.0 - Copy Workboox Code improvement.

2019.10.1 - Enable the Requires License Acceptance.

2020.0.0 - New activity set table format.

2019.9.3 -Add the features in the export pdf for a selected range

BalaReva Excel Activities

BalaReva Excel Activities

Help

How To