Using the Spreadsheet Interface

Use

You define it with reference to the interface i_oi_spreadsheet.

You use this interface to communicate with a spreadsheet. All spreadsheets allow you to define and assign names to ranges. This interface works with named ranges within a spreadsheet.

The individual ABAP methods contain only functions that are available in the spreadsheet packages supported by the interface. That is, each method corresponds directly to a function within the spreadsheet.

The spreadsheet interface allows you to load data from the SAP system into a spreadsheet and return it from the application to the SAP system as long as the Desktop Office application supports the interface.

To exchange data with the spreadsheet, you need tables with special structures. These structure definitions are contained in the Important Table Structures section.

The interface supports the table calculation in MS Excel.

Prerequisites

You must create the instance for a document management before you can use the interface.

Process

1. Declare an instance with reference to interface i_oi_spreadsheet:

   DATA spreadsheet TYPE REF TO i_oi_spreadsheet.

2. Use method get_spreadsheet_interface on the document instance for document management to create the instance for the spreadsheet interface.

3. Use the spreadsheet interface methods.