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

MoveSheet - Order or arrange sheets inside a workbook. [optional : Initial Sheet Name (":First" - Move to first sheet . :Last" - Move to last sheet) ]

Delete Column - It deletes contiguous Columns inside the excel sheet.

Delete Rows - It deletes contiguous Rows inside excel sheet.

Set Range Style - It is an activity to change the Font Name, Size, Style, Color, Underline, Strikethrough, Script.

Refresh all - It refreshes the pivotal table.

ChartImageExtract - Extract the charts as image with index

ChartFormat - Align the chart with top, left, height, and width.

ChartCopyToClipboard - copy the chart to clipboard

ChartEmbedToPowerPoint - Embed the excel chart into PowerPoint.

Freeze Panes - To freeze the column and row

Select Cell - Select or activate the cell

An activity library that makes Excel automation very easy

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

Hello, I am not sure if you will check this. Thank you for writing this activity. But I am having a problem just running a simple get LastRow. The error is "Find LastRow: Object reference not set to an instance of an object.". I have set Sheet Name = "Apr 2020", Delay  = 1 and Row Index = lastRowIndex (variable). Is there anything I am doing wrongly?

Hi Balamurugan, I recently developed two activities for Excel that I want to share with you. I know you have done a lot of good work in UiPath, helping others in the community and contributing to the Resusable components.

I needed two activities, one to split an existing Excel file into multiple files and another to merge them back. Instead of creating yet another Custom Activity, I want you to add these two activities within your library, if that helps. Let me know, and I will be happy to share the files with you.

Hi Bala, it would be really helpful if you could please help me with building a robot that has the below mentioned objectives.

When provided with an excel sheet with 8 columns of which one is 'date' ,(1) the bot filters all the records in the excel on the basis of date and deletes all the records with previous month, (2) marks all the records with a date prior to today's date in orange color fill, (3) marks all the records with current date in red fill, (4) copies all the cells from excel pastes in outlook and sends it across to a specific mail ID.

I am new to the technology , I've done basic udemy courses, but this seems to be a challenge .

 - Nice addition to the current list of Excel Activities. Good Job!


It's a very nice Activity to handle Excel.

I dont see your activities. Download package and move it to uipath activity folder but When I open uipath studio and search some activity in manage package there is not a result

26.0.0- New activities (Tab Color,Freeze Panes,SelectCell)

26.1.0- ContinueOn Error added to all activities, CellFont Actvity renamed to Set Range Style

25.0.0 - New activities ChartImageExtract,ChartFormat,ChartDelete,ChartCopyToClipboard,ChartEmbedToPowerPoint

24.0.0- new activities Extract Images, Delete Image, Image Exists, Copy as a picture

19.1.0 - Add the Last and First to move the sheet in the Move sheet activity

20.0.0- New activity "Sorting" . Having the provisionfor multiple column.

Easy Excel Activities

Easy Excel Activities

Help

How To