Excel Extended Activities


#1

Extended Excel Activities

These activities are meant to work on the excel. These activities will mimic exact human actions.
Problem:

  1. Sometimes UiPath Studio/Robot throws an out of memory exception when excel data is huge.
  2. Manipulating Datatable becomes tough
  3. Maintaining the format

Problem Statement 1:
For example, if I have an excel which has Vendor details in it. It has 500K rows and 60 columns in it.
I need to edit the details of one Vendor which has only 4 to 5 rows out of 500k rows.
I don’t want to store entire data into Datatable as I need only 4 to 5 rows to work on. So if I filter Datatable to get these four rows, it will be difficult to update the excel back with these updated rows.
Solution: FindAll Activity will return CellName like List which will have $D$78, $D$111, $D$130,
image
Using For each CellName you can traverse to the different cells of that row.
For example, If you want to change the price, you can use write cell activity on F78, F111, F130 for Price. In this case we are not storing the entire data in a Datatable instead you are working on the specific row.


Problem Statement 2: Manipulating Datatable is tough for a non-Developer
Solution: Use the below activities which will mimic human action like “FindAll, GoTo cell, GoRight, Goto Last Column/row” etc
image

Problem Statement 3: Maintaining the format
For example, if we have a template for Invoice and we want to add items into invoice list. If I use read range activity and get the data in datatable, then if I push it back to excel after manipulation then the formatting of the excel will be lost.
As we cannot insert or delete rows.
Solution: Insert and Delete row/column activity will add rows or column and then we can use Write range or we can write data cell by cell.
Using Fill Color and Font style activity, we can change the format and font the workbook.

I have created a demo project with sample excel. Please install nugetPackage before running the project.

Automate More!

Excel.Extended.Activities.1.0.2.nupkg (24.4 KB)

OnExcel.zip (65.1 KB)


Deleting rows from a sheet after filtering
Unable to Access Range of data in Excel using coding
Excel Activesheet
#2

Sorry i cant able to run this file. showing the below error

image


#3

You need to install this file

Excel.Extended.Activities.1.0.2.nupkg2 (24.4 KB)


#4

Please install the attached nugetpackage before running the project.

Follow teh steps mentioned in



#5

Hi Its awesome. Could you please tell how to create a nupkg files and what are the prerequisites to create it.
Starting from creating an .dll files. And is there any possibilities to add some functions in your current nupkg files.


#6

Good stuff. Thanks!


#7

Hi,

Could you please help me to create one .nupkg file for Adobe Acrobat. looking for PDF related activities such as PDF Split, Merge.


#8

@Rajtk7 You can find PDF Extended activities https://www.myget.org/gallery/uipath-community