Office Integration

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 documents in Microsoft binary format with the extension xls.

  If you have Microsoft Office 2007 installed, XML-based file name extensions xls and xlsm are supported.

• Microsoft Project documents with the extension mpp.

  Note

  When importing or exporting MS Project documents (IF_IOS_PROJECT~EXPORT_XML and IF_IOS_PROJECT~IMPORT_XML), for security reasons a whitelist is evaluated. To do this, in interface IF_IOS_PROJECT~SET_WHITELIST the names on the whitelist are referenced. The same whitelist is used as for AcfUpDownload. Note that for reasons of security, abbreviations such as $HOME are not supported during the Microsoft Project Integration.

• Microsoft Word documents in Microsoft binary format with the extension doc.

  If you have Microsoft Office 2007 installed, XML-based file name extensions docx and docm are supported.

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

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 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).

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

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

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

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