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

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

Project Manager

RPA Solution Architect

It can represent numbers upto crores place (-9999999999.99 to 9999999999.99). It also provides options to enter the required currency and currency subdivision.

  

**Note:**

Input Format:

The input number has to be in Decimal Format. To convert any number to decimal format you can use Convert.ToDecimal() function in UiPath Studio.

  

Exceptions:

If the supplied number exceeds the range, the following Exception will be thrown by the activity:

  

Exception Type: System.IndexOutOfRangeException

Message: Index was outside the bounds of the array.

Custom Activity that converts numbers to words in Indian Numeric Format

It also recieves an additional input for alternative name of the column. This is used in cases where the values in the first column (in the input) are blank. 

Also this activity will work even if the first column doesn't have unique value as it will append the existing content with a runnning number starting from 1.

This activity transposes the input DataTable and provides the transposed DataTable as output

SOFTWARE ENGINEER

This Snippet requires the following five arguments:

  

1\. in\_FilePath (String): The Input Excel File Path. **Required**

2\. in\_SheetName (String): The Sheet Name that needs to be read. **Required**

3\. in\_NewColumnNames (String\[\]): The New Column Names that need to be replaced with the Old Column Names or Duplicate Names. **Optional**

4\. out\_OutputDatatable (Datatable): The Output Datatable after performing the operation. **Required**

5\. out\_DuplicateColumns (Dictionary(Of String,Int)): The Duplicate Column Name as the Key, the number of Dplicates as the Value. **Optional**

This Snippet provides the feature of reading an Excel file with duplicate headers and renaming it with user specified header names

54117f40-be35-4a23-881f-08f14d2c1e63.png

This Snippet requires five arguments to be supplied:

  

**1\. in\_ArrayOfElements (Object \[\]):** The Array of Values to find the element which has the maximum occurrence. **Required.**

**2\. in\_Value (Object):** The element whose number of occurrences needs to be found. **Optional.**

**3\. out\_MaxOccurredElement (Object):** The element which has the maximum occurrence. **Required.**

**4\. out\_ElementCount (Dictionary(String,Integer)):** Output Dictionary which has each element in the list as a Key, and its number of occurrences as its value. **Required.**

**5\. out\_ValueOccurrence (Integer):** The number of occurrences of the argument **in\_Value** in the list**. Optional.**

This activity is used to find the element which has the highest number of occurrences in a list of elements.

98ef97e9-d598-4711-816a-61ad17186a8c.png

This Snippet requires the following three arguments:

  

Input Arguments:

**1\. in\_SourceFolderPath (String):** The Input folder path where the files are present and need to be segregated into separate folders. **Required.**

**2\. in\_DestinationFolderPath (String):** The destination folder path where the files need to be segregated to different sub folders. **Required.**

**3\. in\_IsOperationCopy (Boolean):** Indicates the operation that needs to be performed. True for Copy operation and False for Move operation. By default the operation is Move. **Optional.**

This Snippet is used to divide/segregate different types of files of present in a folder into separate folders based on their type

This Snippet requires the following three arguments:

  

Input Arguments:

**1\. in\_InputDictionary (Dictionary(Of Object,Object)):** The input argument is the Dictionary which needs to be Converted into a HTML Form in String Format . **Required.**

**2\. in\_FormHeader (String):** This argument is used to provide a Heading to the Form. By Default it has the Heading as ‘FormData’. **Optional.**

  

Output Arguments:

**1\. out\_HtmlForm (String):** This is the output argument which provides the Dictionary key and values as String in HTML Form format. **Required.**

  

**Note :** 

The HTML Form format used is taken from www.w3Schools.com.

This Snippet converts a Dictionary Key Value Data into a HTML Form in a String Format

Developer

The component has two input arguments and one output argument. 

  

The input arguments are:

*    **in\_DataTable**: A datatable, the one which is to be converted into HTML table.
*   **in\_NeedBorder**: A boolean variable to decide if a border is needed for the HTML table or not.

Output:

*   **out\_HtmlTable**: The resulting output string will be a HTML table with or without borders as per the input boolean variable.

The component will convert a .NET datatable object in to a HTML table

This Snippet requires the following six arguments:

  

Input Arguments:

  

**1.** **in\_FolderPath (String):** The Folder Path which contains the CSV files that need to be converted. **Optional.**

**2.** **in\_CsvFilePaths (String \[\]):** This Input argument can be used when the CSV files that need to be converted are in different locations. The Array of file paths can be provided. If the **in\_FolderPath** argument is provided then this argument is ignored. **Optional.**

**3.** **in\_SheetName (String):** The sheet name that needs to be provided for the converted output xlsx or xls file. **Optional.**

**4.** **in\_DeleteCsv (Boolean):** This argument specifies if the original CSV files need to be deleted or not. **Optiona**l.

**5.** **in\_Extension (String):** This argument specifies the file format needed. It can either be xlsx or xls. **Required.**

**6.** **in\_OutputFolderPath (String):** This argument specifies the folder path where the Converted Output xlsx or xls files needs to be created**. Required.**

  

Note:

The **in\_Extension** argument should be either xls or xlsx. If other extensions are provided, then the output file might be Invalid.

This Snippet is used to convert CSV files into Xlsx or Xls

This activity is capable of converting a data column with inconsistent date formats into a consistent or uniform format.

  

**Inputs:**

  

1\. DataTable: The data table variable which consists of a column having inconsistent date formatting (Doesn’t follow a uniform date formatting).

2\. ColumnName (of String): The name or index of the column to be standardized as a string.

3\. DateFormats: All the available string formats followed by the column have to be listed as an array of string.

4\. RequiredFormat: The uniform date format to which the column is to be converted.

  

**Outputs :**

  

1\. OutputTable: The output data table with the formatted output (The output datatable should preserve the schema of the input datatable).

  

2\. FormattingFailedIndexes: The row indexes for which the formatting has failed since a matching input date format was not found for those dates.

  

Please check the video URL attached with this upload if you have any doubts.

The activity finds a solution to the problem of DataTables with multiple date formats in the same column (of type string), by converting them to the same format