UiPathTeam.Excel.Extensions.Activities 1.0.4

UiPath Excel Extended Activities

This .Net Workflow Activity library allows easy integration with Excel. The Activities will mimic human actions. It also works with large excel files

Installation

UiPath Studio

Package Manager -> Right Click -> Configure Sources -> Add https://gallery.uipath.com/api/v2.

This .Net Workflow Activity library allows easy integration with Excel. The Activities will mimic human actions. It also works with large excel files

Package has following activities:

Excel scope: It accepts Excel file name.
Activate Sheet: Sheet on which you want to work.
Find All: It accepts input string and will return all the cells that have the value.
Go To: To activate the cell or to move cell position (right, left, up, down, lastrow, lastcolumn)
InsertOrDelete: Insert/delete row/column.
Get Sheets: It will return all the sheets that are present in the workbook
Font Style Change the font style(EntireRow/ActiveCell).
Fill Color: Change color of the cell.
Read Cell: Read Cell Value(ActiveCell/ Cell name).
Write Cell: Write value in cell(ActiveCell/ Cell name).

Problem statements
Sometimes UiPath Studio/Robot throws an out of memory exception when excel has a large amount of data in it.
Manipulating Datatable becomes tough for Non-Developer.
Maintaining the format of the excel becomes kind of tough.
Problem Statement 1
For example, if I have an excel which has Vendor details in it. It has 1000K rows and 60 columns in it.
I need to edit the details of one Vendor which has only 4 to 5 rows out of 1000K 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<String> which will have $D$78, $D$111, $D$130,
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

Problem Statement 3
Maintaining the format
For example, if we have a template for Invoice and we want to add items to 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.

This .Net Workflow Activity library allows easy integration with Excel. The Activities will mimic human actions. It also works with large excel files

Package has following activities:

Excel scope: It accepts Excel file name.
Activate Sheet: Sheet on which you want to work.
Find All: It accepts input string and will return all the cells that have the value.
Go To: To activate the cell or to move cell position (right, left, up, down, lastrow, lastcolumn)
InsertOrDelete: Insert/delete row/column.
Get Sheets: It will return all the sheets that are present in the workbook
Font Style Change the font style(EntireRow/ActiveCell).
Fill Color: Change color of the cell.
Read Cell: Read Cell Value(ActiveCell/ Cell name).
Write Cell: Write value in cell(ActiveCell/ Cell name).

Problem statements
Sometimes UiPath Studio/Robot throws an out of memory exception when excel has a large amount of data in it.
Manipulating Datatable becomes tough for Non-Developer.
Maintaining the format of the excel becomes kind of tough.
Problem Statement 1
For example, if I have an excel which has Vendor details in it. It has 1000K rows and 60 columns in it.
I need to edit the details of one Vendor which has only 4 to 5 rows out of 1000K 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<String> which will have $D$78, $D$111, $D$130,
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

Problem Statement 3
Maintaining the format
For example, if we have a template for Invoice and we want to add items to 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.

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
1.0.4 (current version) 28,210 4/1/2018