EDP is the biggest Portuguese industrial group, one of the major energy operators in Iberia and the third world class wind energy producer, with close to 70% of the energy produced comes from renewable sources. It´s a vertically integrated utility, leader in the energy sector and 14 business units spread in 14 countries and 4 continents, with more than 9,8 million electricity customers and 1,5 million gas customers.

0f6d0f25-a0e3-48bc-972d-ba30bcb30a24.jpg

Senior RPA Developer

The activities included in this package are as follows, starting with **Excel Scope,** inside which the below activities can be executed:

*   **Copy As Picture** - Copy the selected cell range as an image. It performs the Copy As Picture functionality which is in the Excel workbook.
*   **SaveAs Workbook** - Save the Excel file in a different format.
*   **Read Cell Formula** - Read the cell's formula value.

This package consists of multiple custom activities that simplify processes in Excel.

This package contains custom activities that simplify the usage of functionalities thus making the MS Project processing easier.

  

The activity will open a MS Project and keep the instance with it. It will be used by the child activities. When the execution of this activity ends, the specified MS Project is closed.

  

It will close the MS Project after the execution of all child activities. This activity can only be used if the Microsoft Project application is installed on the machine.

  

**Properties:**

*   **File Path** – MS Project file application path.
*   **Open Password** – File password to the MS Project file.
*   **Reservation Password** – Reservation Password to the MS Project file.

Details about the installation and usage can be found in the Installation Guide from the Resources section.

This package helps simplify the use of MS Project.

The following activities are included:

1\. **PowerPoint Scope** - opens a PowerPoint and keeps the instance with it.

It will be used by child activities. When the execution of this activity ends, the specified PowerPoint is closed. This will happen after the execution of all child activities This activity can only be used if the Microsoft PowerPoint application is installed on the machine.

2\. **Insert Picture** – insert a picture in a specific slide and specific position with height and width.

It can only be used together with the PowerPoint Scope activity.

3\. **Find & Replace** - activates the Find and Replace functionality in a specified slide.

It can only be used together with the PowerPoint Scope activity.

4\. **Find & Replace Dictionary** - activates the Find and Replace text from the dictionary functionality in a specified slide. This single functionality can replace more words at a time. 

5. **Refresh Data** - refresh the chart data.

It can only be used together with the PowerPoint Scope activity.

6\. **Save As** - activates the Save as functionality. 

7\. **Slide Count** \- counts the slides available in the PowerPoint file.

8\. **Insert Text Box** – inserts a text box in a specified position within the slide.

9\. **Slide Copy** - copies the slide to the clipboard. 

10\. **Slide Paste** - pasts the slide to the clipboard. 

11\. **Delete Images** - deletes all the images from a specified slide.

The package has many activities to help making the PowerPoint automation activities easier

48e97af0-ecf6-4955-ad4e-910d35d56125.png

This package contains the following activities:

*   Create Pivot table - Main activity to create pivot table.
*   Create Pivot Row Item - Instantiates an object to define a pivot row item on the Excel pivot table.
*   Create Pivot Data Item - Instantiates an object to define a pivot column item and its sumarization function for the pivot.
*   Create Pivot Filter Item - Instantiates an object to define a pivot filter item with the values filter out/in of the pivot table.

Custom activities for creating filterable pivot tables in Excel sheets.