Show TOC

Office IntegrationLocate this document in the navigation structure

Use

Applications created with Microsoft Office can be integrated into Web Dynpro ABAP using UI element OfficeControl. This enables standard Web Dynpro to be enhanced with new components. These new components are implemented with Microsoft Office and run on the local client PC or browser. An OfficeControl UI element can be embedded in Web Dynpro views, can access Web Dynpro context, and can trigger Web Dynpro actions.

The following Microsoft Office products are supported:

  • Microsoft Excel

  • Microsoft Project

  • Microsoft Word

Office integration in Web Dynpro ABAP is based on the Active Component Framework (ACF).

Activities

The basic procedure for integrating Office products is described in Using OfficeControl.

Prerequisites

To use OfficeControl to implement Microsoft Office applications for Web Dynpro ABAP, you require the following:

  • Microsoft Office and the associated Office file you want to integrate using OfficeControl must be installed.

  • The front-end ACF components must be installed. We recommend you install the components using SAP Service Marketplace.

    You can find the latest ACF version on SAP Service Marketplace in the following directory: Start of the navigation path www.service.sap.com/patches Next navigation step Applications by Index Next navigation step A Next navigation step ACF End of the navigation path. Open the ACF version displayed, and then choose the Win32 link. Here you can find the installation to download. After downloading it, open the file to run the installation. For more information about the ACF installation, see SAP Note 766191 Information published on SAP site.

  • ActiveX should be activated in your browser.

    To activate ActiveX, for example, for Microsoft Internet Explorer 8, proceed as follows: Under Start of the navigation path Tools Next navigation step Internet Options End of the navigation path go to tab Security, choose Custom level.... Under ActiveX controls and plugins choose options Download signed ActiveX controls (select Prompt) and Run ActiveX controls and plugins (select Enable) and Script ActiveX controls marked save for scripting (select Enable).

Note

If there are any problems displaying OfficeControl make sure that the Active Component Framework (ACF) is correctly installed. See also SAP Note 846952 Information published on SAP site.

Example Applications

You can find demo applications and components in the system in package SIOS. The basic functions of Office integration are described using the following examples:

  • IOS_TEST_HELLOWORLD_MS

  • IOS_TEST_WORDPROCESSING

  • IOS_TEST_EXCEL

More Information

For more information about ACF, see Active Component Framework (ACF).

You can find general information about Office integration in the Notes below.

Note Number

Description

892638 Information published on SAP site

Supporting Microsoft Office products in conjunction with Office integration in Web Dynpro ABAP

766191 Information published on SAP site

Active Component Framework Installation

846952 Information published on SAP site

Remove ACF from client PC

1150277 Information published on SAP site

Prerequisites for using ACF

1446519 Information published on SAP site

Safari Restrictions for Unified Rendering and ACF

1073704 Information published on SAP site

IOS: Office 2007 XML

1016683 Information published on SAP site

Microsoft Vista and OfficeControl

You can find more information about Office integration in the Notes below.

Note Number

Description

xxx

Find out the version of the Office product

949770 Information published on SAP site

Creating Traces for OfficeControl