Sopra Steria Group SA (commonly referred to as Sopra Steria) is a European information technology consultancy established in September 2014 upon the merger of Sopra Group SA and Groupe Steria SCA (commonly referred to as Sopra and Steria, respectively). Technically, Sopra was the company to adopt the new name, retaining its legal personality.

The primary business areas of the company include consulting services, systems integration and solutions, integration of ERP solutions, implementation of application solutions, as well as subcontracting solutions for providing technical support to users and application maintenance and outsourcing services and operation of professional processes.

2871183a-78d5-4e86-9ef7-3ddb308a13d8.png

The bot executes an embedded VBA script to add borders in specified cells in Excel. If the cell addresses are dynamic/unknown, then leave starting and ending cell entry blank and the activity will add borders to all updated cells in conjuction with cell A1.

Please ensure to check "Trust access to the VBA project obejct model" in Excel trust center options before using this activity.

  

**Functionality:**

  

The sequence iterates through every row of the Datatable and checks if the value of the specified column has been repeated.

  

A column "Duplicate Status" is added in the Datatable in which the status "Duplicate" is updated for the rows having repeated value. No status is updated for the first row as it would be the original (unique) row.

  

For example: 

  

Order No.    Supplier    Quantity

123A             X Corp       10

456B             Y Corp        20

789C             Z Corp        30

456B             W Corp       25

  

If the above Datatable is passed in the snippet and column name is updated as "Order No.". then, the below Datatable will be the output:

  

Order No.    Supplier    Quantity    Duplicate Status

123A             X Corp       10               

456B             Y Corp        20

789C             Z Corp        30

456B             W Corp       25              Duplicate

  

  

**Input:** 

  

1\. Datatable in which duplicates are to categorized (in\_Datatable)

2\. Column name which has to be validated (in\_MatchColumnName)

  

**Output:**

  

Datatable with additional column "Duplicate Status" (out\_Datatable)

Easily find duplicates in a Datatable based on a similar value of one or more columns

Features:

\-&gt; Detect text language.

\-&gt; Translate text to different languages.

\-&gt; Over 104 languages are included. Go through the attached PDF for supported languages.

  

Please note that this activity requires an active Internet connection to work.

Features:

*   Dual functionality: Score & Sentiment.
*   Can analyze multiple paragraphs (no restriction of single line input).
*   Can handle:

     - Punctuation Emphasis

     - Degree Modifiers (booster words like very, extremely, slightly etc.)

     - Capitalization Emphasis

     - Polarity shift due to Conjunctions

     - Double Negation

     - Emoticons (:D, :) etc.)

     - Slangs (LOL, ROFL etc.)

  

Please go through the provided document for example of each.

Usage:  
1\. Add Build DataTable activity to create an empty data table. Provide the name of headers and image column i.e. the column where the screenshots are required to be updated.  
2\. Add Take Screenshot activity (offered by UiPath) to save the required image.  
3\. Drag and drop Add DataRow activities at the end of each test case and pass the required data along with the path of image (from Take Screenshot activity).  
4\. At the end, add Export DataTable activity to create an excel report.  
  
Points to consider:  
1\. Do not use DataTable activities offered by UiPath to manipulate the data table created by this package as it might cause the bot to fail.  
2\. Accepted image formats are .jpg, .jpeg and .png.  
3\. If no image has to be added in a data row, then pass empty string (“”) to image column. For eg: If second column is the image column, then the array to be updated should be – {“Open Google.com”,””,”Pass – Google.com opened.”}

Create test report on real time basis (while bot execution) along with screenshots. No need to take screenshots and create a report manually.

About me