RPA Log Hub

You can do Excel Automation in UiPath in four different ways: Using UiPath Activities. Using LinQ. Using Macros (VBA). 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 E...

So there are various ways to define the Array, List and Dictionary in UiPath. Take Assign Activity and Put your variable at left side with a data type defined with "New" keyword then write the below lines at the right side. Array New String(){"Blue", "Green"} List New List(Of String) ({“value1”,”value2”}) New List(Of String) from {“value1”,”value2”} New List(Of String)(New String(){“value1”,”value2”}) Dictionary New Dictionary(Of String, Object) Thanks!