SAP ABAP Class CL_MASS_SPSH_FILE_IMP_EXCEL (Spreadsheet import from excel files)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-MS (Application Component) Cross-Application Mass Maintenance
     ⤷ MASS (Package) Mass Maintenance Tool: Generic Part

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_MASS_SPREADSHEET_FILE_IMP	Import spreadsheet data from file (excel, text)	20120911
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_MASS_SPREADSHEET_FILE_IMP	Interface for importing a spreadsheet from a file	20120911

Properties

Class	CL_MASS_SPSH_FILE_IMP_EXCEL
Short Description	Spreadsheet import from excel files
Super Class	CL_MASS_SPREADSHEET_FILE_IMP	Import spreadsheet data from file (excel, text)
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class	MASS_SPSH
Program status
Category	0
Package	MASS	Mass Maintenance Tool: Generic Part
Created	20120831	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_MASS_SPSH_FILE_IMP_EXCEL has no forward declaration.

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_MASS_SPREADSHEET_FILE_IMP	☐	☐	Interface for importing a spreadsheet from a file	20120911

Friends

Class CL_MASS_SPSH_FILE_IMP_EXCEL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MC_EXCEL_2003	Constant	Private	☐	Type reference (TYPE)	I	1	Excel version '2003'.	20121107
2	MC_EXCEL_2007	Constant	Private	☐	Type reference (TYPE)	I	2	Excel version '2007'	20121107
3	MC_MAX_NUM_COLS_2003	Constant	Private	☐	Type reference (TYPE)	I	256	Maximum number of columns supported by excel 2003	20121107
4	MC_MAX_NUM_COLS_2007	Constant	Private	☐	Type reference (TYPE)	I	16384	Maximum number of columns that are supported by excel 2007	20121107
5	MC_MAX_NUM_ROWS_2003	Constant	Private	☐	Type reference (TYPE)	I	65536	Maximum number of rows that are supported by excel 2003	20121107
6	MC_MAX_NUM_ROWS_2007	Constant	Private	☐	Type reference (TYPE)	I	1048576	Maximum number of rows that are supported by excel 2007	20121107
7	SV_EXCEL_SUPPORTED	Static Attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL			20121029

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_SELECTION_AND_RANGE	Instance method	Private	Method		20121008
2	CLASS_CONSTRUCTOR	Static method	Public	Constructor	CLASS_CONSTRUCTOR	20121029
3	DETERMINE_MAX_COL_AND_HEADER	Instance method	Private	Method		20121005
4	GET_CELLS	Instance method	Private	Method		20121005
5	GET_EXCEL_VERSION	Instance method	Private	Method	Get excel version	20121107
6	GET_MAX_NUM_COLS_ROWS	Instance method	Private	Method	Get maximum number of columns and rows	20121107
7	IMPORT_ALL_CELLS	Instance method	Private	Method		20121005
8	IMPORT_CELLS	Instance method	Private	Method		20121005
9	MOVE_CELLS_TO_SPREADSHEET	Instance method	Private	Method		20121010
10	PROGRESS	Instance method	Private	Method		20121008

Events

Class CL_MASS_SPSH_FILE_IMP_EXCEL has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	RANGE_NAME	Private	Type reference (TYPE)	SOI_RANGE_ITEM-NAME		20121008
2	TR_RANGE_NAMES	Private	See coding			20121008	tr_range_names type range of range_name

Method Signatures

Method ADD_SELECTION_AND_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CTR_RANGE_NAMES	Call by reference	☐	Type reference (TYPE)	CL_MASS_SPSH_FILE_IMP_EXCEL=>TR_RANGE_NAMES			20121008
2	Importing	IO_SPREADSHEET	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET			20121008
3	Importing	IV_COLUMNS	Call by reference	☐	Type reference (TYPE)	I			20121008
4	Importing	IV_LEFT	Call by reference	☐	Type reference (TYPE)	I			20121008
5	Importing	IV_RANGE	Call by reference	☐	Type reference (TYPE)	C			20121008
6	Importing	IV_ROWS	Call by reference	☐	Type reference (TYPE)	I			20121008
7	Importing	IV_TOP	Call by reference	☐	Type reference (TYPE)	I			20121008

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20121008

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_MASS_SPSH_FILE_IMP_EXCEL has no parameter.
Method CLASS_CONSTRUCTOR on class CL_MASS_SPSH_FILE_IMP_EXCEL has no exception.

Method DETERMINE_MAX_COL_AND_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_SPREADSHEET	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET			20121005
2	Exporting	ET_HEADER_SPREADSHEET	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET			20121005
3	Exporting	EV_END_OF_FILE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20121010
4	Exporting	EV_NUM_COLS	Call by reference	☐	Type reference (TYPE)	I			20121005
5	Exporting	EV_ROWS_READ	Call by reference	☐	Type reference (TYPE)	I			20121005
6	Importing	IO_SPREADSHEET	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET			20121005
7	Importing	IO_TARGET_TAB_INFO	Call by reference	☐	Object reference (TYPE REF TO)	CL_MASS_SPSH_TARGET_TAB_INFO			20121005
8	Importing	IV_HAS_HEADERLINE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20121005
9	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20121005

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20121005

Method GET_CELLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CELLS	Call by reference	☐	Type reference (TYPE)	SOI_GENERIC_TABLE			20121005
2	Importing	IO_SPREADSHEET	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET			20121005
3	Importing	IV_COLUMNS	Call by reference	☐	Type reference (TYPE)	I			20121005
4	Importing	IV_LEFT	Call by reference	☐	Type reference (TYPE)	I			20121005
5	Importing	IV_RANGE	Call by reference	☐	Type reference (TYPE)	C			20121005
6	Importing	IV_ROWS	Call by reference	☐	Type reference (TYPE)	I			20121005
7	Importing	IV_TOP	Call by reference	☐	Type reference (TYPE)	I			20121005

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20121005

Method GET_EXCEL_VERSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_VERSION	Value transfer	☐	Type reference (TYPE)	I		Excel version	20121107

Method GET_EXCEL_VERSION on class CL_MASS_SPSH_FILE_IMP_EXCEL has no exception.

Method GET_MAX_NUM_COLS_ROWS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_MAX_NUM_COLS	Call by reference	☐	Type reference (TYPE)	I			20121107
2	Exporting	EV_MAX_NUM_ROWS	Call by reference	☐	Type reference (TYPE)	I			20121107

Method GET_MAX_NUM_COLS_ROWS on class CL_MASS_SPSH_FILE_IMP_EXCEL has no exception.

Method IMPORT_ALL_CELLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_HEADER	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPSH_HEADER_BY_SHEETNAME			20121010
2	Changing	CT_SPREADSHEET	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET			20121005
3	Exporting	EV_NUM_COLS	Call by reference	☐	Type reference (TYPE)	I			20121010
4	Exporting	EV_NUM_ROWS	Call by reference	☐	Type reference (TYPE)	I			20121010
5	Importing	IO_SPREADSHEET	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET			20121005
6	Importing	IO_TARGET_TAB_INFO	Call by reference	☐	Object reference (TYPE REF TO)	CL_MASS_SPSH_TARGET_TAB_INFO			20121010
7	Importing	IV_HAS_HEADERLINE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20121010
8	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20121010

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20121005

Method IMPORT_CELLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_SPREADSHEET	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET			20121005
2	Exporting	EV_NUM_ROWS	Call by reference	☐	Type reference (TYPE)	I			20121005
3	Importing	IO_SPREADSHEET	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET			20121005
4	Importing	IV_FROM_ROW	Call by reference	☐	Type reference (TYPE)	I			20121010
5	Importing	IV_HEADERLINE	Call by reference	☐	Type reference (TYPE)	I			20121010
6	Importing	IV_NUM_COLS	Call by reference	☐	Type reference (TYPE)	I			20121010
7	Importing	IV_ROW_PACK_SIZE	Call by reference	☐	Type reference (TYPE)	I			20121010
8	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>SPREADSHEET_NAME			20121010

#	Exception	Resumable	Description	Created on
1	CX_MASS_SPSH_INTERNAL_ERROR	☐		20121005

Method MOVE_CELLS_TO_SPREADSHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_SPREADSHEET	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET			20121010
2	Exporting	ET_HEADER_SPREADSHEET	Call by reference	☐	Type reference (TYPE)	IF_MASS_SPREADSHEET_TYPES=>T_SPREADSHEET			20121010
3	Exporting	EV_COLS_READ	Call by reference	☐	Type reference (TYPE)	I			20121010
4	Exporting	EV_END_OF_FILE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20121010
5	Exporting	EV_ROWS_READ	Call by reference	☐	Type reference (TYPE)	I			20121010
6	Importing	IT_CELLS	Call by reference	☐	Type reference (TYPE)	SOI_GENERIC_TABLE			20121010
7	Importing	IV_COL_OFFSET	Call by reference	☐	Type reference (TYPE)	I			20121010
8	Importing	IV_HAS_HEADERLINE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20121010
9	Importing	IV_ROW_OFFSET	Call by reference	☐	Type reference (TYPE)	I			20121010

Method MOVE_CELLS_TO_SPREADSHEET on class CL_MASS_SPSH_FILE_IMP_EXCEL has no exception.

Method PROGRESS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CURRENT	Call by reference	☐	Type reference (TYPE)	I			20121008
2	Importing	IV_TEXT	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20121008
3	Importing	IV_TOTAL	Call by reference	☐	Type reference (TYPE)	I			20121008

Method PROGRESS on class CL_MASS_SPSH_FILE_IMP_EXCEL has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	740