Excel Automation Using UiPath

You can do Excel Automation in UiPath in four different ways:

1. Using UiPath Activities.
2. Using LinQ.
3. Using Macros (VBA).
4. Using Excel as a Database.

Lets go with one by one :

• Using UiPath Activities

Excel Application Scope:

In this You can use Read Range Activity to read all the data into the DataTable.

You can use the Read Cell Activity to read the data one by one into the Generic Format.

You can use Loops on your DataTable.

You can Filter DataTable Activity to filter out your data.

Workbook:

Even if excel is not installed in your system, then also you can use these activities to read or write excel.

• Using LINQ

You can use LinQ queries to Filter out the data directly on DataTable or List. In this case you cannot use Read Cell Activity.

Read More About LinQ from here: Click here

LinQ Syntax.

LinQ Queries Used for Filter Out the Data.

• Using Macros (VBA)

You can use macros also, not for Excel but you can do any type of work from Macros. VBA code is easy like a English language. For large Amount of data, it is recommended to use Macros while performing automation of Excel.

Read More About Macros: Click here

• Using Excel As a Database

You just ODBC drivers and you can connect your excel with UiPath and then you can put some SQL queries. it works as smooth as possible. You can use it as your database, it reads and edit all data from background.

Read it how you can use your Excel as a database. Click here: