ea74c2bd-bea1-47c7-84fe-cf399eff75d5.jpg

RPA Technology Lead

This will be useful when you want to find the number of working days between given dates. This workflow excludes Saturday, Sunday and then it will provide the number of working days. Additionally it will also validate whether the entered dates are valid or not.

Workflow for calculating the number of working days

This template is useful when you need to find the number of working days between given dates. 

  

This template excludes Saturdays and Sundays when providing the number of working days. Additionally, it will also validate whether the entered dates are valid or not.

Workflow for calculating the number of working days between given dates.

Below are the arguments that need to be provided:

1.      **ProcessName** - The name of the process that needs to be checked if its running or not (String)

2.      **IsProcessRunning** \- Returns the status of the process (Boolean).

Eg. If you want to check whether Excel process is running or not then specify **ProcessName** as **excel.** If it is running then it will give the output as **True, else it** will return **false.**

This activity can be used to check whether a process is running or not

The following activities are included in this pack:

**Get FileName**: used to extract the file name from the full path of the file.

*   Input: the full path of the file
*   Output: filename

**Rename File**: used to rename the file within a particular folder and provide the output as a Boolean value to confirm if the file was renamed or not.

*   Input
*   FilePath: the full path of the file
*   NewFileName: provide the new filename
*   Output
*   IsRenamed: A Boolean value that returns True if the file was renamed successfully and if not it will return False.

**Move Files**: used to move the files from source to the destination path. It can be used to move all files or only specific file types to the destination path.

Input:

*   TypeOfFiles: specify the type of file to be moved
*   (e.g. pdf or xlsx or docx)
*   Destination: destination path

**Sort Files**: Reads all the files from a specified folder, sort them based on several criteria and displayed the results either by descending or ascending order.

This component will read all the files from a specified folder and sort them based on CreationTime, LastAccessTime, LastWriteTime, Size, and Names.

Input:

*   FolderPath: the path of the files to be sorted.
*   SortingOrder: choose to sort the files in descending or ascending order.
*   SortingType: choose to sort the files by CreationTime, LastAccessTime,
*   LastWriteTime, Size or Name.
*   SortedFiles: an array of the sorted files.

**HideFile**: used to hide a particular file.

Input:

*   FilePath - the path of the file to be hidden.

Output:

*   IsHidden - indicates if the file was hidden or not.
*   Note: The field supports only Boolean variables.

**UnhideFile**: used to unhide the particular file.

*   Input: FilePath - the path of the file to be unhidden.
*   Output: IsUnhidden - indicates if the file was unhidden or not.

Note: The field supports only Boolean variables.

This package contains a variety of activities that will help you easily manage files

Use this activity to apply capitalization formats to any text. You can choose between Lower Case, Upper Case, Title Case, Toggle Case, and Sentence Case.

  

*   Input Text: Add the text for which you need to update the capitalization. E.g. Hello WoRLd..... the leading enteRPrise RPA software company.
*   Output: The text you inputted updated with the capitalization you selected. E.g. LowerCase: hello world..... the leading enterprise rpa software company. ToggleCase: hELLO wOrlD..... THE LEADING ENTErpRISE rpa SOFTWARE COMPANY

This activity converts a text to different capitalization types.

Using this activity you will be able to easily manage your system’s power activities such as Shutdown, Restart, Lock, Logoff or Sleep.

As an **Input** you only need to enter the **PowerType:** Shutdown, Restart, Lock, Logoff, Sleep.

This activity is used to manage the system's power activities.

This package contains the below activities:

*   **Change Column Order** - Changes the ordinal or position of the DataColumn to the specified ordinal or position.
*   **DataTable Operations** - It compares DataTables to get matched, unmatched, combine list of all rows in both tables.
*   **DataTable to Dictionary** - Converts DataTable to Dictionary.
*   **DataTable to HTML** - Writes a DataTable to HTML String.
*   **DataTable to JSON**\- Writes a DataTable to JSON String.
*   **JSON String to DataTable** - Writes a JSON String to DataTable.
*   **DataTable to XML**\- Writes a DataTable to XML String.
*   **Display DataTable Columns** - It will print all column names of DataTable.
*   **Merge DataTable Horizontal** - It will merge two DataTables Horizontally.
*   **Rename Column** - It renames the column name with new name.
*   **Replace string in DataTable** - It will help you to replace a particular string with a new string in the entire DataTable.
*   **Select certain Columns** - It helps to select certain columns from DataTable.
*   **Skip/Take Rows** - Skip/Take rows from a specified DataTable.
*   **Transpose DataTable** - It converts DataTable Columns to Rows and Rows to Columns.
*   **DataTable Aggregate Functions** - It helps to apply aggregate functions like Average, Count, Min, Max and Sum on a specified column in a given DataTable.

This package contains automations of advanced and frequently used DataTable features.

62103c10-56a7-4bb0-9f7c-065018cf8590.png

This package contains the below activities:

- **Change Column Order** - Changes the ordinal or position of the DataColumn to the specified ordinal or position.
- **CheckMandatoryColumnsExist** - Checks if all the mandatory columns exists in the DataTable.
- **ConvertArrayIntoDataTable** - Converts an array into the DataTable.
- **DataTable Operations** - Compares DataTables to be matched, unmatched, combines list of all rows in both tables.
- **DataTable to Dictionary** - Converts DataTable to Dictionary.
- **DataTable to HTML** - Writes a DataTable to HTML String.
- **DataTable to JSON**- Writes a DataTable to JSON String.
- **JSON String to DataTable** - Writes a JSON String to DataTable.
- **DataTable to XML**- Writes a DataTable to XML String.
- **Display DataTable Columns** - Prints all column names of a DataTable.
- **Merge DataTable Horizontal** - Merges two DataTables horizontally.
- **Rename Column** - Renames the column name with a new name.
- **Replace string in DataTable** - Replaces a particular string with a new string in the entire DataTable.
- **Select certain Columns** - Selects certain columns from a DataTable.
- **Skip/Take Rows** - Skips/Takes rows from a specified DataTable.
- **Transpose DataTable** - Converts DataTable Columns to Rows and Rows to Columns.

This package contains automations for advanced and frequently used DataTable features.

About me