SAP ABAP Class CL_RSDD_XLS_WORKSHEET (Worksheet)

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_WORKSHEET
Short Description	Worksheet
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	OLE2	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSDD_XLS_WORKSHEET has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDD_XLS_RANGE	☐	20081103	Excel Range
2	CL_RSDD_XLS_WORKSHEETS	☐	20080923	Worksheets

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_OLE_WORKSHEET	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20080923
2	P_R_WORKSHEETS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_WORKSHEETS		Worksheets	20080923
3	P_T_RANGE	Instance attribute	Private	☐	Type reference (TYPE)	T_T_RANGE			20080923

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Private	Constructor		20080923
2	FREE	Instance method	Private	Method		20080923
3	GET_CELLS	Instance method	Private	Method		20081103
4	GET_DATA_RANGE	Instance method	Public	Method		20081015
5	GET_NAME	Instance method	Public	Method		20081006
6	GET_RANGE	Instance method	Public	Method		20080923
7	GET_USED_RANGE	Instance method	Public	Method		20081120
8	SET_NAME	Instance method	Public	Method		20081014

Events

Class CL_RSDD_XLS_WORKSHEET has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	T_S_RANGE	Private	See coding			20081104	BEGIN OF t_s_range, address type string, range type REF TO cl_rsdd_xls_range, end of t_s_range
2	T_T_RANGE	Private	See coding			20080923	T_T_RANGE type HASHED TABLE OF t_s_range WITH UNIQUE key address INITIAL SIZE 10

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_OLE_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20080923
2	Importing	I_R_WORKSHEETS	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_WORKSHEETS		Worksheets	20080923

Method CONSTRUCTOR on class CL_RSDD_XLS_WORKSHEET has no exception.

Method FREE Signature

Method FREE on class CL_RSDD_XLS_WORKSHEET has no parameter.

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

Method GET_CELLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_RANGE1	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20081103
2	Importing	I_RANGE2	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20081103
3	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_DATA_RANGE 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			20081015

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

Method GET_NAME Signature

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

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

Method GET_RANGE Signature

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

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

Method GET_USED_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_R_RANGE	Value transfer	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_RANGE		Excel Range	20081120

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

Method SET_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20081014

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

History

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