SAP ABAP Class CL_RSDD_XLS_WORKSHEETS (Worksheets)

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_WORKSHEETS
Short Description	Worksheets
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_WORKSHEETS has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDD_XLS_WORKBOOK	☐	20080923	Workbook

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_OLE_WORKSHEETS	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT		Structure for collecting active OLE objects	20080923
2	P_R_WORKBOOK	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_WORKBOOK		Workbook	20080923
3	P_T_WORKSHEET	Instance attribute	Private	☐	Type reference (TYPE)	T_T_WORKSHEET			20080923

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_WORKSHEET	Instance method	Public	Method		20080923
2	CONSTRUCTOR	Instance method	Private	Constructor		20080923
3	FREE	Instance method	Private	Method		20080923
4	GET_COUNT	Instance method	Public	Method		20080923
5	GET_WORKSHEET	Instance method	Public	Method		20080923
6	GET_WORKSHEET_BY_NAME	Instance method	Public	Method		20080923

Events

Class CL_RSDD_XLS_WORKSHEETS has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	T_T_WORKSHEET	Private	See coding			20080923	T_T_WORKSHEET type STANDARD TABLE OF ref to cl_rsdd_xls_worksheet

Method Signatures

Method ADD_WORKSHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_R_WORKSHEET	Value transfer	☐	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	20081222

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_OLE_WORKSHEETS	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20080923
2	Importing	I_R_WORKBOOK	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDD_XLS_WORKBOOK		Workbook	20080923

Method CONSTRUCTOR on class CL_RSDD_XLS_WORKSHEETS has no exception.

Method FREE Signature

Method FREE on class CL_RSDD_XLS_WORKSHEETS has no parameter.

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

Method GET_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	20081222

Method GET_WORKSHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INDEX	Call by reference	☐	Type reference (TYPE)	I			20080923
2	Returning	R_R_WORKSHEET	Value transfer	☐	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	20081222

Method GET_WORKSHEET_BY_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)	STRING			20080923
2	Returning	R_R_WORKSHEET	Value transfer	☐	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	20081222
2	CX_RSDD_XLS_SHEET_NOT_EXIST	☐	Workbook Öffnen fehlgeschlagen	20081010

History

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