Using the Microsoft Office extensions

SAP Intelligent RPA provides three extension libraries to interact with Microsoft Office products – a Microsoft Outlook extension, a Microsoft Excel extension, and a Microsoft Word extension. These three extensions are very useful for automating a business process that requires structural information as input. They process this input data by reading the structural information and then generating a result report.

Consider the vendor invoice posting business process that we implemented in Chapter 15, Controlling Workflows and Scenarios, as the SAPInvoicePosting workflow to post the purchase invoices. We need to post multiple purchase invoices, but how does the automation solution receive the information that's required to post a purchase invoice? One option is to gather information manually for each invoice by providing a custom dialog, as discussed in Chapter 16, Designing Custom Pages with UI Designer. So, asking the user to enter...