SAP ABAP Class CL_WDR_DG_EXEXP_FORMAT_XLSX (DataGrid Export Format XLSX)

Hierarchy

☛ SAP_UI (Software Component) User Interface Technology
   ⤷ BC-WD-ABA (Application Component) Web Dynpro ABAP
     ⤷ SWDP_UIEL_DATA_GRID (Package) UIE Library "Data Grid"

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_WD_DG_EXEXP_FORMAT	Data Grid Export Format Interface	20131007

Properties

Class	CL_WDR_DG_EXEXP_FORMAT_XLSX
Short Description	DataGrid Export Format XLSX
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SWDP_UIEL_DATA_GRID	UIE Library "Data Grid"
Created	20131007	SAP
Last change	20141120
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_WDR_DG_EXEXP_FORMAT_XLSX has no forward declaration.

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_WD_DG_EXEXP_FORMAT	☐	☐	Data Grid Export Format Interface	20131007

Friends

Class CL_WDR_DG_EXEXP_FORMAT_XLSX has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MO_XLSX_FILE	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	CL_XLSX_DOCUMENT			20131024
2	MS_FILE	Instance attribute	Protected	☐	Type reference (TYPE)	YS_FILE			20131008
3	MS_SHAREDSTRINGS_STRUC	Instance attribute	Protected	☐	Type reference (TYPE)	YS_SHAREDSTRING_STRUC			20131008
4	MT_MERGED_CELLS	Instance attribute	Protected	☐	Type reference (TYPE)	YT_MERGED_CELL			20131028
5	MT_NUMBERFORMATS	Instance attribute	Protected	☐	Type reference (TYPE)	YTH_NUMBERFORMAT			20131008
6	MT_SHAREDSTRINGS	Instance attribute	Protected	☐	Type reference (TYPE)	YTH_SHAREDSTRING			20131008
7	MT_STRINGS	Instance attribute	Protected	☐	Type reference (TYPE)	YT_STRING_TAB			20131008
8	MT_STYLES	Instance attribute	Protected	☐	Type reference (TYPE)	YTH_STYLE			20131008
9	MV_LAST_NUMBERFORMAT	Instance attribute	Protected	☐	Type reference (TYPE)	I	190		20140425

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_SHARED_STRING	Instance method	Private	Method		20131016
2	ADD_STRING	Instance method	Private	Method		20131009
3	ADD_STYLE	Instance method	Private	Method		20131021
4	FILL_ROOT_DOC_PROPS	Instance method	Private	Method		20131008
5	FILL_ROOT_XL	Instance method	Private	Method		20131008
6	FILL_ROOT_XL_SHAREDSTRINGS	Instance method	Private	Method		20131014
7	FILL_ROOT_XL_WORKSHEETS	Instance method	Private	Method		20131008
8	FINALIZE_ROOT_XL_STYLES	Instance method	Private	Method		20131014
9	FINALIZE_ROOT_XL_WRKSTS_SHEET1	Instance method	Private	Method		20131014
10	GET_COLPOS_ALPHA	Static method	Private	Method		20131008
11	GET_CONTENT_FROM_STRINGTAB	Instance method	Private	Method		20131024
12	GET_NUMBER_FORMAT	Instance method	Private	Method		20140425
13	PREPARE_DRAWINGS	Instance method	Private	Method		20131008
14	PREPARE_ROOT_XL_STYLES	Instance method	Private	Method		20131008
15	PREPARE_ROOT_XL_WRKSTS_SHEET1	Instance method	Private	Method		20131014

Events

Class CL_WDR_DG_EXEXP_FORMAT_XLSX has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	YS_FILE	Protected	See coding			20131008	begin of ys_file, docprops type ys_root_doc_props, xl type ys_root_xl, end of ys_file
2	YS_HYPERLINK	Protected	See coding			20131008	begin of ys_hyperlink, id type i, cell type string, url type string, end of ys_hyperlink
3	YS_MERGED_CELL	Protected	See coding			20131028	begin of ys_merged_cell, from_col type i, from_row type i, to_col type i, to_row type i, end of ys_merged_cell
4	YS_NUMBERFORMAT	Protected	See coding			20131008	begin of ys_numberformat, content_type type if_wd_dg_exexp_adapter=>ty_content_type, currency_unit type string, format type string, id type i, end of ys_numberformat
5	YS_ROOT_DOC_PROPS	Protected	See coding			20131008	begin of ys_root_doc_props, app type yt_string_tab, core type yt_string_tab, end of ys_root_doc_props
6	YS_ROOT_XL	Protected	See coding			20131008	begin of ys_root_xl, printersettings type ys_root_xl_printersettings, theme type ys_root_xl_theme, worksheets type ys_root_xl_worksheets, sharedstring type yt_string_tab, styles type yt_string_tab, workbook type yt_string_tab, end of ys_root_xl
7	YS_ROOT_XL_PRINTERSETTINGS	Protected	See coding			20131008	begin of ys_root_xl_printersettings, printersettings type yt_string_tab, end of ys_root_xl_printersettings
8	YS_ROOT_XL_THEME	Protected	See coding			20131008	begin of ys_root_xl_theme, theme type yt_string_tab, end of ys_root_xl_theme
9	YS_ROOT_XL_WORKSHEETS	Protected	See coding			20131008	begin of ys_root_xl_worksheets, sheet1 type yt_string_tab, sheet2 type yt_string_tab, sheet3 type yt_string_tab, drawing type yt_string_tab, end of ys_root_xl_worksheets
10	YS_SHAREDSTRING	Protected	See coding			20131008	begin of ys_sharedstring, value type string, pos type i, end of ys_sharedstring
11	YS_SHAREDSTRING_STRUC	Protected	See coding			20131008	begin of ys_sharedstring_struc, * t_strings type standard table of ys_sharedstring with key value initial size 1, t_strings type yt_string_tab, string_count type i, string_ucount type i, end of ys_sharedstring_struc
12	YS_STYLE	Protected	See coding			20131008	begin of ys_style, is_header type abap_bool, is_total type abap_bool, level type i, type type if_wd_dg_exexp_adapter=>ty_content_type, id type i, content type string, end of ys_style
13	YTH_NUMBERFORMAT	Protected	See coding			20131008	yth_numberformat type hashed table of ys_numberformat with unique key content_type currency_unit initial size 1
14	YTH_SHAREDSTRING	Protected	See coding			20131008	yth_sharedstring type hashed table of ys_sharedstring with unique key value initial size 1
15	YTH_STYLE	Protected	See coding			20131008	yth_style type hashed table of ys_style with unique key is_header is_total level type initial size 1
16	YT_HYPERLINK	Protected	See coding			20131008	yt_hyperlink type standard table of ys_hyperlink
17	YT_MERGED_CELL	Protected	See coding			20131028	yt_merged_cell type standard table of ys_merged_cell with non-unique default key
18	YT_STRING_TAB	Protected	See coding			20131008	yt_string_tab type standard table of string with non-unique default key

Method Signatures

Method ADD_SHARED_STRING Signature

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

Method ADD_SHARED_STRING on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method ADD_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_LINEBREAK	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20131009
2	Importing	IV_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20131009

Method ADD_STRING on class CL_WDR_DG_EXEXP_FORMAT_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_CONTENT_TYPE	Call by reference	☐	Type reference (TYPE)	IF_WD_DG_EXEXP_ADAPTER=>TY_CONTENT_TYPE	IF_WD_DG_EXEXP_ADAPTER=>CS_CONTENT_TYPE-STRING		20140423
2	Importing	IV_CURRENCY_UNIT	Call by reference	☑	Type reference (TYPE)	STRING			20140425
3	Importing	IV_IS_HEADER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20131021
4	Importing	IV_IS_TOTAL	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20131021
5	Importing	IV_LEVEL	Call by reference	☐	Type reference (TYPE)	I			20131021
6	Returning	RV_INDEX	Value transfer	☐	Type reference (TYPE)	I			20131021

Method ADD_STYLE on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method FILL_ROOT_DOC_PROPS Signature

Method FILL_ROOT_DOC_PROPS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method FILL_ROOT_DOC_PROPS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method FILL_ROOT_XL Signature

Method FILL_ROOT_XL on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method FILL_ROOT_XL on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method FILL_ROOT_XL_SHAREDSTRINGS Signature

Method FILL_ROOT_XL_SHAREDSTRINGS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method FILL_ROOT_XL_SHAREDSTRINGS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method FILL_ROOT_XL_WORKSHEETS Signature

Method FILL_ROOT_XL_WORKSHEETS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method FILL_ROOT_XL_WORKSHEETS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method FINALIZE_ROOT_XL_STYLES Signature

Method FINALIZE_ROOT_XL_STYLES on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method FINALIZE_ROOT_XL_STYLES on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method FINALIZE_ROOT_XL_WRKSTS_SHEET1 Signature

Method FINALIZE_ROOT_XL_WRKSTS_SHEET1 on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method FINALIZE_ROOT_XL_WRKSTS_SHEET1 on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method GET_COLPOS_ALPHA 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			20131008
2	Returning	RV_COLPOS_ALPHA	Value transfer	☐	Type reference (TYPE)	STRING			20131008

Method GET_COLPOS_ALPHA on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method GET_CONTENT_FROM_STRINGTAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_STRING_TAB	Call by reference	☐	Type reference (TYPE)	YT_STRING_TAB			20131024
2	Returning	RV_CONTENT	Value transfer	☐	Type reference (TYPE)	XSTRING			20131024

Method GET_CONTENT_FROM_STRINGTAB on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method GET_NUMBER_FORMAT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CONTENT_TYPE	Call by reference	☐	Type reference (TYPE)	IF_WD_DG_EXEXP_ADAPTER=>TY_CONTENT_TYPE			20140425
2	Importing	IV_CURRENCY_UNIT	Call by reference	☐	Type reference (TYPE)	STRING			20140425
3	Returning	RV_FORMAT_ID	Value transfer	☐	Type reference (TYPE)	I			20140425

Method GET_NUMBER_FORMAT on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method PREPARE_DRAWINGS Signature

Method PREPARE_DRAWINGS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method PREPARE_DRAWINGS on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method PREPARE_ROOT_XL_STYLES Signature

Method PREPARE_ROOT_XL_STYLES on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method PREPARE_ROOT_XL_STYLES on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

Method PREPARE_ROOT_XL_WRKSTS_SHEET1 Signature

Method PREPARE_ROOT_XL_WRKSTS_SHEET1 on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no parameter.
Method PREPARE_ROOT_XL_WRKSTS_SHEET1 on class CL_WDR_DG_EXEXP_FORMAT_XLSX has no exception.

History

Last changed by/on	SAP	20141120
SAP Release Created in	740