SAP I_OI_SPREADSHEET OO Class - Spreadsheet Interface
I_OI_SPREADSHEET is a standard SAP object class available within R/3 SAP systems depending on your version and release level. You can view/maintain the class details by entering its name into the relevant SAP transactions such as SE24, SE80 or even SE84. Below is the documentation available for class I_OI_SPREADSHEET including details of:
- Interface class implementations
- Inheritance details
- Methods defined within class ( including link to full details )
- Attributes ( including initial values )
- Class Events
Method list of I_OI_SPREADSHEET SAP class
A method is a coding block that performs a certain procedure (i.e. ABAP functionality) on an object within the overall SAP class. In simple terms if the object is an SAP database table a method could be the procedure to add a record or to delete a record. If you are new to OO in many respects, the implementation of a method is similar to a function module and can be called in a very similar way using CALL METHOD.
Instead of "CALL FUNCTION", Methods are referenced using the following syntax: CALL METHOD =>methodname EXPORTING/IMPORTING...
| Method Name | Description | Visability |
| ADD_SHEET | Inserts a Worksheet | Public |
| CALL METHOD i_oi_spreadsheet=>ADD_SHEET...more details | ||
| ADD_STYLE | Add Styles | Public |
| CALL METHOD i_oi_spreadsheet=>ADD_STYLE...more details | ||
| CELL_FORMAT | Sets Individual Cell Attributes | Public |
| CALL METHOD i_oi_spreadsheet=>CELL_FORMAT...more details | ||
| CHANGE_RANGE | Change Size or Name of an Area | Public |
| CALL METHOD i_oi_spreadsheet=>CHANGE_RANGE...more details | ||
| CHANGE_STYLE | Change Styles | Public |
| CALL METHOD i_oi_spreadsheet=>CHANGE_STYLE...more details | ||
| CLEAR_ALL_RANGES | Deletes the Contents and Formatting of the Ranges | Public |
| CALL METHOD i_oi_spreadsheet=>CLEAR_ALL_RANGES...more details | ||
|
| ||
| CLEAR_CONTENT_RANGE | Delete Content of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>CLEAR_CONTENT_RANGE...more details | ||
| CLEAR_HIERARCHY | Delete Hierarchy | Public |
| CALL METHOD i_oi_spreadsheet=>CLEAR_HIERARCHY...more details | ||
| CLEAR_RANGE | Delete Content and Formatting of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>CLEAR_RANGE...more details | ||
| DELETE_CONTENT_RANGES | Deletes Ranges | Public |
| CALL METHOD i_oi_spreadsheet=>DELETE_CONTENT_RANGES...more details | ||
| DELETE_RANGES | Deletes Entire Ranges | Public |
| CALL METHOD i_oi_spreadsheet=>DELETE_RANGES...more details | ||
| DELETE_SHEET | Deletes a Worksheet | Public |
| CALL METHOD i_oi_spreadsheet=>DELETE_SHEET...more details | ||
| FIT_WIDEST | Adapt to Widest Column | Public |
| CALL METHOD i_oi_spreadsheet=>FIT_WIDEST...more details | ||
| GET_ACTIVE_SHEET | Get Active Worsheet | Public |
| CALL METHOD i_oi_spreadsheet=>GET_ACTIVE_SHEET...more details | ||
| GET_CELL_FORMAT | Get Format of a Line | Public |
| CALL METHOD i_oi_spreadsheet=>GET_CELL_FORMAT...more details | ||
| GET_CELL_FORMATS_TABLE | Gets Information about Cells | Public |
| CALL METHOD i_oi_spreadsheet=>GET_CELL_FORMATS_TABLE...more details | ||
| GET_DIMENSION | Get Dimensions of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>GET_DIMENSION...more details | ||
| GET_DIMENSION_TABLE | Returns a Table Containing Ranges | Public |
| CALL METHOD i_oi_spreadsheet=>GET_DIMENSION_TABLE...more details | ||
| GET_PROTECTION | Get Protected Attribute of a Worksheet | Public |
| CALL METHOD i_oi_spreadsheet=>GET_PROTECTION...more details | ||
| GET_RANGES_DATA | Get Name and Data for Range | Public |
| CALL METHOD i_oi_spreadsheet=>GET_RANGES_DATA...more details | ||
| GET_RANGES_NAMES | Get Name of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>GET_RANGES_NAMES...more details | ||
| GET_SELECTED_AREAS | Returns a Collection of Selected Ranges | Public |
| CALL METHOD i_oi_spreadsheet=>GET_SELECTED_AREAS...more details | ||
| GET_SELECTION | Get a Selection | Public |
| CALL METHOD i_oi_spreadsheet=>GET_SELECTION...more details | ||
| GET_SHEETS | Get the Names of Worksheets | Public |
| CALL METHOD i_oi_spreadsheet=>GET_SHEETS...more details | ||
| GET_STYLE | Read Style of an Area | Public |
| CALL METHOD i_oi_spreadsheet=>GET_STYLE...more details | ||
| GET_STYLE_FORMATS | Read All Style Names | Public |
| CALL METHOD i_oi_spreadsheet=>GET_STYLE_FORMATS...more details | ||
| HIDE_COLUMNS | Hide Columns | Public |
| CALL METHOD i_oi_spreadsheet=>HIDE_COLUMNS...more details | ||
| HIDE_ROWS | Hide Rows | Public |
| CALL METHOD i_oi_spreadsheet=>HIDE_ROWS...more details | ||
| INSERT_FULL | Inserst Values | Public |
| CALL METHOD i_oi_spreadsheet=>INSERT_FULL...more details | ||
| INSERT_ONE_TABLE | Insert a Table | Public |
| CALL METHOD i_oi_spreadsheet=>INSERT_ONE_TABLE...more details | ||
| INSERT_RANGE | Insert a New Range | Public |
| CALL METHOD i_oi_spreadsheet=>INSERT_RANGE...more details | ||
| INSERT_RANGES | Inserts Several Ranges | Public |
| CALL METHOD i_oi_spreadsheet=>INSERT_RANGES...more details | ||
| INSERT_RANGE_DIM | Get a Range Based on its Dimensions | Public |
| CALL METHOD i_oi_spreadsheet=>INSERT_RANGE_DIM...more details | ||
| LOAD_LIB | Load DLL | Public |
| CALL METHOD i_oi_spreadsheet=>LOAD_LIB...more details | ||
| Print a Worksheet | Public | |
| CALL METHOD i_oi_spreadsheet=>PRINT...more details | ||
| PROTECT | Protect the Active Sheet | Public |
| CALL METHOD i_oi_spreadsheet=>PROTECT...more details | ||
| PROTECT_RANGE | Sets the Protected Attribute for a Range | Public |
| CALL METHOD i_oi_spreadsheet=>PROTECT_RANGE...more details | ||
| SCREEN_UPDATE | Controls the Screen Update | Public |
| CALL METHOD i_oi_spreadsheet=>SCREEN_UPDATE...more details | ||
| SELECT_RANGE | Select a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SELECT_RANGE...more details | ||
| SELECT_SHEET | Activate a Sheet | Public |
| CALL METHOD i_oi_spreadsheet=>SELECT_SHEET...more details | ||
| SETLOCALE | Sets the Date and Decimal Format | Public |
| CALL METHOD i_oi_spreadsheet=>SETLOCALE...more details | ||
| SET_COLOR | Set the Color of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SET_COLOR...more details | ||
| SET_DATA_TABLE | Sets the Data Table | Public |
| CALL METHOD i_oi_spreadsheet=>SET_DATA_TABLE...more details | ||
| SET_FIXED_COLS | Sets the Number of Fixed Columns | Public |
| CALL METHOD i_oi_spreadsheet=>SET_FIXED_COLS...more details | ||
| SET_FIXED_ROWS | Sets the Number of Fixed Rows | Public |
| CALL METHOD i_oi_spreadsheet=>SET_FIXED_ROWS...more details | ||
| SET_FONT | Set the Font for a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SET_FONT...more details | ||
| SET_FORMAT | Set the Format of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SET_FORMAT...more details | ||
| SET_FORMAT_STRING | Set the Format of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SET_FORMAT_STRING...more details | ||
| SET_FRAME | Set a Frame for a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SET_FRAME...more details | ||
| SET_HEADER | Sets a Header | Public |
| CALL METHOD i_oi_spreadsheet=>SET_HEADER...more details | ||
| SET_HIERARCHY | Sets Hierarchy | Public |
| CALL METHOD i_oi_spreadsheet=>SET_HIERARCHY...more details | ||
| SET_HIERARCHY_TABLE | Sets the Hierarchies Using a Table | Public |
| CALL METHOD i_oi_spreadsheet=>SET_HIERARCHY_TABLE...more details | ||
| SET_INFO_TABLE | Sets the Info Table | Public |
| CALL METHOD i_oi_spreadsheet=>SET_INFO_TABLE...more details | ||
| SET_RANGES_DATA | Set the Data for a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SET_RANGES_DATA...more details | ||
| SET_RANGES_FORMAT | Set the Format of a Range | Public |
| CALL METHOD i_oi_spreadsheet=>SET_RANGES_FORMAT...more details | ||
| SET_SELECTION | Set a Selection | Public |
| CALL METHOD i_oi_spreadsheet=>SET_SELECTION...more details | ||
| SET_SHEET_NAME | Sets the Name of a Worksheet | Public |
| CALL METHOD i_oi_spreadsheet=>SET_SHEET_NAME...more details | ||
| SET_STYLE | Set Style | Public |
| CALL METHOD i_oi_spreadsheet=>SET_STYLE...more details | ||
| SET_ZOOM | Set the Zoom Factor | Public |
| CALL METHOD i_oi_spreadsheet=>SET_ZOOM...more details | ||
| SHOW_COLUMNS | Display Columns | Public |
| CALL METHOD i_oi_spreadsheet=>SHOW_COLUMNS...more details | ||
| SHOW_ROWS | Display Rows | Public |
| CALL METHOD i_oi_spreadsheet=>SHOW_ROWS...more details | ||
| UPDATE_FRONTEND | Change the Excel View Based on Data and Info Table | Public |
| CALL METHOD i_oi_spreadsheet=>UPDATE_FRONTEND...more details | ||
| VERSION | Returns the Version of the Spreadsheet Interface | Public |
| CALL METHOD i_oi_spreadsheet=>VERSION...more details | ||
I_OI_SPREADSHEET attributes
List of attributes within class CL_ABAP_CHAR_UTILITIES. These can be referenced using the following syntax CL_ABAP_CHAR_UTILITIES=>. Although depending on where you are inserting the ABAP code you do need to check if the attribute is public or private.
| Name | Level | Description | Initial Value | Type | Visability |
| SPREADSHEET_CLEAR | Constant | Delete | '2' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_COLUMNSHIDE | Constant | Hide Columns | '5' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_COLUMNSHOW | Constant | Display Columns | '8' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_INSERTALL | Constant | Insert all Data | '3' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_NEWRANGE | Constant | Insert a New Range | '4' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_PROTECT | Constant | Protect a Range | '1' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_ROWSHIDE | Constant | Hide Rows | '6' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_ROWSSHOW | Constant | Hide Lines | '9' | LIKE SOI_BOOLEAN | Public |
| SPREADSHEET_UNPROTECT | Constant | Remove Protection From a Range | '7' | LIKE SOI_BOOLEAN | Public |
Links to Related Class(s)
I_OI_SPR...Full list of available SAP object classes
Search for further information about these or an SAP related objects