Skip to Content
Technical Articles

SAP RPA 2.0:Automate Power point to create/update your PPT in status meetings

This blogpost is part of SAPRPA2.0_TutorialChallenge2021

I was excited to see the new feature of PowerPoint Automation in the 2104 release of

SAP Intelligent RPA 2.0 and started exploring it !

Introduction

Powerpoint automation is required in our daily scenarios.

Most of us update our slides in the status meeting by checking few reports and update the statistics in PPT. This is a repetitive task as we need to update our PPT for every status meeting.

This use case is required for the roles who have to continuously update their PPT’s with statistics/data by checking any application.

I have created a BOT to automate the task of updating the status of number of blogs/questions published in the SAP Community Dashboard in my PPT.

Key Concepts covered in the Blog Post

1.How to use PowerPoint Activities

2.Prepare the PPT for automation. (Create New PPT/Update Existing PPT)

3.Capture SAP Analytics Dashboard for SAP Intelligent RPA.

Pre-requisites

1.SAP Intelligent RPA Tenant with 2104 Release.

2.Desktop Agent installation.

3.Preparing PPT for Automation

Steps to Create the BOT.

1.Create a project in Cloud Studio.

2..Add dependencies to the Project

To access the PowerPoint Activities, make sure to add PowerPoint SDK as a dependency to the project.

3.Create an artifact Application.

4.Screen Capture and Element Declaration

Capture the SAP Community Analytics Cloud Application and declare the elements which have to be appended in the Powerpoint.

Declaring of elements.

Repeat the steps for declaring other elements.(no.of views and time taken)

5.Application Testing through Application Tester.

The best practice is to test the application declaration before we use the application in the Automation.

6. Create an artifact Automation to design the workflow.

7. Steps to retrieve data from the SAP Analytics Cloud Application

Open the Web application and retrieve the data (which you need to add in Powerpoint)from

the application

 

8.Create New PPT/Update Existing PPT

The retrieved data can be updated in the existing PPT or created in New PPT.

We need to understand the Shape index in Powerpoint which is required to mention in most of the activities of Powerpoint.

8.1Update Existing PPT

Let’s design the PPT and understand the Shapeindex and update the data accordingly.

To view the shape index, Click on any of the items. Shape Format Menu appears in the Menu bar.

Click on Select—>Selection pane or Arrange—Selection Pane.

 

 

Automation Steps to Append the data to PowerPoint

        Activity: Open PowerPoint Instance

Initializes/Opens the PowerPoint Instance

        Activity:Open Existing Presentation

Open the Powerpoint by providing the file path.

       Activity: Append Text/Set Text:

Appends/Sets Text to append data to PPT.

         

          Activity :Save

Saves the PPT

         Activity: Close PowerPoint Instance

Closes the PowerPoint Instance

     

 

Complete workflow 

 

Test the BOT

The Powerpoint is updated with data from SAP Analytics Dashboard.

8.2 Create a new PPT

I will introduce different activities like Add Slide, Set Text Size, Save As which were not used in Update PPT automation.

Activity AddSlide:

Adds a new slide with the predefined layout .I have used the layout ppLayoutText which creates a layout with Title(ShapeIndex1) and TextBox(ShapeIndex2)

Activity: Set Text Size

Sets the font of the text in the particular slide and particular shape index. I have reduced the font size for the text box, hence used shape index as 2.

Activity : Save As

Saves the PowerPoint in Required Format.I have used ppSaveAsPresentation in our automation.

Complete Workflow:

Test the BOT:

A new  Powerpoint is created and filled with data from SAP Analytics Dashboard.

 

Conclusion:

The data from the SAP Analytics dashboard is printed in New or existing Powerpoint.

This blog post will help you to kick start learning about Powerpoint SDK Activities.

Happy Learning and Exploring !!

 

11 Comments
You must be Logged on to comment or reply to a post.