SAP ABAP Class CL_SALV_BS_LEX_FORMAT_XLSX (ALV Lean Export - Format Excel 2007 (XLSX))

Hierarchy

☛ SAP_UI (Software Component) User Interface Technology
   ⤷ BC-WD-CMP-ALV-ABA (Application Component) Web Dynpro ALV for ABAP
     ⤷ SALV_BS_LEX (Package) Contains general Classes/Interfaces of ALV Lean Export

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_SALV_BS_LEX_FORMAT	ALV Lean Export - Format Interface	20101004

Properties

Class	CL_SALV_BS_LEX_FORMAT_XLSX
Short Description	ALV Lean Export - Format Excel 2007 (XLSX)
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	SALV_BS_LEX	Contains general Classes/Interfaces of ALV Lean Export
Created	20101004	SAP
Last change	20141120
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)
2	CL_SALV_BS_LEX_SUPPORT	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
3	IF_SALV_BS_LEX_FORMAT	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_SALV_BS_LEX_FORMAT	☐	☐	ALV Lean Export - Format Interface	20101004

Friends

Class CL_SALV_BS_LEX_FORMAT_XLSX has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_HYPERLINK_STYLE_START_OFFSET	Constant	Private	☐	Type reference (TYPE)	I	43		20140825
2	C_XLSX_FILE_EXTENSION	Constant	Public	☐	Type reference (TYPE)	STRING	`xlsx`		20140813
3	C_XLSX_HYPERLINK_RELATION_TYPE	Constant	Private	☐	Type reference (TYPE)	STRING	`http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink`		20140813
4	C_XLSX_MIME_TYPE	Constant	Public	☐	Type reference (TYPE)	STRING	`application/vnd.openxmlformats-officedocument.spreadsheetml.sheet`		20140813
5	MO_SUPPORT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SALV_BS_LEX_SUPPORT			20140813
6	MS_RESULT_FILE	Instance attribute	Private	☐	Type reference (TYPE)	YS_FILE			20140813
7	MS_SHAREDSTRINGS_STRUC	Instance attribute	Private	☐	Type reference (TYPE)	YS_SHAREDSTRING_STRUC			20101004
8	MT_COLUMN_WIDTHS	Instance attribute	Private	☐	Type reference (TYPE)	YTS_COLUMN_WIDTH			20140815
9	MT_HYPERLINKS	Instance attribute	Private	☐	Type reference (TYPE)	YT_HYPERLINK			20101006
10	MT_HYPERLINK_MAP	Instance attribute	Private	☐	Type reference (TYPE)	YTH_HYPERLINK_MAP			20140813
11	MT_SHAREDSTRINGS	Instance attribute	Private	☐	Type reference (TYPE)	YTH_SHAREDSTRING			20101004
12	MT_STYLES	Instance attribute	Private	☐	Type reference (TYPE)	YTH_STYLE			20101004
13	MV_DRAWINGS_RELATION_ID	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20140813
14	MV_IMAGES_EXIST	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20140813
15	MV_SHEETDATA_START_INDEX	Instance attribute	Private	☐	Type reference (TYPE)	I			20140815
16	MV_SUMMARY_ROWS_BELOW_DETAILS	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20140813
17	ST_IMAGE_TYPES	Static Attribute	Private	☐	Type reference (TYPE)	YTH_IMAGE_TYPE			20140813

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_HYPERLINK	Instance method	Private	Method		20101006
2	ADD_HYPERLINKPARTS	Instance method	Private	Method		20140813
3	ADD_IMAGE	Instance method	Private	Method		20140819
4	ADD_IMAGEPARTS	Instance method	Private	Method		20140813
5	ADD_SHAREDSTRING	Instance method	Private	Method		20101004
6	BUILD_APPLICATION_PROPERTIES	Instance method	Private	Method		20140819
7	BUILD_COLUMN_DEFINITION_BLOCK	Instance method	Private	Method		20140815
8	BUILD_CORE_PROPERTIES	Instance method	Private	Method		20140819
9	BUILD_DRAWINGS	Instance method	Private	Method		20140820
10	BUILD_SHAREDSTRINGS	Instance method	Private	Method		20140819
11	BUILD_STYLES	Instance method	Private	Method		20140819
12	BUILD_WORKSHEET	Instance method	Private	Method		20140819
13	CLASS_CONSTRUCTOR	Static method	Public	Constructor		20140813
14	CLOSE_ROW_TAG	Instance method	Private	Method		20140813
15	CREATE_CELL_STYLE	Instance method	Private	Method		20140813
16	CREATE_RESULT_DOCUMENT	Instance method	Protected	Method		20140813
17	DETERMINE_SUITABLE_CELL_STYLE	Instance method	Private	Method		20140813
18	GET_CELL_STYLE_ID	Instance method	Private	Method		20140825
19	MUST_RELEASE_RESULT_FILE	Instance method	Protected	Method		20140819
20	OPEN_ROW_TAG	Instance method	Private	Method		20140813
21	POPULATE_IMAGE_TYPES	Static method	Private	Method		20140813
22	UPDATE_MAXIMUM_COLUMN_WIDTH	Instance method	Private	Method		20140815

Events

Class CL_SALV_BS_LEX_FORMAT_XLSX has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	YS_COLUMN_WIDTH	Private	See coding			20140815	begin of ys_column_width, column_position type i, max_number_of_characters type i, end of ys_column_width
2	YS_DOCUMENT_PROPERTIES	Private	See coding			20140819	begin of ys_document_properties, app type string, core type string, end of ys_document_properties
3	YS_FILE	Private	See coding			20101004	begin of ys_file, document_properties type ys_document_properties, workbook type ys_workbook, end of ys_file
4	YS_HYPERLINK	Private	See coding			20101006	begin of ys_hyperlink, relation_id type string, cell type string, url type string, end of ys_hyperlink
5	YS_HYPERLINK_MAP	Private	See coding			20140813	begin of ys_hyperlink_map, url type string, relation_id type string, end of ys_hyperlink_map
6	YS_IMAGE_TYPE	Private	See coding			20140813	begin of ys_image_type, image_type type string, content_type type oxa_opc_content_type, end of ys_image_type
7	YS_SHAREDSTRING	Private	See coding			20101004	begin of ys_sharedstring, value type string, pos type i, end of ys_sharedstring
8	YS_SHAREDSTRING_STRUC	Private	See coding			20101004	begin of ys_sharedstring_struc, entries_data type string, count type i, unique_count type i, end of ys_sharedstring_struc
9	YS_STYLE	Private	See coding			20101004	begin of ys_style, column_id type string, cell_editor_type type if_salv_bs_lex_format=>ys_cell_editor_type, row_type type if_salv_bs_lex_format=>ys_row_type, style_id type string, style_id_hyperlink type string, end of ys_style
10	YS_WORKBOOK	Private	See coding			20140819	begin of ys_workbook, worksheet type ys_worksheet, sharedstrings type string, styles type string, end of ys_workbook
11	YS_WORKSHEET	Private	See coding			20140819	begin of ys_worksheet, row_data type string, worksheet_data type string, drawing type string, drawing_data type string, end of ys_worksheet
12	YTH_HYPERLINK_MAP	Private	See coding			20140813	yth_hyperlink_map type hashed table of ys_hyperlink_map with unique key url
13	YTH_IMAGE_TYPE	Private	See coding			20140813	yth_image_type type hashed table of ys_image_type with unique key image_type
14	YTH_SHAREDSTRING	Private	See coding			20101004	yth_sharedstring type hashed table of ys_sharedstring with unique key value initial size 1
15	YTH_STYLE	Private	See coding			20101004	yth_style type hashed table of ys_style with unique key column_id cell_editor_type row_type initial size 1
16	YTS_COLUMN_WIDTH	Private	See coding			20140815	yts_column_width type sorted table of ys_column_width with unique key column_position
17	YT_HYPERLINK	Private	See coding			20101006	yt_hyperlink type standard table of ys_hyperlink
18	YT_STRING_TAB	Private	See coding			20101004	yt_string_tab type standard table of string with default key

Method Signatures

Method ADD_HYPERLINK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELL_POSITION	Call by reference	☐	Type reference (TYPE)	STRING			20140825
2	Importing	IV_URL	Call by reference	☐	Type reference (TYPE)	STRING			20140813

Method ADD_HYPERLINK on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method ADD_HYPERLINKPARTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_WS_PART	Call by reference	☐	Object reference (TYPE REF TO)	CL_XLSX_WORKSHEETPART			20140813

Method ADD_HYPERLINKPARTS on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method ADD_IMAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_IMAGE_DATA	Call by reference	☐	Type reference (TYPE)	CL_SALV_BS_LEX_SUPPORT=>YS_IMAGE_DATA			20140819
2	Importing	IV_COLUMN_INDEX	Call by reference	☐	Type reference (TYPE)	I			20140825
3	Importing	IV_ROW_INDEX	Call by reference	☐	Type reference (TYPE)	I			20140825

Method ADD_IMAGE on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method ADD_IMAGEPARTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_DRAWINGSPART	Call by reference	☐	Object reference (TYPE REF TO)	CL_OXML_DRAWINGSPART			20140813

Method ADD_IMAGEPARTS on class CL_SALV_BS_LEX_FORMAT_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			20140813
2	Returning	RV_INDEX	Value transfer	☐	Type reference (TYPE)	I			20140813

Method ADD_SHAREDSTRING on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method BUILD_APPLICATION_PROPERTIES Signature

Method BUILD_APPLICATION_PROPERTIES on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method BUILD_APPLICATION_PROPERTIES on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method BUILD_COLUMN_DEFINITION_BLOCK Signature

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

Method BUILD_COLUMN_DEFINITION_BLOCK on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method BUILD_CORE_PROPERTIES Signature

Method BUILD_CORE_PROPERTIES on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method BUILD_CORE_PROPERTIES on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method BUILD_DRAWINGS Signature

Method BUILD_DRAWINGS on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method BUILD_DRAWINGS on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method BUILD_SHAREDSTRINGS Signature

Method BUILD_SHAREDSTRINGS on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method BUILD_SHAREDSTRINGS on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method BUILD_STYLES Signature

Method BUILD_STYLES on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method BUILD_STYLES on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method BUILD_WORKSHEET Signature

Method BUILD_WORKSHEET on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method BUILD_WORKSHEET on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method CLASS_CONSTRUCTOR Signature

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

Method CLOSE_ROW_TAG Signature

Method CLOSE_ROW_TAG on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method CLOSE_ROW_TAG on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method CREATE_CELL_STYLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELL_EDITOR_TYPE	Call by reference	☐	Type reference (TYPE)	IF_SALV_BS_LEX_FORMAT=>YS_CELL_EDITOR_TYPE			20140813
2	Importing	IV_COLUMN_ID	Call by reference	☐	Type reference (TYPE)	STRING			20140813
3	Importing	IV_DECIMALS	Call by reference	☐	Type reference (TYPE)	I	0		20140813
4	Importing	IV_IS_SCIENTIFIC_FORMAT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20140813
5	Importing	IV_ROW_TYPE	Call by reference	☐	Type reference (TYPE)	IF_SALV_BS_LEX_FORMAT=>YS_ROW_TYPE			20140813
6	Returning	RS_STYLE	Value transfer	☐	Type reference (TYPE)	YS_STYLE			20140813

Method CREATE_CELL_STYLE on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method CREATE_RESULT_DOCUMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_RESULT_DOCUMENT_CONTENT	Call by reference	☐	Object reference (TYPE REF TO)	XSTRING			20140825
2	Importing	IV_HAS_IMAGES	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20140813

#	Exception	Resumable	Description	Created on
1	CX_OPENXML_FORMAT	☐		20140813
2	CX_OPENXML_NOT_ALLOWED	☐		20140813
3	CX_OPENXML_NOT_FOUND	☐		20140813

Method DETERMINE_SUITABLE_CELL_STYLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELL_EDITOR_TYPE	Call by reference	☐	Type reference (TYPE)	IF_SALV_BS_LEX_FORMAT=>YS_CELL_EDITOR_TYPE			20140813
2	Importing	IV_COLUMN_ID	Call by reference	☐	Type reference (TYPE)	STRING			20140813
3	Importing	IV_DECIMALS	Call by reference	☐	Type reference (TYPE)	I	0		20140813
4	Importing	IV_HAS_HYPERLINK	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20140813
5	Importing	IV_IS_SCIENTIFIC_FORMAT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20140813
6	Importing	IV_ROW_TYPE	Call by reference	☐	Type reference (TYPE)	IF_SALV_BS_LEX_FORMAT=>YS_ROW_TYPE			20140813
7	Returning	RV_STYLE_ID	Value transfer	☐	Type reference (TYPE)	STRING			20140813

Method DETERMINE_SUITABLE_CELL_STYLE on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method GET_CELL_STYLE_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CELL_EDITOR_TYPE	Call by reference	☐	Type reference (TYPE)	IF_SALV_BS_LEX_FORMAT=>YS_CELL_EDITOR_TYPE			20140825
2	Importing	IV_DECIMALS	Call by reference	☐	Type reference (TYPE)	I			20140825
3	Importing	IV_HAS_HYPERLINK	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20140825
4	Importing	IV_IS_SCIENTIFIC_FORMAT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20140825
5	Importing	IV_ROW_TYPE	Call by reference	☐	Type reference (TYPE)	IF_SALV_BS_LEX_FORMAT=>YS_ROW_TYPE			20140825
6	Returning	RV_STYLE_ID	Value transfer	☐	Type reference (TYPE)	STRING			20140825

Method GET_CELL_STYLE_ID on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method MUST_RELEASE_RESULT_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20140819

Method MUST_RELEASE_RESULT_FILE on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method OPEN_ROW_TAG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ROW_INDEX	Call by reference	☐	Type reference (TYPE)	I			20140813

Method OPEN_ROW_TAG on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method POPULATE_IMAGE_TYPES Signature

Method POPULATE_IMAGE_TYPES on class CL_SALV_BS_LEX_FORMAT_XLSX has no parameter.
Method POPULATE_IMAGE_TYPES on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

Method UPDATE_MAXIMUM_COLUMN_WIDTH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLUMN_POS	Call by reference	☐	Type reference (TYPE)	I			20140815
2	Importing	IV_MAX_NUMBER_OF_CHARACTERS	Call by reference	☐	Type reference (TYPE)	I			20140815

Method UPDATE_MAXIMUM_COLUMN_WIDTH on class CL_SALV_BS_LEX_FORMAT_XLSX has no exception.

History

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