SAP ABAP Class IF_MASS_SPREADSHEET (Interface for spreadsheets)

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	CL_MASS_SPREADSHEET	Handle spreadsheet data	20120910

Properties

Class	IF_MASS_SPREADSHEET
Short Description	Interface for spreadsheets
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package
Created	20120831	SAP
Last change	20131127	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☐
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	IF_MASS_SPREADSHEET_TYPES	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

Class IF_MASS_SPREADSHEET has no interface implemented.

Friends

Class IF_MASS_SPREADSHEET has no friend class.

Attributes

Class IF_MASS_SPREADSHEET has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONVERT_VALUE	Instance method	Public	Method		20120920
2	GET_CELL_VALUE	Instance method	Public	Method		20120910
3	GET_DATA	Instance method	Public	Method		20120910
4	GET_DATA_STR_TABLES	Instance method	Public	Method		20120912
5	GET_FILE	Instance method	Public	Method		20120910
6	GET_HEADER_LINES	Instance method	Public	Method		20120910
7	GET_IMP_CONF	Instance method	Public	Method		20120912
8	GET_NUM_COLS	Instance method	Public	Method		20120910
9	GET_NUM_ROWS	Instance method	Public	Method		20120910
10	GET_SELECTED_ROWS	Instance method	Public	Method		20120920
11	GET_SHEETNAMES	Instance method	Public	Method		20120910
12	GET_SPSH_ROW_INDEX	Instance method	Public	Method		20130211
13	HAS_HEADER_LINES	Instance method	Public	Method		20120910
14	SELECT_ALL	Instance method	Public	Method		20120920
15	SET_DATA	Instance method	Public	Method		20120910
16	SET_HEADER_LINES	Instance method	Public	Method		20120910
17	SET_IMP_CONF	Instance method	Public	Method		20120910
18	SET_SELECTED_ROWS	Instance method	Public	Method		20120920

Events

Class IF_MASS_SPREADSHEET has no event.

Types

Class IF_MASS_SPREADSHEET has no local type.

Method Signatures

Method CONVERT_VALUE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CV_VALUE	Call by reference	☐	Type reference (TYPE)	ANY			20120920
2	Importing	IS_DFIES	Call by reference	☑	Type reference (TYPE)	DFIES			20121005
3	Importing	IV_VALUE	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_VALUE			20120920

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20120921
2	CX_MASS_SPSH_TYPECONV_ERROR	☐		20120920

Method GET_CELL_VALUE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLUMN	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_COLUMN			20120910
2	Importing	IV_ROW	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_ROW			20120910
3	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20120910
4	Returning	RV_VALUE	Value transfer	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_VALUE			20120910

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20120920

Method GET_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_DATA	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET_BY_SHEETNAME			20120910

Method GET_DATA on class IF_MASS_SPREADSHEET has no exception.

Method GET_DATA_STR_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_INCLUDING_HEADERLINE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20120913
2	Returning	RT_SPSH_STR_TABLES	Value transfer	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPSH_STR_TABLE_BY_SHEETNAME			20120912

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPREADSHEET	☐		20120913

Method GET_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_FILE	Value transfer	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>FILE_NAME			20120910

Method GET_FILE on class IF_MASS_SPREADSHEET has no exception.

Method GET_HEADER_LINES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_HEADER_LINES	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPSH_HEADER_BY_SHEETNAME			20120910

Method GET_HEADER_LINES on class IF_MASS_SPREADSHEET has no exception.

Method GET_IMP_CONF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RO_IMP_CONF	Value transfer	☐	Object reference (TYPE REF TO)	CL_MASS_SPREADSHEET_IMP_CONF			20120912

Method GET_IMP_CONF on class IF_MASS_SPREADSHEET has no exception.

Method GET_NUM_COLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SHEETNAME	Call by reference	☑	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20120910
2	Returning	RV_NUM_COLS	Value transfer	☐	Type reference (TYPE)	I			20120910

Method GET_NUM_COLS on class IF_MASS_SPREADSHEET has no exception.

Method GET_NUM_ROWS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SHEETNAME	Call by reference	☑	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20120910
2	Returning	RV_NUM_ROWS	Value transfer	☐	Type reference (TYPE)	I			20120910

Method GET_NUM_ROWS on class IF_MASS_SPREADSHEET has no exception.

Method GET_SELECTED_ROWS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20120920
2	Returning	RT_SEL_ROWS	Value transfer	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET_ROWS			20120920

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20120920

Method GET_SHEETNAMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_SHEETNAMES	Value transfer	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SHEETNAMES			20120910

Method GET_SHEETNAMES on class IF_MASS_SPREADSHEET has no exception.

Method GET_SPSH_ROW_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_EXT_INDEX	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_ROW			20130211
2	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20130211
3	Returning	RV_SPSH_INDEX	Value transfer	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_ROW			20130211

Method GET_SPSH_ROW_INDEX on class IF_MASS_SPREADSHEET has no exception.

Method HAS_HEADER_LINES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_BOOL	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20120910

Method HAS_HEADER_LINES on class IF_MASS_SPREADSHEET has no exception.

Method SELECT_ALL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SHEETNAME	Call by reference	☑	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20120920

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20120920

Method SET_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DATA	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET_BY_SHEETNAME			20120910

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20120920

Method SET_HEADER_LINES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_HEADER_LINES	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPSH_HEADER_BY_SHEETNAME			20120910

Method SET_HEADER_LINES on class IF_MASS_SPREADSHEET has no exception.

Method SET_IMP_CONF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_IMP_CONF	Call by reference	☐	Object reference (TYPE REF TO)	CL_MASS_SPREADSHEET_IMP_CONF			20120910

Method SET_IMP_CONF on class IF_MASS_SPREADSHEET has no exception.

Method SET_SELECTED_ROWS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SEL_ROWS	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET_ROWS			20120920
2	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20120920

Method SET_SELECTED_ROWS on class IF_MASS_SPREADSHEET has no exception.

History

Last changed by/on	SAP	20131127
SAP Release Created in