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

Manager

Consultant

One of the key challenges faced by Microsoft Excel users is finding and replacing multiple instances of a text or value.The Excel - VlookUp activity only retrieves the address of the first cell containing the searched value so it's not useful if you need to find all the cells containing the matching value. Also, there is no activity that can replace text in Excel.Inputs:&nbsp;1.&nbsp;In_FilePath: Path of the Excel file on which addresses of all the cells contain the value being searched for.2.&nbsp;In_SheetName: Worksheet (Sheet) name on which action is to be performed.3.&nbsp;In_Replace_Text: Boolean value (True/False) whether to replace the text or not.4.&nbsp;In_Text_To_SearchFor: Text to search for in Excel5.&nbsp;In_Text_To_ReplaceWith&nbsp;&nbsp;: Replace the searched value with the desired text if "In_Replace_Text" is set to True.&nbsp;&nbsp;Output:1.	Out_List_CellAddress : Consists the List of String containing the matched cell addresses.

The snippet used to find and, optionally replace all the occurrence of a text within an Excel file

Microsoft Outlook is widely used in many processes automated via UiPath tool. One of the key challenges which the developers are facing with Outlook activity is related to filtering the emails

This Snippet helps with disabling the option in Internet Explorer to show pop up windows

Identify and delete all the duplicate entries from a DataTable


RPA Developer

Format font style in Excel cells as Bold, Italic or Underline

This activity allows you to automate Excel files and delete the desired Excel worksheet from it

Many projects require to create the current date folder using Year and Month. This snippet will create the folders and overwrite as per user's input

Filter the mails in Exchange on the basis of specific criteria like Subject, Body, Date,etc.The output can be used with other exchange activities. 

About Us

Find and Replace in Excel…

Sopra Steria - Retrieve Outlook Mail Messages…

Sopra Steria - Disable Password Save Notification…

Sopra Steria - Remove All Occurrences…

Sopra Steria - Add Cell Borders in Excel…

Sopra Steria - Format Font Style in Excel…

Sopra Steria - Delete Excel Worksheet…

Sopra Steria - Create Current Day Folder…

Sopra Steria - Filter Exchange Mails…

Help

How To