28924d16-e7fd-4d2b-bac6-71fdce75f4ab.jpg

Below is the detailed overview of the activites provided in the package:

  

**1\. Select Top N Rows**

**Input** : DataTable, Row Number

**Output** : DataTable with first N row specified by the user

Note**: Row Number starts with 1.**

  

**2\. Select Bottom N Rows**

**Input** : DataTable, Row Number

**Output** : DataTable with last N row specified by the user

Note**: Row Number starts with 1.**

  

**3\. Select Custom N Rows**

**Input** : DataTable, Starting Row Number, Ending Row Number (Optional)

**Output** : DataTable with rows starting and ending as specified by the user. If the ending row number is not specified it will take until the last row of the given DataTable. 

Note**: Row Number starts with 0.**

  

**4\. Select Particular columns**

**Input** : DataTable, column names (array(string))

**Output** : DataTable with columns only specified by the user

  

**5\. Remove Particular columns**

**Input** : DataTable, column names (array(string))

**Output** : DataTable with columns not specified by the user

  

**6\. Search Row Index**

**Input** : DataTable, column name, Search value

**Optional** : SearchFrom (Top or Bottom), Search Instance (Instance of the row to be searched ex: 1,2,3etc..)

**Output** : Row index.

  

**7\. Convert to Html Table**

**Input** : DataTable (Required) 

**Header Styles Provided :** Header Font Family, color, size, style and header background color.

**Border Styles Provided :** Border color, border size and border style, checkbox to select and unselect border style options.

**Body Styles :** Font Family, Font Size and Font Color.

**Alternate Row Styles Provided :** Alternate Row color and checkbox to select and unselect alternate row style options.

**Output** : Html table Tag (String).

  

**8\. Convert to Collection**

**Input** : DataTable

**Output** : List containing column headers and array containing column headers

  

**9\. Add SNo Column**

**Input** : DataTable

**Output** : DataTable with Serial number column added as the first column.(auto increment)

  

**10\. Math Operations**

**Input** : DataTable, column name, Opeartion(DropDown) 

**Operations Provided :** SUM, MAX, MIN, AVERAGE

**Output** : Result of the Operation selected by the user on the particular column.

Note**: The column datatype should be numeric.**

  

**11\. Rename column**

**Input** : DataTable, column Index, New Column name

**Output** : DataTable with column name changed specified by the user.

Note**: Column Number starts with 0.**

  

**12\. Reorder column**

**Input** : DataTable, column Name,New Column number

**Output** : DataTable with column position changed specified by the user.

Note**: Column Number starts with 0.**

  

**13\. Reverse DataTable**

**Input** : DataTable

**Output** : Reversed DataTable (Bottom to Top).

The Package contains multiple activities which are used to manipulate DataTable in a more advanced way like selecting and removing particular columns and row etc..

The conversion of secure string to string can be used when working with mail activities in UiPath which requires password as string and not secure string and also during the development and testing of worflows where we want to convert string to secure string and vice versa.

  

Details of the activites in this package are provided below:

  

1.**String to Secure String**

**Input**:String

**Output:** Secure String

  

2.**Secure** **String to String**

**Input**:Secure String

**Output:** String

  

Note: The functionalities are offered to allow robots to interact directly with existing business processes. They are not designed to provide new information security paradigms, but instead a means to allow the robot to interact with the existing security that is being deployed within a business.

This package contains activities which convert string to secure string and secure string to string.

About me