The Spreadsheet Interface
Definition
You define this instance with reference to the interface i_oi_spreadsheet.
Use
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.
Structure
To exchange data with the spreadsheet, you need tables with special structures. These structure definitions are contained in the
Important Table Structures section.Integration
The interface currently supports Microsoft Excel and Lotus 1-2-3.