SAP ABAP Class CL_RSDD_XLS_RANGE (Excel Range)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDD_EXCEL (Package) Access to Excel using GUI

Properties

Class	CL_RSDD_XLS_RANGE
Short Description	Excel Range
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDD_EXCEL	Access to Excel using GUI
Created	20080923	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	CL_RSDD_XLS_RANGE	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
2	OLE2	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSDD_XLS_RANGE has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDD_XLS_WORKSHEET	☐	20080923	Worksheet

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_XLSRCRANGE	Constant	Private	☐	Type reference (TYPE)	I	1		20081014
2	C_XLYES	Constant	Private	☐	Type reference (TYPE)	I	1		20081014
3	P_DATA_READ	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Boolean	20081103
4	P_OLE_ITEM	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20081009
5	P_OLE_RANGE	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20080923
6	P_R_WORKSHEET	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_WORKSHEET		Worksheet	20080923
7	P_TH_VALUES	Instance attribute	Private	☐	Type reference (TYPE)	T_TH_VALUE			20081007

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_LIST_OBJECT	Instance method	Public	Method		20081014
2	BUILD_VALUES	Instance method	Private	Method		20081007
3	BUILD_VALUES_EXTERNAL	Instance method	Private	Method		20090511
4	CONSTRUCTOR	Instance method	Private	Constructor		20080923
5	COPY	Instance method	Public	Method		20090511
6	FREE	Instance method	Private	Method		20080923
7	GET_ADDRESS	Instance method	Private	Method		20081120
8	GET_CELLS	Instance method	Public	Method		20081103
9	GET_CELL_FORMATS	Instance method	Public	Method		20090918
10	GET_COLUMN_COUNT	Instance method	Public	Method		20080923
11	GET_COLUMN_NAME	Instance method	Public	Method		20081103
12	GET_FORMATS	Instance method	Private	Method		20090918
13	GET_ROW_COUNT	Instance method	Public	Method		20080923
14	GET_VALUE	Instance method	Public	Method		20080923
15	GET_VALUES_CLIPBOARD	Instance method	Private	Method		20090512
16	GET_VALUE_ALL	Instance method	Public	Method		20090918
17	RESIZE	Instance method	Public	Method		20090506
18	SET_CELL_FORMATS	Instance method	Public	Method		20090924
19	SET_VALUE	Instance method	Public	Method		20080923
20	SUBRANGE	Instance method	Public	Method		20090512

Events

Class CL_RSDD_XLS_RANGE has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	T_S_VALUE	Private	See coding			20081007	begin of T_S_VALUE, x type i, y type i, value type string, number_format(30) type c, end of t_s_value
2	T_TH_VALUE	Private	See coding			20081007	t_th_value type HASHED TABLE OF t_s_value WITH UNIQUE key x y
3	T_T_VALUE	Private	See coding			20081007	t_t_value type STANDARD TABLE OF t_s_value WITH DEFAULT KEY

Method Signatures

Method ADD_LIST_OBJECT Signature

Method ADD_LIST_OBJECT on class CL_RSDD_XLS_RANGE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method BUILD_VALUES Signature

Method BUILD_VALUES on class CL_RSDD_XLS_RANGE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method BUILD_VALUES_EXTERNAL Signature

Method BUILD_VALUES_EXTERNAL on class CL_RSDD_XLS_RANGE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090511

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_OLE_RANGE	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20080923
2	Importing	I_R_WORKSHEET	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_WORKSHEET		Worksheet	20080923

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method COPY Signature

Method COPY on class CL_RSDD_XLS_RANGE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090511

Method FREE Signature

Method FREE on class CL_RSDD_XLS_RANGE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method GET_ADDRESS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_ADDRESS	Value transfer	☐	Type reference (TYPE)	STRING			20081120

Method GET_ADDRESS on class CL_RSDD_XLS_RANGE has no exception.

Method GET_CELLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_BOTTOM_RIGHT_COLUMN	Call by reference	☐	Type reference (TYPE)	I			20081103
2	Importing	I_BOTTOM_RIGHT_ROW	Call by reference	☐	Type reference (TYPE)	I			20081103
3	Importing	I_TOP_LEFT_COLUMN	Call by reference	☐	Type reference (TYPE)	I			20081103
4	Importing	I_TOP_LEFT_ROW	Call by reference	☐	Type reference (TYPE)	I			20081103
5	Returning	R_R_RANGE	Value transfer	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_RANGE		Excel Range	20081103

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method GET_CELL_FORMATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_NUMBER_FORMATS	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20090918
2	Importing	I_ROW	Call by reference	☐	Type reference (TYPE)	INT4		Natürliche Zahl	20090921
3	Importing	I_R_RANGE	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_RANGE		Excel Range	20090918

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090918

Method GET_COLUMN_COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_COUNT	Value transfer	☐	Type reference (TYPE)	I			20080923

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method GET_COLUMN_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_COLUMN	Call by reference	☐	Type reference (TYPE)	I			20081103
2	Returning	R_NAME	Value transfer	☐	Type reference (TYPE)	STRING			20081103

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method GET_FORMATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ROW	Call by reference	☐	Type reference (TYPE)	INT4		Natürliche Zahl	20090921
2	Returning	R_T_NUMBER_FORMATS	Value transfer	☐	Type reference (TYPE)	T_T_VALUE			20090918

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090918

Method GET_ROW_COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_COUNT	Value transfer	☐	Type reference (TYPE)	I			20080923

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method GET_VALUE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_EXTERNAL	Call by reference	☑	Type reference (TYPE)	RS_BOOL		Boolean	20090511
2	Importing	I_X	Call by reference	☐	Type reference (TYPE)	I			20080923
3	Importing	I_Y	Call by reference	☐	Type reference (TYPE)	I			20080923
4	Returning	R_VALUE	Value transfer	☐	Type reference (TYPE)	STRING			20080923

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method GET_VALUES_CLIPBOARD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_COL_OFFSET	Call by reference	☐	Type reference (TYPE)	I	0		20090512
2	Importing	I_ROW_OFFSET	Call by reference	☐	Type reference (TYPE)	I	0		20090512
3	Returning	R_T_VALUE	Value transfer	☐	Type reference (TYPE)	T_T_VALUE			20090512

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090512

Method GET_VALUE_ALL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_VALUES	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20090918
2	Importing	I_T_FORMATS	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20090924

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090918

Method RESIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_COLUMNS	Call by reference	☐	Type reference (TYPE)	I			20090506
2	Importing	I_ROWS	Call by reference	☐	Type reference (TYPE)	I			20090506
3	Returning	R_R_RANGE	Value transfer	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_RANGE		Excel Range	20090506

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090506

Method SET_CELL_FORMATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_FORMATS	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20090924

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090925

Method SET_VALUE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_VALUE	Call by reference	☐	Type reference (TYPE)	CLIKE			20080923
2	Importing	I_X	Call by reference	☐	Type reference (TYPE)	I			20080923
3	Importing	I_Y	Call by reference	☐	Type reference (TYPE)	I			20080923

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20081103

Method SUBRANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_COLUMNS	Call by reference	☐	Type reference (TYPE)	I			20090512
2	Importing	I_COL_OFFSET	Call by reference	☐	Type reference (TYPE)	I			20090512
3	Importing	I_ROWS	Call by reference	☐	Type reference (TYPE)	I			20090512
4	Importing	I_ROW_OFFSET	Call by reference	☐	Type reference (TYPE)	I			20090512
5	Returning	R_R_RANGE	Value transfer	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_RANGE		Excel Range	20090512

#	Exception	Resumable	Description	Created on
1	CX_RSDD_XLS_OLE_ERROR	☐	Allgemeiner Fehler bei OLE Aufruf	20090512

History

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