Show TOC

Office Integration Locate this document in the navigation structure

 

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:

  • Installation of Microsoft Office

  • Microsoft Office file, which can be found in the ABAP back end as XSTRING, for example, as the object in the MIME repository

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

    You can find the latest ACF version on SAP Service Marketplace in the following directory:   www.service.sap.com/patches   Applications by Index   A   ACF  . 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.

    As an alternative to the recommended procedure using SAP Service Marketplace, in exceptional cases you can install ACF using an automatic download function. However, additional browser prerequisites must be met for this. These are described in SAP Notes 1016683 and 1150277.

  • ActiveX should be activated in your browser.

    To activate ActiveX, for example, for Microsoft Internet Explorer 8, proceed as follows: Under   Tools   Internet Options   go to tab Security, choose Custom level.... Under ActiveX controls and plug-ins, select options Download signed ActiveX controls (select Prompt) and Run ActiveX controls and plug-ins (select Enable) and Script ActiveX controls marked save for scripting (select Enable).

Note Note

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

End of the note.

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.

Basic Information

Note Number

Description

892638

Integrated Office Suites (IOS): Maintenance

766191

Active Component Framework Installation

846952

Remove ACF from client PC

1150277

Prerequisites for using ACF

1446519

Safari Restrictions for Unified Rendering and ACF

1073704

IOS: Office 2007 XML

1016683

Microsoft Vista and OfficeControl

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

Additional Information

Note Number

Description

1481194

Ascertaining the ACF version

949770

Trace for IOS, generating ACF controls

FAQ

You can find the answers to frequently asked questions in the SAP Notes.

Note Number

Description

1481875

IOS WD ABAP: Document is not accepted

1488874

ACF: Automatic download or installation