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 !
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.
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.
Open the Web application and retrieve the data (which you need to add in Powerpoint)from
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.
Saves the PPT
Activity: Close PowerPoint Instance
Closes the PowerPoint Instance
Test the BOT
The Powerpoint is updated with data from SAP Analytics Dashboard.
I will introduce different activities like Add Slide, Set Text Size, Save As which were not used in Update PPT automation.
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.
Test the BOT:
A new Powerpoint is created and filled with data from SAP Analytics Dashboard.
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 !!