SAP ABAP Class CL_RSR_EXCEL_GRID (Output Table Creation for Excel)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-ET (Application Component) End User Technology
     ⤷ RSR (Package) BW: General reporting processor

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSR_GRID	Grid	20010222

Properties

Class	CL_RSR_EXCEL_GRID
Short Description	Output Table Creation for Excel
Super Class	CL_RSR_GRID	Grid
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSR	BW: General reporting processor
Created	20010222	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RRX1	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSR_EXCEL_GRID has no interface implemented.

Friends

Class CL_RSR_EXCEL_GRID has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_LF	Static Attribute	Private	☐	Type reference (TYPE)	STRING		Line feed	20010716
2	C_LF_QDEF_DEFAULT	Static Attribute	Private	☐	Type reference (TYPE)	STRING		Line feed	20010716
3	C_TEXT_PREFIX	Constant	Public	☐	Type reference (TYPE)	CHAR1	''''	Prefix so that Excel Displays a Line as Text	20010301
4	N_MAX_X	Instance attribute	Public	☑	Type reference (TYPE)	RRX_RANGES-X1		Column Coordinate	20010525
5	N_MAX_Y	Instance attribute	Public	☑	Type reference (TYPE)	RRX_RANGES-Y1		Row Coordinates	20010525
6	N_T_GRID	Instance attribute	Public	☑	Type reference (TYPE)	RRX1_T_GRID		Cells	20010301
7	N_T_RANGES	Instance attribute	Public	☑	Type reference (TYPE)	RRX1_T_RANGES		Formats	20010301
8	N_T_SYMBOLS	Instance attribute	Public	☑	Type reference (TYPE)	RRX_T_SYMBOLS		Symbols	20010523
9	N_T_TEXT	Instance attribute	Public	☑	Type reference (TYPE)	RRX_T_TEXT		Texts / URLs	20010523
10	O_TH_DOC_COORDINATE	Instance attribute	Protected	☐	Type reference (TYPE)	RSR_TH_CELL_COORDINATE		Document Coordinates	20020918
11	P_DECIMAL_CHARACTER	Instance attribute	Private	☐	Type reference (TYPE)	CHAR1		Decimal Point Format	20010315
12	P_FORMATTED_VALUES	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Display Formatted Values	20010315
13	P_LF_QDEF	Instance attribute	Private	☐	Type reference (TYPE)	STRING		Line Feed Display Of Query Definition	20010716
14	P_MAX_X	Instance attribute	Private	☐	Type reference (TYPE)	I		Maximum Number of Columns	20010905
15	P_NOMULTTXT	Instance attribute	Private	☐	Type reference (TYPE)	RRXNOMULTTXT		Query: Suppression of Repitition Texts	20010315
16	P_NOSTYLES	Instance attribute	Private	☐	Type reference (TYPE)	RRXNOSTYLES		Use Formats	20010315
17	P_NOZERO	Instance attribute	Private	☐	Type reference (TYPE)	RRXNOZERO		Suppress Zeros	20010315
18	P_RANGE_OPTIMIZATION	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Optimize Range Table with Fill	20030502
19	P_SIGNPRSNT	Instance attribute	Private	☐	Type reference (TYPE)	RRXSIGNPRSNT		Display of +/- Signs	20010315
20	P_S_DATA	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_S_DAT_N		Last Data Cell for VB Format Optimization	20010315
21	P_S_RANGE_INT	Instance attribute	Private	☐	Type reference (TYPE)	TP_S_RANGES_INT		Range Optimization	20010525
22	P_S_SESSION_PRPTYS	Static Attribute	Private	☐	Type reference (TYPE)	RRX1_S_SESSION_PRPTYS		Session Settings	20020110
23	P_S_SPECIAL_CELL	Static Attribute	Private	☐	Type reference (TYPE)	TP_S_SPECIAL_CELL			20010315
24	P_TXTID_COUNTER	Instance attribute	Private	☐	Type reference (TYPE)	I		Counter for Text ID	20010523
25	P_T_RANGE_INT	Instance attribute	Private	☐	Type reference (TYPE)	TP_T_RANGES_INT		Internal Ranges	20010525
26	P_USER_DECIMAL_CHARACTER	Static Attribute	Private	☐	Type reference (TYPE)	CHAR1		Decimal Places in the User Settings	20010315
27	P_VBFORMAT	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_S_RANGES-VBFORMAT		Last VB Format for Optimization	20010315
28	P_ZEROPRSNT	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_ZEROPRSNT		Zero Representation	20010627
29	P_ZEROTEXT	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_ZEROTEXT		Zero Text	20010627

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_RANGE	Instance method	Private	Method	Write Optimized Entry in the Range	20010315
2	APPEND_TEXT	Instance method	Private	Method	Include Text	20010523
3	CLASS_CONSTRUCTOR	Static method	Public	Constructor	Class Constructor	20010315
4	FILL_GRID	Instance method	Public	Method	Fill Output Tables	20010222
5	FILL_RANGES	Instance method	Private	Method	Fill Ranges	20010525
6	GET_DATA_CELL_CONTENT	Instance method	Private	Method	Content for Data Cell	20010315
7	GET_DATA_CELL_TEXT	Instance method	Private	Method	Cell Text for Data Cells	20010315
8	IN_EX_CONVERT	Static method	Private	Method	Convert Internal Display into External	20010315
9	LEVEL_MERGE	Instance method	Private	Method	Merge Levels	20010525
10	MERGE_RANGES	Instance method	Private	Method	Merge Ranges	20010525
11	MOST_COMMON_FORMATS	Instance method	Private	Method	Most Frequently Used Formats	20010525
12	NOTIFY_SESSION_SETTINGS	Static method	Public	Method	Excel Session Settings (Date Format, ...)	20020110
13	RESOLVE_RANGE	Static method	Public	Method	Trigger Range for Test Programs	20040311
14	SET_LIST_PROPERTIES	Instance method	Private	Method	Set Properties of List like 0 Suppression, ...	20010315
15	VBFORMAT_GET	Instance method	Private	Method	VB Format for Data Cell	20010315
16	VBFORMAT_GET_STATIC	Static method	Public	Method	VB Format for Data Cell	20020613

Events

Class CL_RSR_EXCEL_GRID has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TP_S_FORMAT	Private	See coding			20010525
2	TP_S_RANGES_INT	Private	See coding			20010525
3	TP_S_SPECIAL_CELL	Private	See coding			20010315
4	TP_T_RANGES_INT	Private	See coding			20010525

Method Signatures

Method ADD_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_RANGE	Call by reference	☑	Type reference (TYPE)	RRX1_S_RANGES		Range Entry	20010315

Method ADD_RANGE on class CL_RSR_EXCEL_GRID has no exception.

Method APPEND_TEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_ID	Value transfer	☐	Type reference (TYPE)	RRX_TXTID		Text ID	20010523
2	Exporting	E_INDEX	Call by reference	☐	Type reference (TYPE)	RRX_TXTID		Index of Text	20010523
3	Importing	I_TEXT	Call by reference	☐	Type reference (TYPE)	STRING		Text	20010523

Method APPEND_TEXT on class CL_RSR_EXCEL_GRID has no exception.

Method CLASS_CONSTRUCTOR Signature

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

Method FILL_GRID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DECIMAL_CHARACTER	Call by reference	☐	Type reference (TYPE)	CHAR1	','	Dezimalzeichen	20010315
2	Importing	I_FORMATTED_VALUES	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Formattierte Werte anzeigen	20010315
3	Importing	I_FROM_COLUMN	Call by reference	☐	Type reference (TYPE)	I	0	Anfangsspalte (Daten)	20010301
4	Importing	I_FROM_ROW	Call by reference	☐	Type reference (TYPE)	I	0	Anfangszeile (Daten)	20010301
5	Importing	I_MAX_COLS	Call by reference	☐	Type reference (TYPE)	I	0	Maximale Anzahl von Spalten	20010905
6	Importing	I_TO_COLUMN	Call by reference	☐	Type reference (TYPE)	I	0	Endspalte (Daten)	20010301
7	Importing	I_TO_ROW	Call by reference	☐	Type reference (TYPE)	I	0	Endzeile (Daten)	20010301
8	Importing	I_WITH_CAPTION_COLUMNS	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Spaltenüberschriften erzeugen	20010301
9	Importing	I_WITH_CAPTION_ROWS	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Zeilenüberschriften erzeugen	20010301
10	Importing	I_WITH_DATA	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Werte ins Grid füllen	20010301

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X-Message	20010315

Method FILL_RANGES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_AREA_OPTIMIZATION	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Bereiche mit optimieren (nicht beim Hierarchie drill)	20020614

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X Message	20010525

Method GET_DATA_CELL_CONTENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Data	20010315
2	Returning	R_CONTENT	Value transfer	☐	Type reference (TYPE)	RRX1_S_GRID-CONTENT		Content	20010315

Method GET_DATA_CELL_CONTENT on class CL_RSR_EXCEL_GRID has no exception.

Method GET_DATA_CELL_TEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Data	20010315
2	Returning	R_TEXT	Value transfer	☐	Type reference (TYPE)	RRX1_S_GRID-DATA		Text	20010315

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X Message	20010315

Method IN_EX_CONVERT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_DATA	Call by reference	☐	Type reference (TYPE)	RRXDATA		Data	20010315
2	Importing	I_INTTP	Call by reference	☐	Type reference (TYPE)	INTTYPE		Type	20010315
3	Importing	I_VALUE	Call by reference	☐	Type reference (TYPE)	RSROA_DF		Value	20010315

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X Message	20010315

Method LEVEL_MERGE Signature

Method LEVEL_MERGE on class CL_RSR_EXCEL_GRID has no parameter.
Method LEVEL_MERGE on class CL_RSR_EXCEL_GRID has no exception.

Method MERGE_RANGES Signature

Method MERGE_RANGES on class CL_RSR_EXCEL_GRID has no parameter.
Method MERGE_RANGES on class CL_RSR_EXCEL_GRID has no exception.

Method MOST_COMMON_FORMATS Signature

Method MOST_COMMON_FORMATS on class CL_RSR_EXCEL_GRID has no parameter.
Method MOST_COMMON_FORMATS on class CL_RSR_EXCEL_GRID has no exception.

Method NOTIFY_SESSION_SETTINGS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_SESSION_SETTINGS	Call by reference	☐	Type reference (TYPE)	RRX1_S_SESSION_PRPTYS		Einstellungen (Datumsformat, ...) der Excel Session	20020110

Method NOTIFY_SESSION_SETTINGS on class CL_RSR_EXCEL_GRID has no exception.

Method RESOLVE_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_RANGES	Call by reference	☐	Type reference (TYPE)	RRX1_T_RANGES		Range	20040311
2	Importing	I_FROM_COLUMN	Call by reference	☐	Type reference (TYPE)	I		Von Spalte	20040311
3	Importing	I_FROM_ROW	Call by reference	☐	Type reference (TYPE)	I		Von Zeile	20040311
4	Importing	I_TO_COLUMN	Call by reference	☐	Type reference (TYPE)	I		Nach Spalte	20040311
5	Importing	I_TO_ROW	Call by reference	☐	Type reference (TYPE)	I		Bis Zeile	20040311

Method RESOLVE_RANGE on class CL_RSR_EXCEL_GRID has no exception.

Method SET_LIST_PROPERTIES Signature

Method SET_LIST_PROPERTIES on class CL_RSR_EXCEL_GRID has no parameter.
Method SET_LIST_PROPERTIES on class CL_RSR_EXCEL_GRID has no exception.

Method VBFORMAT_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Data	20010315
2	Returning	R_VBFORMAT	Value transfer	☐	Type reference (TYPE)	RRX1_S_RANGES-VBFORMAT		VB Format	20010315

Method VBFORMAT_GET on class CL_RSR_EXCEL_GRID has no exception.

Method VBFORMAT_GET_STATIC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_REQUEST	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSR_REQUEST		Datenanforderung vom OLAP-Prozessor	20020613
2	Importing	I_SIGNPRSNT	Call by reference	☐	Type reference (TYPE)	RRXSIGNPRSNT	RRX1_C_SIGNPRSNT-BEFORE	Vorzeichendarstellung	20020613
3	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Data	20020613
4	Importing	I_ZEROPRSNT	Call by reference	☐	Type reference (TYPE)	RRX1_ZEROPRSNT	RRX1_C_ZEROPRSNT-DISPLAY	Nulldarstellung	20020613
5	Returning	R_VBFORMAT	Value transfer	☐	Type reference (TYPE)	RRX1_S_RANGES-VBFORMAT		VB Format	20020613

Method VBFORMAT_GET_STATIC on class CL_RSR_EXCEL_GRID has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	30A