SAP ABAP Class CL_PLM_DYNTABLE_EXPORT_EXCEL (Excel Output)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ CA-EPT-SPI (Application Component) Service Provider Infrastructure
     ⤷ EA-PLM_CO_TABLE_MAPPER (Package) PLM Table Mapper

Properties

Class	CL_PLM_DYNTABLE_EXPORT_EXCEL
Short Description	Excel Output
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	EA-PLM_CO_TABLE_MAPPER	PLM Table Mapper
Created	20101117	SAP
Last change	20110908	SAP
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_PLM_DYNTABLE_EXPORT_EXCEL has no interface implemented.

Friends

Class CL_PLM_DYNTABLE_EXPORT_EXCEL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GC_ENCODING	Constant	Private	☐	Type reference (TYPE)	ABAP_ENCOD	'UTF-8'		20101117
2	GC_FILENAME	Constant	Private	☐	Type reference (TYPE)	CHAR255	'Table.xml'		20101117
3	GC_MIMETYPE	Constant	Private	☐	Type reference (TYPE)	STRING	'application/msexcel'		20101117
4	GC_TAG	Constant	Private	☐	See coding				20101117
5	MT_STYLE_CELLS	Instance attribute	Private	☐	Type reference (TYPE)	TT_STYLE_CELL			20101117
6	MT_XML	Instance attribute	Private	☐	Type reference (TYPE)	STRING_TABLE			20101117
7	MV_INSERT_INDEX	Instance attribute	Private	☐	Type reference (TYPE)	I			20101117
8	MV_ROW_KEY	Instance attribute	Private	☐	Type reference (TYPE)	BOOLE_D			20101117

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CREATE_XML_HEADER	Instance method	Private	Method		20101117
2	END_EXCEL	Instance method	Private	Method		20101117
3	END_TABLE_AND_WORKSHEET	Instance method	Private	Method		20101117
4	EXPORT_COMPARISON_TABLE	Instance method	Public	Method	Export to Excel (with group columns)	20101117
5	EXPORT_SINGLE_TABLE	Instance method	Public	Method	Export to Excel (simple table)	20101117
6	GENERATE_DECIMAL_STYLES	Instance method	Private	Method		20101117
7	GENERATE_STYLES	Instance method	Private	Method		20101117
8	GENERATE_XML_LINE_FOR_CELL	Instance method	Private	Method	Generate XML Line for Cell	20101117
9	GENERATE_XML_LINE_FOR_EPT_CELL	Instance method	Private	Method	Generate XML Line for Empty Cell	20101117
10	REPLACE_XML_CONTROL_CHARACTERS	Instance method	Private	Method		20101117
11	SET_HEADER_INFORMATION	Instance method	Private	Method		20101117
12	SET_MERGED_FIELDS	Instance method	Private	Method		20101117

Events

Class CL_PLM_DYNTABLE_EXPORT_EXCEL has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TS_COLUMNS	Private	See coding			20101117	BEGIN OF ts_columns, engine_col_key TYPE i, header_text TYPE char255, END OF ts_columns
2	TS_ROWS	Private	See coding			20101117	BEGIN OF ts_rows, engine_row_key TYPE i, engine_col_key TYPE i, data TYPE REF TO data, END OF ts_rows
3	TS_STYLE_CELL	Private	See coding			20101117	BEGIN OF ts_style_cell, decimals TYPE i, lv_tag_begin TYPE char255, lv_tag_end TYPE char255, END OF ts_style_cell
4	TS_TABLE_FIELDS	Private	See coding			20101117	BEGIN OF ts_table_fields, fieldname TYPE fieldname, index TYPE i, col TYPE boole_d, END OF ts_table_fields
5	TT_ROWS	Private	See coding			20101117	tt_rows TYPE STANDARD TABLE OF ts_rows
6	TT_STYLE_CELL	Private	See coding			20101117	tt_style_cell TYPE STANDARD TABLE OF ts_style_cell
7	TT_TABLE_FIELDS	Private	See coding			20101117	tt_table_fields TYPE STANDARD TABLE OF ts_table_fields

Method Signatures

Method CREATE_XML_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_XML	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20101117

Method CREATE_XML_HEADER on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method END_EXCEL Signature

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

Method END_EXCEL on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method END_TABLE_AND_WORKSHEET Signature

Method END_TABLE_AND_WORKSHEET on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no parameter.
Method END_TABLE_AND_WORKSHEET on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method EXPORT_COMPARISON_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DATA	Call by reference	☐	Type reference (TYPE)	ANY TABLE			20101117
2	Importing	IT_DEF	Call by reference	☐	Type reference (TYPE)	PLM_T_EXP_TABLE_DEFINITION		Table Definition	20101117
3	Importing	IT_EXPORT_HEADER_DATA	Call by reference	☑	Type reference (TYPE)	PLM_T_EXP_HEADER_INFO		Header Information	20101117
4	Importing	IV_COL_SEQUENCE	Call by reference	☐	Type reference (TYPE)	FIELDNAME		Field containing column sequence	20101118
5	Importing	IV_DISPLAY_EMPTY_TABLE	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_FALSE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117
6	Importing	IV_END_EXCEL	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_TRUE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117
7	Importing	IV_FILENAME	Call by reference	☑	Type reference (TYPE)	STRING			20101117
8	Importing	IV_HEADER_ROW_KEY	Call by reference	☑	Type reference (TYPE)	STRING			20101117
9	Importing	IV_NEW_EXCEL	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_TRUE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117
10	Importing	IV_ROW_KEY_EMPHASIZED	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_FALSE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117
11	Importing	IV_ROW_SEQUENCE	Call by reference	☐	Type reference (TYPE)	FIELDNAME		Field containing row sequence	20101118
12	Importing	IV_TABLE_NUMBER	Call by reference	☑	Type reference (TYPE)	I			20101117
13	Importing	IV_TABLE_PARENT_NUMBER	Call by reference	☑	Type reference (TYPE)	I			20101117

Method EXPORT_COMPARISON_TABLE on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method EXPORT_SINGLE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DATA	Call by reference	☐	Type reference (TYPE)	ANY TABLE			20101117
2	Importing	IT_DEF	Call by reference	☐	Type reference (TYPE)	PLM_T_EXP_TABLE_DEFINITION		Table Definition	20101117
3	Importing	IT_EXPORT_HEADER_DATA	Call by reference	☑	Type reference (TYPE)	PLM_T_EXP_HEADER_INFO		Header Information	20101117
4	Importing	IV_END_EXCEL	Call by reference	☑	Type reference (TYPE)	BOOLE_D		Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117
5	Importing	IV_FILENAME	Call by reference	☑	Type reference (TYPE)	STRING			20101117
6	Importing	IV_NEW_EXCEL	Call by reference	☑	Type reference (TYPE)	BOOLE_D		Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117
7	Importing	IV_TABLE_NUMBER	Call by reference	☑	Type reference (TYPE)	I			20101117
8	Importing	IV_TABLE_PARENT_NUMBER	Call by reference	☑	Type reference (TYPE)	I			20101117

Method EXPORT_SINGLE_TABLE on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method GENERATE_DECIMAL_STYLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_XML	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20101117

Method GENERATE_DECIMAL_STYLES on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method GENERATE_STYLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_XML	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20101117

Method GENERATE_STYLES on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method GENERATE_XML_LINE_FOR_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_XML	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20101117
2	Importing	IV_DATA	Call by reference	☑	Type reference (TYPE)	ANY			20101117
3	Importing	IV_INDEX	Call by reference	☑	Type reference (TYPE)	I			20101117
4	Importing	IV_MERGE_DOWN	Call by reference	☑	Type reference (TYPE)	I			20101117
5	Importing	IV_ROW_KEY	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_FALSE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117

Method GENERATE_XML_LINE_FOR_CELL on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method GENERATE_XML_LINE_FOR_EPT_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_XML	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20101117
2	Importing	IV_INDEX	Call by reference	☑	Type reference (TYPE)	I			20101117
3	Importing	IV_MERGE_DOWN	Call by reference	☑	Type reference (TYPE)	I			20101117
4	Importing	IV_ROW_KEY	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_FALSE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20101117

Method GENERATE_XML_LINE_FOR_EPT_CELL on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method REPLACE_XML_CONTROL_CHARACTERS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CV_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20101117

Method REPLACE_XML_CONTROL_CHARACTERS on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method SET_HEADER_INFORMATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_XML	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20101117
2	Importing	IT_EXPORT_HEADER_DATA	Call by reference	☐	Type reference (TYPE)	PLM_T_EXP_HEADER_INFO		Header Information	20101117

Method SET_HEADER_INFORMATION on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

Method SET_MERGED_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_XML	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20101117
2	Importing	IT_ROWS	Call by reference	☐	Type reference (TYPE)	TT_ROWS			20101117
3	Importing	IT_TABLE_FIELDS	Call by reference	☐	Type reference (TYPE)	TT_TABLE_FIELDS			20101117
4	Importing	IV_COLUMNS	Call by reference	☐	Type reference (TYPE)	I			20101117
5	Importing	IV_COL_SEQUENCE	Call by reference	☐	Type reference (TYPE)	FIELDNAME		Field containing column sequence	20101118
6	Importing	IV_MERGE	Call by reference	☐	Type reference (TYPE)	I			20101117
7	Importing	IV_ROW_COLUMNS	Call by reference	☐	Type reference (TYPE)	I			20101117

Method SET_MERGED_FIELDS on class CL_PLM_DYNTABLE_EXPORT_EXCEL has no exception.

History

Last changed by/on	SAP	20110908
SAP Release Created in	606