SAP ABAP Class CL_GRRM_UTIL_XLSX (Office2007 export)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-RM (Application Component) GRC Risk Management
     ⤷ GRRM_UTILITY (Package) Utility classes for Risk Management

Properties

Class	CL_GRRM_UTIL_XLSX
Short Description	Office2007 export
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	GRRM_UTILITY	Utility classes for Risk Management
Created	20110726	SAP
Last change	20141106
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_GRRM_UTIL_XLSX has no interface implemented.

Friends

Class CL_GRRM_UTIL_XLSX has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GC_CELLSTYLE_HEADER	Constant	Public	☐	Type reference (TYPE)	C	'H'		20110908
2	GC_CELLSTYLE_MASTER	Constant	Public	☐	Type reference (TYPE)	C	'M'		20110908
3	GC_CELLSTYLE_NORMAL	Constant	Public	☐	Type reference (TYPE)	C	'N'		20110908
4	GC_CELLSTYLE_SUBTITLE	Constant	Public	☐	Type reference (TYPE)	C	'S'		20110908
5	GC_CELLSTYLE_TITLE	Constant	Public	☐	Type reference (TYPE)	C	'T'		20110908
6	MC_ABC	Constant	Private	☐	Type reference (TYPE)	CHAR26	'ABCDEFGHIJKLMNOPQRSTUVWXYZ'		20110908
7	MC_DECIMALS_FORMAT	Constant	Private	☐	Type reference (TYPE)	CHAR26	'0.000000000'		20110908
8	MC_NUMERIC	Constant	Private	☐	Type reference (TYPE)	STRING	'PIFbsae'		20110908
9	MC_TYPE_DATE	Constant	Private	☐	Type reference (TYPE)	C	'D'		20110908
10	MC_TYPE_NUMERIC	Constant	Private	☐	Type reference (TYPE)	C	'N'		20110908
11	MC_TYPE_STRING	Constant	Private	☐	Type reference (TYPE)	C	'C'		20110908
12	MC_TYPE_TIME	Constant	Private	☐	Type reference (TYPE)	C	'T'		20110908
13	MC_TYPE_TIMESTAMP	Constant	Private	☐	Type reference (TYPE)	C	'X'		20110908
14	MO_XLSX_DOCUMENT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_XLSX_DOCUMENT			20110908
15	MS_SHAREDSTRING	Instance attribute	Private	☐	Type reference (TYPE)	YS_SHAREDSTRING_STRUC			20110908
16	MS_STYLE	Instance attribute	Private	☐	Type reference (TYPE)	YS_STYLE_STRUC			20110908
17	MT_SHEETS	Instance attribute	Private	☐	Type reference (TYPE)	YT_SHEETS			20110908
18	MV_EXCEL_XML	Instance attribute	Private	☐	Type reference (TYPE)	XSTRING			20110908

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_DRAWINGPART	Instance method	Private	Method		20110726
2	ADD_HYPERLINK	Instance method	Private	Method		20110726
3	ADD_IMAGE	Instance method	Private	Method		20110726
4	ADD_SHAREDSTRING	Instance method	Private	Method		20110726
5	ADD_SHEET	Instance method	Public	Method		20110726
6	ADD_STYLE	Instance method	Private	Method		20110726
7	CONSTRUCTOR	Instance method	Public	Constructor		20110726
8	CREATE_DATA_CELL	Instance method	Private	Method		20110726
9	GENERATE_XML_AND_OPC	Instance method	Private	Method		20110726
10	GET_CELLPOSITION	Instance method	Private	Method		20110726
11	GET_CELL_VALUE	Instance method	Private	Method		20110726
12	GET_COLUMN_COUNT	Instance method	Public	Method		20110726
13	GET_DAYS_1900_AND_PERCENT	Instance method	Private	Method		20110726
14	GET_DAYS_SINCE_1900	Instance method	Private	Method		20110726
15	GET_IMAGE_CONTENT	Instance method	Private	Method		20110726
16	GET_IMAGE_SIZE	Instance method	Private	Method		20110726
17	GET_ISONUM_FROM_INTNUM	Instance method	Private	Method		20110726
18	GET_PERCENT_OF_ACT_DAY	Instance method	Private	Method		20110726
19	SET_CELL	Instance method	Public	Method		20110726
20	SET_CELL_INTERNAL	Instance method	Private	Method		20110726
21	SET_COLUMN_HIDDEN	Instance method	Public	Method		20110726
22	SET_COLUMN_WIDTH	Instance method	Public	Method		20110726
23	SET_GROUPING	Instance method	Public	Method		20110726
24	SET_SPAN_ROW	Instance method	Public	Method		20110726
25	TO_STRING_BOOLEAN	Instance method	Private	Method		20110726
26	TRANSFORM	Instance method	Public	Method		20110726

Events

Class CL_GRRM_UTIL_XLSX has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	YS_CELL_STRUC	Private	See coding			20110726	begin of ys_cell_struc, position type string, value type string, index type i, style type i, sharedstring type string, order type i, end of ys_cell_struc
2	YS_COLUMNINFO	Private	See coding			20110726	begin of ys_columninfo, column_index type i, width type i, maxwidth type i, hidden type boolean, end of ys_columninfo
3	YS_COL_STRUC	Private	See coding			20110726	begin of ys_col_struc, min type i, max type i, bestFit type i, hidden type i, width type i, end of ys_col_struc
4	YS_HYPERLINK_MAP	Private	See coding			20110726	begin of ys_hyperlink_map, link type string, rel_id type string, end of ys_hyperlink_map
5	YS_HYPERLINK_STRUC	Private	See coding			20110726	begin of ys_hyperlink_struc, rel_id type string, cell_id type string, end of ys_hyperlink_struc
6	YS_IMAGE	Private	See coding			20110726	begin of ys_image, index type i, col type i, row type i, name type string, descr type string, rel_id type string, height type i, width type i, end of ys_image
7	YS_IMAGE_MAP	Private	See coding			20110726	begin of ys_image_map, id type string, rel_id type string, height type i, width type i, end of ys_image_map
8	YS_IMAGE_STRUC	Private	See coding			20110726	begin of YS_image_struc, t_images type standard table of ys_image with key name initial size 1, end of ys_image_struc
9	YS_MERGECELLS	Private	See coding			20110726	begin of ys_mergecells, range type string, end of ys_mergecells
10	YS_ROW_STRUC	Private	See coding			20110726	begin of ys_row_struc, spans type string, position type i, outlinelevel type i, hidden type char1, height type i, rowstyle type char1, range type boolean, t_cells type standard table of ys_cell_struc with non-unique key position initial size 1, end of ys_row_struc
11	YS_SHAREDSTRING	Private	See coding			20110726	begin of ys_sharedstring, value type string, end of ys_sharedstring
12	YS_SHAREDSTRING_STRUC	Private	See coding			20110726	begin of ys_sharedstring_struc, t_strings type standard table of ys_sharedstring with key value initial size 1, string_count type i, string_ucount type i, end of ys_sharedstring_struc
13	YS_SHEET_STRUC	Private	See coding			20110726	begin of ys_sheet_struc, dim type string, name type string, outlinelevel type i, summary_below type string, mergecell_count type i, max_col type i, max_row type i, max_level type i, max_span_width type i, t_columninfo type yt_columninfo, t_rows type standard table of ys_row_struc with non-unique key position initial size 1, t_cols type standard table of ys_col_struc with non-unique key min initial size 1, t_hyperlinks type standard table of ys_hyperlink_struc with non-unique key cell_id initial size 1, t_mergecells type standard table of ys_mergecells with non-unique key range initial size 1, drawing_id type string, drawingpart type ref to CL_OXML_DRAWINGSPART, relid type string, sheetid type i, HYPERLINK_MAP type hashed table of YS_HYPERLINK_MAP with unique key link, worksheetpart type ref to cl_xlsx_worksheetpart, IMAGE_STRUCT type YS_IMAGE_STRUC, IMAGE_MAP type hashed table of ys_image_map with unique key id, end of ys_sheet_struc
14	YS_STYLE_CELLXF	Private	See coding			20110726	begin of ys_style_cellxf, index type i, numfmtid type i, fillid type i, borderid type i, is_string type i, indent type i, xfid type i, wrap type i, key type string, end of ys_style_cellxf
15	YS_STYLE_NUMFMT	Private	See coding			20110726	begin of ys_style_numfmt, id type i, code type string, end of ys_style_numfmt
16	YS_STYLE_STRUC	Private	See coding			20110726	begin of YS_STYLE_STRUC, t_numFmts type standard table of ys_style_numfmt with key id initial size 1, t_cellxfs type standard table of ys_style_cellxf with key key indent xfid wrap initial size 1, numfmts_count type i, cellxfs_count type i, end of ys_style_struc
17	YT_COLUMNINFO	Private	See coding			20110726	yt_columninfo type hashed table of ys_columninfo with unique key column_index initial size 1
18	YT_SHEETS	Private	See coding			20110726	yt_sheets type standard table of ys_sheet_struc with key name initial size 1

Method Signatures

Method ADD_DRAWINGPART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method ADD_DRAWINGPART on class CL_GRRM_UTIL_XLSX has no exception.

Method ADD_HYPERLINK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELL_ID	Call by reference	☐	Type reference (TYPE)	STRING			20110908
2	Importing	IV_LINK	Call by reference	☐	Type reference (TYPE)	STRING			20110908
3	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method ADD_HYPERLINK on class CL_GRRM_UTIL_XLSX has no exception.

Method ADD_IMAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CV_HEIGHT	Call by reference	☐	Type reference (TYPE)	I			20110908
2	Changing	CV_WIDTH	Call by reference	☐	Type reference (TYPE)	I			20110908
3	Importing	IV_COL	Call by reference	☐	Type reference (TYPE)	I			20110908
4	Importing	IV_CONTENT	Call by reference	☐	Type reference (TYPE)	XSTRING			20110908
5	Importing	IV_ID	Call by reference	☐	Type reference (TYPE)	STRING			20110908
6	Importing	IV_ROW	Call by reference	☐	Type reference (TYPE)	I			20110908
7	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method ADD_IMAGE on class CL_GRRM_UTIL_XLSX has no exception.

Method ADD_SHAREDSTRING Signature

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

Method ADD_SHAREDSTRING on class CL_GRRM_UTIL_XLSX has no exception.

Method ADD_SHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method ADD_SHEET on class CL_GRRM_UTIL_XLSX has no exception.

Method ADD_STYLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELLSTYLE	Call by reference	☐	Type reference (TYPE)	C	'N'		20110908
2	Importing	IV_DECIMALS	Call by reference	☐	Type reference (TYPE)	I	0		20110908
3	Importing	IV_HYPERLINK	Call by reference	☐	Type reference (TYPE)	I	0		20110908
4	Importing	IV_INDENT	Call by reference	☐	Type reference (TYPE)	I	0		20110908
5	Importing	IV_TYPE	Call by reference	☐	Type reference (TYPE)	C			20110908
6	Importing	IV_WRAP	Call by reference	☐	Type reference (TYPE)	I	0		20110908
7	Returning	RV_INDEX	Value transfer	☐	Type reference (TYPE)	I			20110908

Method ADD_STYLE on class CL_GRRM_UTIL_XLSX has no exception.

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_GRRM_UTIL_XLSX has no parameter.
Method CONSTRUCTOR on class CL_GRRM_UTIL_XLSX has no exception.

Method CREATE_DATA_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_DECIMALS	Call by reference	☐	Type reference (TYPE)	I			20110908
2	Exporting	EV_INTTYPE	Call by reference	☐	Type reference (TYPE)	C			20110908
3	Exporting	EV_TYPENAME	Call by reference	☐	Type reference (TYPE)	STRING			20110815
4	Exporting	EV_VALUE	Call by reference	☐	Type reference (TYPE)	STRING			20110908
5	Importing	IV_CELL_ID	Call by reference	☐	Type reference (TYPE)	STRING			20110908
6	Importing	IV_CHECKBOX	Call by reference	☐	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
7	Importing	IV_DATA	Call by reference	☐	Type reference (TYPE)	ANY			20110908
8	Importing	IV_HYPERLINK	Call by reference	☐	Type reference (TYPE)	STRING			20110908
9	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method CREATE_DATA_CELL on class CL_GRRM_UTIL_XLSX has no exception.

Method GENERATE_XML_AND_OPC Signature

Method GENERATE_XML_AND_OPC on class CL_GRRM_UTIL_XLSX has no parameter.
Method GENERATE_XML_AND_OPC on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_CELLPOSITION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COL	Call by reference	☐	Type reference (TYPE)	I			20110908
2	Importing	IV_ROW	Call by reference	☐	Type reference (TYPE)	I			20110908
3	Returning	RV_RESULT	Value transfer	☐	Type reference (TYPE)	STRING			20110908

Method GET_CELLPOSITION on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_CELL_VALUE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_DECIMALS	Call by reference	☐	Type reference (TYPE)	DATA			20110908
2	Exporting	EV_INTTYPE	Call by reference	☐	Type reference (TYPE)	C			20110908
3	Exporting	EV_TYPENAME	Call by reference	☐	Type reference (TYPE)	STRING			20110815
4	Exporting	EV_VALUE	Call by reference	☐	Type reference (TYPE)	DATA			20110908
5	Importing	IV_CHECKBOX	Call by reference	☐	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
6	Importing	IV_DATA	Call by reference	☐	Type reference (TYPE)	ANY			20110908

Method GET_CELL_VALUE on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_COLUMN_COUNT Signature

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

Method GET_COLUMN_COUNT on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_DAYS_1900_AND_PERCENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	P			20110908
2	Returning	RV_NUM	Value transfer	☐	Type reference (TYPE)	STRING			20110908

Method GET_DAYS_1900_AND_PERCENT on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_DAYS_SINCE_1900 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_DATE	Call by reference	☐	Type reference (TYPE)	D			20110908
2	Returning	RV_NUM	Value transfer	☐	Type reference (TYPE)	STRING			20110908

Method GET_DAYS_SINCE_1900 on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_IMAGE_CONTENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_IMAGE_VALUE	Call by reference	☐	Type reference (TYPE)	DATA			20110908
2	Returning	RV_VALUE	Value transfer	☐	Type reference (TYPE)	XSTRING			20110908

Method GET_IMAGE_CONTENT on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_IMAGE_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_HEIGHT	Call by reference	☐	Type reference (TYPE)	I			20110908
2	Exporting	EV_WIDTH	Call by reference	☐	Type reference (TYPE)	I			20110908
3	Importing	IV_CONTENT	Call by reference	☐	Type reference (TYPE)	XSTRING			20110908
4	Importing	IV_IMAGE_TYPE	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method GET_IMAGE_SIZE on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_ISONUM_FROM_INTNUM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_DECIMALS	Call by reference	☑	Type reference (TYPE)	ANY			20110908
2	Importing	IV_VALUE	Call by reference	☐	Type reference (TYPE)	ANY			20110908
3	Returning	RV_VALUE	Value transfer	☐	Type reference (TYPE)	STRING			20110908

Method GET_ISONUM_FROM_INTNUM on class CL_GRRM_UTIL_XLSX has no exception.

Method GET_PERCENT_OF_ACT_DAY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_TIME	Call by reference	☐	Type reference (TYPE)	T			20110908
2	Returning	RV_NUM	Value transfer	☐	Type reference (TYPE)	STRING			20110908

Method GET_PERCENT_OF_ACT_DAY on class CL_GRRM_UTIL_XLSX has no exception.

Method SET_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELLSTYLE	Call by reference	☐	Type reference (TYPE)	C	GC_CELLSTYLE_NORMAL		20110908
2	Importing	IV_CHECKBOX	Call by reference	☑	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
3	Importing	IV_COL_INDEX	Call by reference	☐	Type reference (TYPE)	I			20110908
4	Importing	IV_DATA	Call by reference	☐	Type reference (TYPE)	ANY			20110908
5	Importing	IV_HYPERLINK	Call by reference	☑	Type reference (TYPE)	STRING			20110908
6	Importing	IV_IMAGE_SOURCE	Call by reference	☑	Type reference (TYPE)	STRING			20110908
7	Importing	IV_INDENT	Call by reference	☐	Type reference (TYPE)	I	0		20110908
8	Importing	IV_ROW_INDEX	Call by reference	☐	Type reference (TYPE)	I			20110908
9	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908
10	Importing	IV_WRAP	Call by reference	☐	Type reference (TYPE)	I	0		20120224

Method SET_CELL on class CL_GRRM_UTIL_XLSX has no exception.

Method SET_CELL_INTERNAL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELLSTYLE	Call by reference	☐	Type reference (TYPE)	C	GC_CELLSTYLE_NORMAL		20110908
2	Importing	IV_CHECKBOX	Call by reference	☑	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
3	Importing	IV_COL_INDEX	Call by reference	☐	Type reference (TYPE)	I			20110908
4	Importing	IV_DATA	Call by reference	☐	Type reference (TYPE)	ANY			20110908
5	Importing	IV_HYPERLINK	Call by reference	☑	Type reference (TYPE)	STRING			20110908
6	Importing	IV_IGNORE_WIDTH	Call by reference	☐	Type reference (TYPE)	BOOLEAN	ABAP_FALSE		20110908
7	Importing	IV_IMAGE_SOURCE	Call by reference	☑	Type reference (TYPE)	STRING			20110908
8	Importing	IV_INDENT	Call by reference	☐	Type reference (TYPE)	I	0		20110908
9	Importing	IV_ROW_INDEX	Call by reference	☐	Type reference (TYPE)	I			20110908
10	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908
11	Importing	IV_SPAN	Call by reference	☑	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
12	Importing	IV_WRAP	Call by reference	☐	Type reference (TYPE)	I	0		20120224

Method SET_CELL_INTERNAL on class CL_GRRM_UTIL_XLSX has no exception.

Method SET_COLUMN_HIDDEN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COL_INDEX	Call by reference	☐	Type reference (TYPE)	I			20110908
2	Importing	IV_HIDDEN	Call by reference	☐	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
3	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method SET_COLUMN_HIDDEN on class CL_GRRM_UTIL_XLSX has no exception.

Method SET_COLUMN_WIDTH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COL_INDEX	Call by reference	☐	Type reference (TYPE)	I			20110908
2	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908
3	Importing	IV_WIDTH	Call by reference	☐	Type reference (TYPE)	I			20110908

Method SET_COLUMN_WIDTH on class CL_GRRM_UTIL_XLSX has no exception.

Method SET_GROUPING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLLAPSED	Call by reference	☐	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
2	Importing	IV_END_ROW	Call by reference	☐	Type reference (TYPE)	I			20110908
3	Importing	IV_LEVEL	Call by reference	☐	Type reference (TYPE)	I			20110908
4	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908
5	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20110908

Method SET_GROUPING on class CL_GRRM_UTIL_XLSX has no exception.

Method SET_SPAN_ROW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELLSTYLE	Call by reference	☐	Type reference (TYPE)	C	GC_CELLSTYLE_NORMAL		20110908
2	Importing	IV_CHECKBOX	Call by reference	☑	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110908
3	Importing	IV_DATA	Call by reference	☐	Type reference (TYPE)	ANY			20110908
4	Importing	IV_HYPERLINK	Call by reference	☑	Type reference (TYPE)	STRING			20110908
5	Importing	IV_IMAGE_SOURCE	Call by reference	☑	Type reference (TYPE)	STRING			20110908
6	Importing	IV_INDENT	Call by reference	☐	Type reference (TYPE)	I	0		20110908
7	Importing	IV_ROW_INDEX	Call by reference	☐	Type reference (TYPE)	I			20110908
8	Importing	IV_SHEETNAME	Call by reference	☐	Type reference (TYPE)	STRING			20110908

Method SET_SPAN_ROW on class CL_GRRM_UTIL_XLSX has no exception.

Method TO_STRING_BOOLEAN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_INPUT	Call by reference	☐	Type reference (TYPE)	ANY			20110908
2	Returning	RV_VALUE	Value transfer	☐	Type reference (TYPE)	STRING			20110908

Method TO_STRING_BOOLEAN on class CL_GRRM_UTIL_XLSX has no exception.

Method TRANSFORM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_XML	Value transfer	☐	Type reference (TYPE)	XSTRING			20110908

Method TRANSFORM on class CL_GRRM_UTIL_XLSX has no exception.

History

Last changed by/on	SAP	20141106
SAP Release Created in	V1100