a2a8aa67-aa9e-4fee-8461-b805cf343b31.jpeg

Novigo Solutions is an end-to-end IT Solutions provider, specialized in full cycle IT Services and platform solutions

RPA Developer

e6653b86-6191-494c-b705-57f8d49ea57c.png

There are some Excel activities where you need to provide cell names like A1, B5, AC4 as an input. For example Set Range Color, Get Cell Color etc.

So this activity will help you find the cell names for all the columns just by providing the DataTable as an input. The output will be a Dictionary which contains column name as key and its respective cell name as a value.

This activity takes DataTable as input and returns a dictionary containing column name and the respective cell name

This Snippet requires the following 3 arguments:

  

1\. io\_InputDataTable (DataTable): The Datatable whose column type to be changed to DateTime. **Required**

2\. in\_ColumnNameOrIndex (Generic): Name or index of the column whose data type to be changed to DateTime. **Required**

3\. in\_DateFormat (String): Format of the date present in string type. (Ex: ddMMyyy) **Required**

This workflow converts the datatype of a specified column from String to DateTime

This Snippet requires three arguments:

  

Input Arguments:

**1\. in\_FilePath (String):** Path of the Excel file for reading and renaming the duplicate column names. **Required.**

**2\. in\_SheetName (String):** Name of the sheet in Excel file for reading and renaming the duplicate column names. **Required.**

  

Output Arguments:

**1\. out\_DataTable (DataTable):** This is the output argument which returns a DataTable after renaming the duplicate column names. **Required.**

This workflow detects the duplicate column names and renames it by adding the number of occurrences as suffix.

This activity requires three Inputs:

  

**1\. Source Folder Path (String):** The path of the folder from which the files need to be copied. **Required.**

**2\. Destination Folder Path (String):** The path of the folder where the copied files are to be pasted. **Required.**

**3\. File Extensions (String\[\]):** The array of file extensions specifying the types of files to be copied. If the array is empty, all files are copied. **Required.**

**4\. Contains (String):** Copy only those files whose filename contains this string. **Optional.**

**5\. Is Move File (Boolean):** Boolean specifying files to be copied or moved. If True, the files will be moved. **Optional.**

This activity scans all sub-folders present inside the mentioned folder and copies all files or selected types of files to the destination folder

This Snippet has four arguments:

  

**1\. in\_FilePath (String):** Path of the Excel file for reading and colouring the cells with special characters. **Required.**

**2\. in\_SheetName (String):** Name of the sheet in Excel file. **Required.**

**3\. in\_ColumnName (String):** Name of te column to check for special characters. **Required.**

**4\. in\_ValidSpclCharArray (String \[\]):** Array of String containing special characters which are acceptable. **Optional.**

Reads Input file and colors all the cells which contain any of the special characters except for those which are mentioned in the Array of String

Inputs:

  

**1\. Datatable (Datatable):** The input DataTable. **Required**

**2\. String (String):** The string value to be searched in the DataTable. **Required**

**3\. Start Cell (String):** First cell of the DataTable. **Optional**

**4\. Case Sensitive (Boolean):** Differentiates between capital and lower-case letters. If True: it checks with cases. If False (Default): It does not check for cases. **Optional**

**5\. Check Contains (Boolean):** If True - it checks whether any cells contains input string. If False (Default) - it checks if any cells contains the input string. **Optional**

  

Output:

  

**1\. Cell Names (List(Of String)):** List of cells with input string.

This activity is used to search a specific string in an entire DataTable and returns corresponding cell names.

The activity required the following input:

  

**Input:**

  

**Datatable (Datatable):** The input Datatable. **Required.**

  

**Output:**

  

**Datatable (Datatable):** The output Datatable with all datacolumn type converted to string.

This activity converts all datacolums datatype to string.

**Inputs:**

  

**Start Date:** Starting date from where the total days are to be calculated. This can be added by clicking on the calendar icon and selecting the date or by manually typing in yyyy-MM-dd format.

  

**End Date:** Date till where the total days are to be calculated. This can be added by clicking on the calendar icon and selecting the date or by manually typing in yyyy-MM-dd format.

  

**Days To Exclude:** Days of the week to be excluded from total day calculation. It contains check boxes with days of the week, where one can exclude a particular day just by checking the box. Multiple inputs are allowed.

  

**Dates To Exclude:** Dates to be excluded from total day calculation. This can be provided by clicking on the calendar icon and selecting the date or by manually typing in yyyy-MM-dd format. Multiple inputs can be provided by just clicking on Add Another. 

  

**Check:** When this button is clicked, it calculates the total days based on the input provided and the output will be displayed on the form. Form will remain open.

  

**Close:** When this button is clicked the form is closed.

Calculates the number of days between 2 dates excluding the days of the week and dates given as input (weekends or holidays).

This snippet takes input from an Excel file which contains the following columns:

*   **Asset Name:** Name of the asset to be added to Orchestrator.
*   **Asset Type:** Type of the asset to be added to Orhestrator (Text/Boolean/Integer/Credential).
*   **Asset Value/Username:** Value of the asset to be added. If asset type is credential, the username should be mentioned.
*   **Password:** This is applicable only if asset type is credential.
*   **Description:** Description about the asset to be added. (Optional)
*   **Status:** Status will be updated as Success when the asset is successfully added.

About me