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