SAP ABAP Class CL_SRT_WSP_EXCEL_2007 (Office2007 export)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-ESI-WS-ABA-CFG (Application Component) WebServices ABAP Configuration
     SOAP_CONFIG_CHECK (Package) Check tools for SOAP Configuration Framework
Properties
Class CL_SRT_WSP_EXCEL_2007  
Short Description Office2007 export    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package SOAP_CONFIG_CHECK   Check tools for SOAP Configuration Framework 
Created 20100414   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_SRT_WSP_EXCEL_2007 has no interface implemented.
Friends
Class CL_SRT_WSP_EXCEL_2007 has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 C_ABC Constant Private Type reference (TYPE) CHAR26 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' 20110117
2 C_CELLSTYLE_HEADER Constant Public Type reference (TYPE) C 'H' 20110117
3 C_CELLSTYLE_NORMAL Constant Public Type reference (TYPE) C 'N' 20110117
4 C_CELLSTYLE_SUBTITLE Constant Public Type reference (TYPE) C 'S' 20110117
5 C_CELLSTYLE_TITLE Constant Public Type reference (TYPE) C 'T' 20110117
6 C_DECIMALS_FORMAT Constant Private Type reference (TYPE) CHAR26 '0.000000000' 20110117
7 C_NUMERIC Constant Private Type reference (TYPE) STRING 'PIFbsae' 20110117
8 C_TYPE_DATE Constant Private Type reference (TYPE) C 'D' 20110117
9 C_TYPE_NUMERIC Constant Private Type reference (TYPE) C 'N' 20110117
10 C_TYPE_STRING Constant Private Type reference (TYPE) C 'C' 20110117
11 C_TYPE_TIME Constant Private Type reference (TYPE) C 'T' 20110117
12 C_TYPE_TIMESTAMP Constant Private Type reference (TYPE) C 'X' 20110117
13 EXCEL_XML Instance attribute Private Type reference (TYPE) XSTRING 20110117
14 SHAREDSTRING_STRUCT Instance attribute Private Type reference (TYPE) YS_SHAREDSTRING_STRUC 20110117
15 STYLE_STRUCT Instance attribute Private Type reference (TYPE) YS_STYLE_STRUC 20110117
16 T_SHEETS Instance attribute Private Type reference (TYPE) YT_SHEETS 20110117
17 XLSX_DOCUMENT Instance attribute Private Object reference (TYPE REF TO) CL_XLSX_DOCUMENT 20110117
Methods
# Method Level Visibility Method type Description Created on
1 ADD_DRAWINGPART Instance method Private Method 20110117
2 ADD_HYPERLINK Instance method Private Method 20110117
3 ADD_IMAGE Instance method Private Method 20110117
4 ADD_SHAREDSTRING Instance method Private Method 20110117
5 ADD_SHEET Instance method Public Method 20110117
6 ADD_STYLE Instance method Private Method 20110117
7 CONSTRUCTOR Instance method Public Constructor 20110117
8 CREATE_DATA_CELL Instance method Private Method 20110117
9 DOWNLOAD Instance method Public Method 20110117
10 GENERATE_XML_AND_OPC Instance method Private Method 20110117
11 GET_CELLPOSITION Instance method Private Method 20110117
12 GET_CELL_VALUE Instance method Private Method 20110117
13 GET_COLUMN_COUNT Instance method Public Method 20110117
14 GET_DAYS_1900_AND_PERCENT Instance method Private Method 20110117
15 GET_DAYS_SINCE_1900 Instance method Private Method 20110117
16 GET_IMAGE_CONTENT Instance method Private Method 20110117
17 GET_IMAGE_SIZE Instance method Private Method 20110117
18 GET_ISONUM_FROM_INTNUM Instance method Private Method 20110117
19 GET_PERCENT_OF_ACT_DAY Instance method Private Method 20110117
20 SET_CELL Instance method Public Method 20110117
21 SET_CELL_INTERNAL Instance method Private Method 20110117
22 SET_COLUMN_HIDDEN Instance method Public Method 20110117
23 SET_COLUMN_WIDTH Instance method Public Method 20110117
24 SET_GROUPING Instance method Public Method 20110117
25 SET_SPAN_ROW Instance method Public Method 20110117
26 TO_STRING_BOOLEAN Instance method Private Method 20110117
27 TRANSFORM Instance method Public Method 20110117
Events
Class CL_SRT_WSP_EXCEL_2007 has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 YS_CELL_STRUC Private See coding 20110117 begin of ys_cell_struc, position type string, value type string, index type i, style type i, sharedstring type string, order type i, end of ys_cell_struc
2 YS_COLUMNINFO Private See coding 20110117 begin of ys_columninfo, column_index type i, width type i, maxwidth type i, hidden type boolean, end of ys_columninfo
3 YS_COL_STRUC Private See coding 20110117 begin of ys_col_struc, min type i, max type i, bestFit type i, hidden type i, width type i, end of ys_col_struc
4 YS_HYPERLINK_MAP Private See coding 20110117 begin of ys_hyperlink_map, link type string, rel_id type string, end of ys_hyperlink_map
5 YS_HYPERLINK_STRUC Private See coding 20110117 begin of ys_hyperlink_struc, rel_id type string, cell_id type string, end of ys_hyperlink_struc
6 YS_IMAGE Private See coding 20110117 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 20110117 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 20110117 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_MERGECELLS Private See coding 20110117 begin of ys_mergecells, range type string, end of ys_mergecells
10 YS_ROW_STRUC Private See coding 20110117 begin of ys_row_struc, spans type string, position type i, outlinelevel type i, hidden type char1, height type i, rowstyle type char1, range type boolean, t_cells type standard table of ys_cell_struc with non-unique key position initial size 1, end of ys_row_struc
11 YS_SHAREDSTRING Private See coding 20110117 begin of ys_sharedstring, value type string, end of ys_sharedstring
12 YS_SHAREDSTRING_STRUC Private See coding 20110117 begin of ys_sharedstring_struc, t_strings type standard table of ys_sharedstring with key value initial size 1, string_count type i, string_ucount type i, end of ys_sharedstring_struc
13 YS_SHEET_STRUC Private See coding 20110117 begin of ys_sheet_struc, dim type string, name type string, outlinelevel type i, summary_below type string, mergecell_count type i, max_col type i, max_row type i, max_level type i, max_span_width type i, t_columninfo type yt_columninfo, 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, t_mergecells type standard table of ys_mergecells with non-unique key range initial size 1, drawing_id type string, drawingpart type ref to CL_OXML_DRAWINGSPART, relid type string, sheetid type i, HYPERLINK_MAP type hashed table of YS_HYPERLINK_MAP with unique key link, worksheetpart type ref to cl_xlsx_worksheetpart, IMAGE_STRUCT type YS_IMAGE_STRUC, IMAGE_MAP type hashed table of ys_image_map with unique key id, end of ys_sheet_struc
14 YS_STYLE_CELLXF Private See coding 20110117 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
15 YS_STYLE_NUMFMT Private See coding 20110117 begin of ys_style_numfmt, id type i, code type string, end of ys_style_numfmt
16 YS_STYLE_STRUC Private See coding 20110117 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
17 YT_COLUMNINFO Private See coding 20110117 yt_columninfo type hashed table of ys_columninfo with unique key column_index initial size 1
18 YT_SHEETS Private See coding 20110117 yt_sheets type standard table of ys_sheet_struc with key name initial size 1
Method Signatures

Method ADD_DRAWINGPART Signature

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

Method ADD_DRAWINGPART on class CL_SRT_WSP_EXCEL_2007 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 20110117
2 Importing I_LINK Call by reference Type reference (TYPE) STRING 20110117
3 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117

Method ADD_HYPERLINK on class CL_SRT_WSP_EXCEL_2007 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 20110117
2 Importing CONTENT Call by reference Type reference (TYPE) XSTRING 20110117
3 Changing HEIGHT Call by reference Type reference (TYPE) I 20110117
4 Importing ID Call by reference Type reference (TYPE) STRING 20110117
5 Importing ROW Call by reference Type reference (TYPE) I 20110117
6 Importing SHEETNAME Call by reference Type reference (TYPE) STRING 20110117
7 Changing WIDTH Call by reference Type reference (TYPE) I 20110117

Method ADD_IMAGE on class CL_SRT_WSP_EXCEL_2007 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 20110117
2 Importing I_SHAREDSTRING Call by reference Type reference (TYPE) STRING 20110117

Method ADD_SHAREDSTRING on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method ADD_SHEET Signature

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

Method ADD_SHEET on class CL_SRT_WSP_EXCEL_2007 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 20110117
2 Importing I_CELLSTYLE Call by reference Type reference (TYPE) C 'N' 20110117
3 Importing I_DECIMALS Call by reference Type reference (TYPE) I 0 20110117
4 Importing I_HYPERLINK Call by reference Type reference (TYPE) I 0 20110117
5 Importing I_INDENT Call by reference Type reference (TYPE) I 0 20110117
6 Importing I_TYPE Call by reference Type reference (TYPE) C 20110117
7 Importing I_WRAP Call by reference Type reference (TYPE) I 0 20110117

Method ADD_STYLE on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_SRT_WSP_EXCEL_2007 has no parameter.
Method CONSTRUCTOR on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method CREATE_DATA_CELL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_DECIMALS Call by reference Type reference (TYPE) I 20110117
2 Exporting E_INTTYPE Call by reference Type reference (TYPE) C 20110117
3 Exporting E_VALUE Call by reference Type reference (TYPE) STRING 20110117
4 Importing I_CELL_ID Call by reference Type reference (TYPE) STRING 20110117
5 Importing I_CHECKBOX Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117
6 Importing I_DATA Call by reference Type reference (TYPE) ANY 20110117
7 Importing I_HYPERLINK Call by reference Type reference (TYPE) STRING 20110117
8 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117

Method CREATE_DATA_CELL on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method DOWNLOAD Signature

Method DOWNLOAD on class CL_SRT_WSP_EXCEL_2007 has no parameter.
Method DOWNLOAD on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GENERATE_XML_AND_OPC Signature

Method GENERATE_XML_AND_OPC on class CL_SRT_WSP_EXCEL_2007 has no parameter.
Method GENERATE_XML_AND_OPC on class CL_SRT_WSP_EXCEL_2007 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 20110117
2 Returning RESULT Value transfer Type reference (TYPE) STRING 20110117
3 Importing ROW Call by reference Type reference (TYPE) I 20110117

Method GET_CELLPOSITION on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GET_CELL_VALUE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_DECIMALS Call by reference Type reference (TYPE) DATA 20110117
2 Exporting E_INTTYPE Call by reference Type reference (TYPE) C 20110117
3 Exporting E_VALUE Call by reference Type reference (TYPE) DATA 20110117
4 Importing I_CHECKBOX Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117
5 Importing I_DATA Call by reference Type reference (TYPE) ANY 20110117

Method GET_CELL_VALUE on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GET_COLUMN_COUNT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117
2 Returning R_COL_COUNT Value transfer Type reference (TYPE) I 20110117

Method GET_COLUMN_COUNT on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GET_DAYS_1900_AND_PERCENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_NUM Call by reference Type reference (TYPE) STRING 20110117
2 Importing I_TIMESTAMP Call by reference Type reference (TYPE) P 20110117

Method GET_DAYS_1900_AND_PERCENT on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GET_DAYS_SINCE_1900 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_NUM Call by reference Type reference (TYPE) STRING 20110117
2 Importing I_DATE Call by reference Type reference (TYPE) D 20110117

Method GET_DAYS_SINCE_1900 on class CL_SRT_WSP_EXCEL_2007 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 20110117
2 Returning VALUE Value transfer Type reference (TYPE) XSTRING 20110117

Method GET_IMAGE_CONTENT on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GET_IMAGE_SIZE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CONTENT Call by reference Type reference (TYPE) XSTRING 20110117
2 Exporting HEIGHT Call by reference Type reference (TYPE) I 20110117
3 Importing IMAGE_TYPE Call by reference Type reference (TYPE) STRING 20110117
4 Exporting WIDTH Call by reference Type reference (TYPE) I 20110117

Method GET_IMAGE_SIZE on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GET_ISONUM_FROM_INTNUM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_VALUE Call by reference Type reference (TYPE) STRING 20110117
2 Importing I_DECIMALS Call by reference Type reference (TYPE) ANY 20110117
3 Importing I_VALUE Call by reference Type reference (TYPE) ANY 20110117

Method GET_ISONUM_FROM_INTNUM on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method GET_PERCENT_OF_ACT_DAY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_NUM Call by reference Type reference (TYPE) STRING 20110117
2 Importing I_TIME Call by reference Type reference (TYPE) T 20110117

Method GET_PERCENT_OF_ACT_DAY on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method SET_CELL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_CELLSTYLE Call by reference Type reference (TYPE) C C_CELLSTYLE_NORMAL 20110117
2 Importing I_CHECKBOX Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117
3 Importing I_COL_INDEX Call by reference Type reference (TYPE) I 20110117
4 Importing I_DATA Call by reference Type reference (TYPE) ANY 20110117
5 Importing I_HYPERLINK Call by reference Type reference (TYPE) STRING 20110117
6 Importing I_IMAGE_SOURCE Call by reference Type reference (TYPE) STRING 20110117
7 Importing I_INDENT Call by reference Type reference (TYPE) I 0 20110117
8 Importing I_ROW_INDEX Call by reference Type reference (TYPE) I 20110117
9 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117

Method SET_CELL on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method SET_CELL_INTERNAL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_CELLSTYLE Call by reference Type reference (TYPE) C C_CELLSTYLE_NORMAL 20110117
2 Importing I_CHECKBOX Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117
3 Importing I_COL_INDEX Call by reference Type reference (TYPE) I 20110117
4 Importing I_DATA Call by reference Type reference (TYPE) ANY 20110117
5 Importing I_HYPERLINK Call by reference Type reference (TYPE) STRING 20110117
6 Importing I_IGNORE_WIDTH Call by reference Type reference (TYPE) BOOLEAN ABAP_FALSE 20110117
7 Importing I_IMAGE_SOURCE Call by reference Type reference (TYPE) STRING 20110117
8 Importing I_INDENT Call by reference Type reference (TYPE) I 0 20110117
9 Importing I_ROW_INDEX Call by reference Type reference (TYPE) I 20110117
10 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117
11 Importing I_SPAN Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117

Method SET_CELL_INTERNAL on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method SET_COLUMN_HIDDEN Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_COL_INDEX Call by reference Type reference (TYPE) I 20110117
2 Importing I_HIDDEN Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117
3 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117

Method SET_COLUMN_HIDDEN on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method SET_COLUMN_WIDTH Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_COL_INDEX Call by reference Type reference (TYPE) I 20110117
2 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117
3 Importing I_WIDTH Call by reference Type reference (TYPE) I 20110117

Method SET_COLUMN_WIDTH on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method SET_GROUPING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_COLLAPSED Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117
2 Importing I_END_ROW Call by reference Type reference (TYPE) I 20110117
3 Importing I_LEVEL Call by reference Type reference (TYPE) I 20110117
4 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117
5 Importing I_START_ROW Call by reference Type reference (TYPE) I 20110117

Method SET_GROUPING on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method SET_SPAN_ROW Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_CELLSTYLE Call by reference Type reference (TYPE) C C_CELLSTYLE_NORMAL 20110117
2 Importing I_CHECKBOX Call by reference Type reference (TYPE) BOOLEAN Boolean Variable (X=True, -=False, Space=Unknown) 20110117
3 Importing I_DATA Call by reference Type reference (TYPE) ANY 20110117
4 Importing I_HYPERLINK Call by reference Type reference (TYPE) STRING 20110117
5 Importing I_IMAGE_SOURCE Call by reference Type reference (TYPE) STRING 20110117
6 Importing I_INDENT Call by reference Type reference (TYPE) I 0 20110117
7 Importing I_ROW_INDEX Call by reference Type reference (TYPE) I 20110117
8 Importing I_SHEETNAME Call by reference Type reference (TYPE) STRING 20110117

Method SET_SPAN_ROW on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method TO_STRING_BOOLEAN Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_VALUE Call by reference Type reference (TYPE) STRING 20110117
2 Importing INPUT Call by reference Type reference (TYPE) ANY 20110117

Method TO_STRING_BOOLEAN on class CL_SRT_WSP_EXCEL_2007 has no exception.

Method TRANSFORM Signature

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

Method TRANSFORM on class CL_SRT_WSP_EXCEL_2007 has no exception.
History
Last changed by/on SAP  20110908 
SAP Release Created in