SAP ABAP Class CL_SALV_BS_OFFICE2007_BASE (Excel Export 2007)
Hierarchy
SAP_UI (Software Component) User Interface Technology
   BC-WD-CMP-ALV-ABA (Application Component) Web Dynpro ALV for ABAP
     SALV_BS_EXPORT (Package) SALV BS Export
Meta Relationship - Used By
# Relationship type Used by Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_SALV_BS_EX_OFFICE2007 Office 2007 Export for WD 20090113
2 Inheritance (c INHERITING FROM c_ref)  CL_SALV_BS_WD_OFFICE2007 Office 2007 Export for WD 20090113
Properties
Class CL_SALV_BS_OFFICE2007_BASE  
Short Description Excel Export 2007    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package SALV_BS_EXPORT   SALV BS Export 
Created 20081218   SAP 
Last change 20131127   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 IF_SALV_BS_MODEL_COLUMNS Forward declaration interface (INTERFACE i DEFINITION DEF...  Forward declaration interface (INTERFACE i DEFINITION DEF...
2 IF_SALV_BS_R_DATA_TABLE_TYPES Forward declaration interface (INTERFACE i DEFINITION DEF...  Forward declaration interface (INTERFACE i DEFINITION DEF...
3 IF_SALV_BS_T_DATA Forward declaration interface (INTERFACE i DEFINITION DEF...  Forward declaration interface (INTERFACE i DEFINITION DEF...
Interfaces
Class CL_SALV_BS_OFFICE2007_BASE has no interface implemented.
Friends
Class CL_SALV_BS_OFFICE2007_BASE has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 C_1000_SEPARATOR Constant Private Type reference (TYPE) STRING '#,##' 20140627
2 C_ABC Constant Private Type reference (TYPE) CHAR26 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' 20090113
3 C_DECIMALS_FORMAT Constant Private Type reference (TYPE) CHAR26 '0.000000000' 20090113
4 C_ROWSTYLE_NORMAL Constant Private Type reference (TYPE) C 'N' 20090113
5 C_ROWSTYLE_SUBTOTAL Constant Private Type reference (TYPE) C 'S' 20090113
6 C_ROWSTYLE_TITLE Constant Private Type reference (TYPE) C 'H' 20090113
7 C_ROWSTYLE_TOTAL Constant Private Type reference (TYPE) C 'T' 20090113
8 C_TYPE_DATE Constant Private Type reference (TYPE) C 'D' 20090113
9 C_TYPE_NUMERIC Constant Private Type reference (TYPE) C 'N' 20090113
10 C_TYPE_STRING Constant Private Type reference (TYPE) C 'C' 20090113
11 C_TYPE_TIME Constant Private Type reference (TYPE) C 'T' 20090113
12 C_TYPE_TIMESTAMP Constant Private Type reference (TYPE) C 'Z' 20110301
13 DRAWINGPART Instance attribute Private Object reference (TYPE REF TO) CL_OXML_DRAWINGSPART cl_oxml_drawingspart 20090113
14 EXCEL_XML Instance attribute Private Type reference (TYPE) XSTRING 20090113
15 GUI_TYPE Instance attribute Protected Attribute reference (LIKE) IF_SALV_BS_C_TT=>C_TT Constant 20100518
16 HYPERLINK_MAP Instance attribute Private See coding 20090113
17 IMAGE_MAP Instance attribute Private See coding 20090113
18 IMAGE_STRUCT Instance attribute Private Type reference (TYPE) YS_IMAGE_STRUC 20090113
19 LAST_INSERT_POSITION Instance attribute Private Type reference (TYPE) SYTABIX Index of Internal Tables 20090525
20 R_RESULT_TABLE Instance attribute Private Object reference (TYPE REF TO) CL_SALV_BS_RESULT_DATA_TABLE CL_SALV_BS_RESULT_DATA_TABLE 20090113
21 SHAREDSTRING_STRUCT Instance attribute Private Type reference (TYPE) YS_SHAREDSTRING_STRUC 20090113
22 SHEET_STRUCT Instance attribute Private Type reference (TYPE) YS_SHEET_STRUC 20090113
23 STYLE_STRUCT Instance attribute Private Type reference (TYPE) YS_STYLE_STRUC 20090113
24 T_STRINGS Instance attribute Private Type reference (TYPE) YTH_SHAREDSTRING 20120615
25 XLSX_DOCUMENT Instance attribute Private Object reference (TYPE REF TO) CL_XLSX_DOCUMENT 20090113
Methods
# Method Level Visibility Method type Description Created on
1 ADD_DRAWINGPART Instance method Private Method 20090113
2 ADD_HYPERLINK Instance method Private Method 20090113
3 ADD_IMAGE Instance method Private Method 20090113
4 ADD_SHAREDSTRING Instance method Private Method 20090113
5 ADD_STYLE Instance method Private Method 20090113
6 CONSTRUCTOR Instance method Public Constructor Constructor 20090113
7 CREATE_CELL Instance method Private Method 20090113
8 CREATE_CELLS Instance method Private Method 20090113
9 CREATE_DATA_CELL Instance method Private Method 20090113
10 CREATE_HEADER_ROW Instance method Private Method 20090113
11 CREATE_HIER_CELL Instance method Private Method 20090113
12 CREATE_TOTAL_CELL Instance method Private Method 20090113
13 GENERATE_XML_AND_OPC Instance method Private Method 20090113
14 GET_CELLPOSITION Instance method Private Method 20090113
15 GET_CELL_VALUE Instance method Private Method 20090113
16 GET_IMAGE_CONTENT Instance method Protected Method 20090113
17 TRANSFORM Instance method Public Method 20090113
18 TRANSFORM_TO_OFF2007 Instance method Private Method 20090113
Events
Class CL_SALV_BS_OFFICE2007_BASE has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 YS_CELL_STRUC Private See coding 20090113 begin of ys_cell_struc, position type string, value type string, index type i, style type i, sharedstring type string, end of ys_cell_struc
2 YS_COLUMNINFO Private See coding 20090113 begin of ys_columninfo, columnid type string, field type string, width type i, properties type if_salv_bs_model_column=>s_type_uie_properties, attribute type if_salv_bs_t_data=>s_type_attribute, end of ys_columninfo
3 YS_COL_STRUC Private See coding 20090113 begin of ys_col_struc, min type i, max type i, bestFit type i, width type i, end of ys_col_struc
4 YS_HYPERLINK_MAP Private See coding 20090113 begin of ys_hyperlink_map, link type string, rel_id type string, end of ys_hyperlink_map
5 YS_HYPERLINK_STRUC Private See coding 20090113 begin of ys_hyperlink_struc, rel_id type string, cell_id type string, end of ys_hyperlink_struc
6 YS_IMAGE Private See coding 20090113 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 20090113 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 20090113 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_ROW_STRUC Private See coding 20090113 begin of ys_row_struc, spans type string, position type i, outlinelevel type i, hidden type char1, height type i, t_cells type standard table of ys_cell_struc with non-unique key position initial size 1, end of ys_row_struc
10 YS_SHAREDSTRING Private See coding 20090113 begin of ys_sharedstring, value type string, pos type i, end of ys_sharedstring
11 YS_SHAREDSTRING_STRUC Private See coding 20090113 begin of ys_sharedstring_struc, * t_strings type standard table of ys_sharedstring with key value initial size 1, t_strings type yth_sharedstring, string_count type i, string_ucount type i, end of ys_sharedstring_struc
12 YS_SHEET_STRUC Private See coding 20090113 begin of ys_sheet_struc, dim type string, outlinelevel type i, summary_below type string, s_header_row type ys_row_struc, 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, drawing_id type string, end of ys_sheet_struc
13 YS_STYLE_CELLXF Private See coding 20090113 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
14 YS_STYLE_NUMFMT Private See coding 20090113 begin of ys_style_numfmt, id type i, code type string, end of ys_style_numfmt
15 YS_STYLE_STRUC Private See coding 20090113 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
16 YTH_SHAREDSTRING Private See coding 20090525 yth_sharedstring type hashed table of ys_sharedstring with unique key value initial size 1
17 YT_COLUMNINFO Private See coding 20090113 yt_columninfo type hashed table of ys_columninfo with unique key columnid initial size 1
Method Signatures

Method ADD_DRAWINGPART Signature

Method ADD_DRAWINGPART on class CL_SALV_BS_OFFICE2007_BASE has no parameter.
Method ADD_DRAWINGPART on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method ADD_HYPERLINK Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_CELL_ID Call by reference Type reference (TYPE) STRING 20090113
2 Importing I_LINK Call by reference Type reference (TYPE) STRING 20090113

Method ADD_HYPERLINK on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method ADD_IMAGE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COL Call by reference Type reference (TYPE) I 20090113
2 Changing HEIGHT Call by reference Type reference (TYPE) I 20090113
3 Importing ID Call by reference Type reference (TYPE) STRING 20090113
4 Importing ROW Call by reference Type reference (TYPE) I 20090113
5 Changing WIDTH Call by reference Type reference (TYPE) I 20090113

Method ADD_IMAGE on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method ADD_SHAREDSTRING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_INDEX Call by reference Type reference (TYPE) I 20090113
2 Importing I_SHAREDSTRING Call by reference Type reference (TYPE) STRING 20090113

Method ADD_SHAREDSTRING on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method ADD_STYLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_INDEX Call by reference Type reference (TYPE) I 20090113
2 Importing I_DECIMALS Call by reference Type reference (TYPE) I 0 20090113
3 Importing I_HYPERLINK Call by reference Type reference (TYPE) I 0 20090113
4 Importing I_INDENT Call by reference Type reference (TYPE) I 0 20090113
5 Importing I_ROWSTYLE Call by reference Type reference (TYPE) C 'N' 20090113
6 Importing I_TYPE Call by reference Type reference (TYPE) C 20090113
7 Importing I_WRAP Call by reference Type reference (TYPE) I 0 20090113

Method ADD_STYLE on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing R_RESULT_DATA Call by reference Object reference (TYPE REF TO) CL_SALV_BS_RESULT_DATA_TABLE CL_SALV_BS_RESULT_DATA_TABLE 20090113

Method CONSTRUCTOR on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method CREATE_CELL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CELL_ID Call by reference Type reference (TYPE) STRING 20090113
2 Importing COLUMNID Call by reference Type reference (TYPE) STRING 20090113
3 Importing COLUMNINFO Call by reference Type reference (TYPE) YS_COLUMNINFO 20090113
4 Exporting DECIMALS Call by reference Type reference (TYPE) I 20090113
5 Exporting IMAGE_ID Call by reference Type reference (TYPE) STRING 20090113
6 Exporting INDENT Call by reference Type reference (TYPE) I 20090113
7 Exporting INTTYPE Call by reference Type reference (TYPE) C 20090113
8 Importing R_MODEL Call by reference Object reference (TYPE REF TO) CL_SALV_BS_MODEL_TABLE CL_SALV_BS_MODEL_TABLE 20090113
9 Importing S_DATA Call by reference Type reference (TYPE) ANY 20090113
10 Importing S_RESULT Call by reference Type reference (TYPE) IF_SALV_BS_R_DATA_TABLE_TYPES=>S_TYPE_RESULT_DATA 20090113
11 Importing T_HIER_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20120628
12 Importing T_VISIBLE_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20090113
13 Exporting VALUE Call by reference Type reference (TYPE) STRING 20090113

Method CREATE_CELL on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method CREATE_CELLS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DATA_INDEX Call by reference Type reference (TYPE) I 20090113
2 Importing ROWSTYLE Call by reference Type reference (TYPE) C 20090113
3 Importing ROW_INDEX Call by reference Type reference (TYPE) I 20090113
4 Importing R_MODEL Call by reference Object reference (TYPE REF TO) CL_SALV_BS_MODEL_TABLE CL_SALV_BS_MODEL_TABLE 20090113
5 Importing S_RESULT Call by reference Type reference (TYPE) IF_SALV_BS_R_DATA_TABLE_TYPES=>S_TYPE_RESULT_DATA 20090113
6 Changing S_ROW Call by reference Type reference (TYPE) YS_ROW_STRUC 20090113
7 Changing T_COLUMNINFO Call by reference Type reference (TYPE) YT_COLUMNINFO 20090113
8 Importing T_HIER_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20120628
9 Importing T_VISIBLE_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20090113

Method CREATE_CELLS on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method CREATE_DATA_CELL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CELL_ID Call by reference Type reference (TYPE) STRING 20090113
2 Importing COLUMNID Call by reference Type reference (TYPE) STRING 20090113
3 Importing COLUMNINFO Call by reference Type reference (TYPE) YS_COLUMNINFO 20090113
4 Exporting DECIMALS Call by reference Type reference (TYPE) I 20090113
5 Exporting IMAGE_ID Call by reference Type reference (TYPE) STRING 20090113
6 Exporting INTTYPE Call by reference Type reference (TYPE) C 20090113
7 Importing R_MODEL Call by reference Object reference (TYPE REF TO) CL_SALV_BS_MODEL_TABLE CL_SALV_BS_MODEL_TABLE 20090113
8 Importing S_DATA Call by reference Type reference (TYPE) ANY 20090113
9 Importing S_RESULT Call by reference Type reference (TYPE) IF_SALV_BS_R_DATA_TABLE_TYPES=>S_TYPE_RESULT_DATA 20090113
10 Exporting VALUE Call by reference Type reference (TYPE) STRING 20090113

Method CREATE_DATA_CELL on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method CREATE_HEADER_ROW Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing R_MODEL Call by reference Object reference (TYPE REF TO) CL_SALV_BS_MODEL_TABLE CL_SALV_BS_MODEL_TABLE 20090113
2 Importing STYLE_INDEX Call by reference Type reference (TYPE) I 20090113
3 Changing S_ROW Call by reference Type reference (TYPE) YS_ROW_STRUC 20090113
4 Changing T_COLUMNINFO Call by reference Type reference (TYPE) YT_COLUMNINFO 20090113
5 Importing T_HIER_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20120628
6 Importing T_VISIBLE_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20090113

Method CREATE_HEADER_ROW on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method CREATE_HIER_CELL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COLUMNID Call by reference Type reference (TYPE) STRING 20090113
2 Importing COLUMNINFO Call by reference Type reference (TYPE) YS_COLUMNINFO 20090113
3 Exporting DECIMALS Call by reference Type reference (TYPE) I 20090113
4 Exporting IMAGE_ID Call by reference Type reference (TYPE) STRING 20090113
5 Exporting INTTYPE Call by reference Type reference (TYPE) C 20090113
6 Importing R_MODEL Call by reference Object reference (TYPE REF TO) CL_SALV_BS_MODEL_TABLE CL_SALV_BS_MODEL_TABLE 20090113
7 Importing S_RESULT Call by reference Type reference (TYPE) IF_SALV_BS_R_DATA_TABLE_TYPES=>S_TYPE_RESULT_DATA 20090113
8 Exporting VALUE Call by reference Type reference (TYPE) STRING 20090113

Method CREATE_HIER_CELL on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method CREATE_TOTAL_CELL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COLUMNID Call by reference Type reference (TYPE) STRING 20090113
2 Importing COLUMNINFO Call by reference Type reference (TYPE) YS_COLUMNINFO 20090113
3 Exporting DECIMALS Call by reference Type reference (TYPE) I 20090113
4 Exporting IMAGE_ID Call by reference Type reference (TYPE) STRING 20090113
5 Exporting INTTYPE Call by reference Type reference (TYPE) C 20090113
6 Importing R_MODEL Call by reference Object reference (TYPE REF TO) CL_SALV_BS_MODEL_TABLE CL_SALV_BS_MODEL_TABLE 20090113
7 Importing S_DATA Call by reference Type reference (TYPE) ANY 20090113
8 Importing S_RESULT Call by reference Type reference (TYPE) IF_SALV_BS_R_DATA_TABLE_TYPES=>S_TYPE_RESULT_DATA 20090113
9 Importing T_HIER_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20120628
10 Importing T_VISIBLE_COLUMNS Call by reference Type reference (TYPE) IF_SALV_BS_MODEL_COLUMNS=>T_TYPE_COLUMN 20090113
11 Exporting VALUE Call by reference Type reference (TYPE) STRING 20090113

Method CREATE_TOTAL_CELL on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method GENERATE_XML_AND_OPC Signature

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

Method GET_CELLPOSITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COL Call by reference Type reference (TYPE) I 20090113
2 Returning RESULT Value transfer Type reference (TYPE) STRING 20090113
3 Importing ROW Call by reference Type reference (TYPE) I 20090113

Method GET_CELLPOSITION on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method GET_CELL_VALUE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting DECIMALS Call by reference Type reference (TYPE) DATA 20090113
2 Importing FIELDNAME Call by reference Type reference (TYPE) STRING 20090113
3 Exporting IMAGE_ID Call by reference Type reference (TYPE) STRING 20090113
4 Importing IMAGE_TYPE Call by reference Type reference (TYPE) STRING 20090113
5 Importing I_DECIMALS Call by reference Type reference (TYPE) STRING 20100209
6 Importing I_EXPONENT Call by reference Type reference (TYPE) STRING 20140318
7 Importing I_IMAGE Call by reference Type reference (TYPE) STRING 20100518
8 Importing I_REFERENCE Call by reference Type reference (TYPE) STRING 20090113
9 Importing I_ROUND Call by reference Type reference (TYPE) STRING 20100518
10 Importing I_TECH_FORM Call by reference Type reference (TYPE) STRING 20140425
11 Importing R_MODEL Call by reference Object reference (TYPE REF TO) CL_SALV_BS_MODEL_TABLE CL_SALV_BS_MODEL_TABLE 20090113
12 Importing S_DATA Call by reference Type reference (TYPE) ANY 20090113
13 Importing UIE_TYPE Call by reference Type reference (TYPE) STRING 20090113
14 Exporting VALUE Call by reference Type reference (TYPE) DATA 20090113

Method GET_CELL_VALUE on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method GET_IMAGE_CONTENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IMAGE_VALUE Call by reference Type reference (TYPE) DATA 20090113
2 Exporting VALUE Call by reference Type reference (TYPE) XSTRING 20090113

Method GET_IMAGE_CONTENT on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method TRANSFORM Signature

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

Method TRANSFORM on class CL_SALV_BS_OFFICE2007_BASE has no exception.

Method TRANSFORM_TO_OFF2007 Signature

Method TRANSFORM_TO_OFF2007 on class CL_SALV_BS_OFFICE2007_BASE has no parameter.
Method TRANSFORM_TO_OFF2007 on class CL_SALV_BS_OFFICE2007_BASE has no exception.
History
Last changed by/on SAP  20131127 
SAP Release Created in 720