SAP ABAP Class CL_FDT_XL_SPREADSHEET (FDT:Spreadsheet document)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-BR (Application Component) BRFplus - ABAP-Based Business Rules
     ⤷ SFDT_EXCEL_CORE (Package) BRFplus: Excel Integration Core
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_FDT_XL_DOCUMENT FDT:OOXML Document 20080616
2 Interface implementation (CLASS c. INTERFACES i_ref)  IF_FDT_DOC_SPREADSHEET FDT: Spreadsheet Interface 20080616
Properties
Class CL_FDT_XL_SPREADSHEET  
Short Description FDT:Spreadsheet document    
Super Class CL_FDT_XL_DOCUMENT FDT:OOXML Document 
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package SFDT_EXCEL_CORE   BRFplus: Excel Integration Core 
Created 20080616   SAP 
Last change 20140121   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)
2 IF_FDT_DOC_SPREADSHEET Forward declaration interface (INTERFACE i DEFINITION DEF...  Forward declaration interface (INTERFACE i DEFINITION DEF...
Interfaces
# Interface Abstract Final Description Created on
1 IF_FDT_DOC_SPREADSHEET FDT: Spreadsheet Interface 20080616
Friends
Class CL_FDT_XL_SPREADSHEET has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 DATEFORMAT1904 Instance attribute Private Type reference (TYPE) ABAP_BOOL 20080616
2 DEFAULT_SHEET_NAME Constant Private Type reference (TYPE) STRING 'Sheet1' 20080725
3 GC_RELS_EXTN Constant Private Type reference (TYPE) STRING '.rels' 20090102
4 GC_RELS_PATH Constant Private Type reference (TYPE) STRING '_rels/' 20090102
5 MT_SHARED_STRINGS Instance attribute Private See coding 20130521
6 NAMED_CELLS Instance attribute Private Type reference (TYPE) TAB_NAMED_CELLS 20080616
7 NAMED_RANGES Instance attribute Private Type reference (TYPE) TAB_NAMED_RANGES 20080616
8 NUMFMTIDS Instance attribute Private Type reference (TYPE) T_NUMFMTIDS 20080616
9 WORKBOOK_FILENAME Instance attribute Private Type reference (TYPE) STRING 20080616
10 WORKBOOK_FOLDER Instance attribute Private Type reference (TYPE) STRING 20080616
11 WORKBOOK_RELATIONS Instance attribute Private Type reference (TYPE) T_POD_RELATIONS 20080616
12 WORKSHEETS Instance attribute Private Type reference (TYPE) OOXML_WORKSHEETS 20080616
Methods
# Method Level Visibility Method type Description Created on
1 CLEAR_WORKSHEET_SHEETDATA Instance method Private Method 20080616
2 CONSTRUCTOR Instance method Public Constructor 20080616
3 CONVERT_CELL_VALUE_BY_NUMFMT Instance method Private Method 20080616
4 CONVERT_COLUMN_TO_I Instance method Private Method 20080616
5 CONVERT_DEC_TIME_TO_HHMMSS Instance method Private Method 20080616
6 CONVERT_I_TO_COLUMN Instance method Private Method 20080616
7 CONVERT_LONG_TO_DATE Instance method Private Method 20080616
8 CONVERT_SER_VAL_TO_DATE_TIME Instance method Private Method 20080616
9 CREATE_BLANK_DOCUMENT_STRUCT Static method Private Method 20080616
10 CREATE_CELL_ELEMENTS Instance method Private Method 20130517
11 CREATE_CELL_ELEMENTS_HEADER Instance method Private Method 20130517
12 CREATE_DOCUMENT Static method Private Method 20080616
13 CREATE_WORKSHEET_ROW Instance method Private Method 20130517
14 CREATE_WORKSHEET_ROW_BASE Instance method Private Method Create a new empty table row 20130517
15 CREATE_WORKSHEET_ROW_NTL Instance method Private Method 20130517
16 EXTRACT_COL_FROM_A1_STYLE Instance method Private Method 20080616
17 GET_CELLXFS Instance method Private Method 20080616
18 GET_CELL_STYLE_ID Instance method Private Method 20080616
19 GET_CELL_VALUE Instance method Private Method 20080616
20 GET_CELL_VALUE_BY_XMLDOC_SHRDS Instance method Private Method 20080616
21 GET_COL_AND_ROW_FROM_A1_STYLE Instance method Private Method 20080616
22 GET_COL_FROM_A1_STYLE Instance method Private Method 20080616
23 GET_ITAB_FOR_ALV_BY_XMLDOC Instance method Private Method 20080616
24 GET_ITAB_FOR_ALV_UPDATE Instance method Private Method 20080616
25 GET_ITAB_FROM_SHEET Instance method Private Method 20080616
26 GET_LANGU_TEXT Static method Public Method Get the description of language 20130503
27 GET_MAPPING Instance method Private Method 20080616
28 GET_NAMED_CELL Instance method Private Method 20080616
29 GET_NAMED_CELLS Instance method Private Method 20080616
30 GET_NAMED_RANGES Instance method Private Method 20080616
31 GET_NAMED_RANGE_ITAB Instance method Private Method 20080616
32 GET_OR_CREATE_INDEX_SHARED_STR Instance method Private Method 20080616
33 GET_RANGE_ITAB_FROM_XMLDOC Instance method Private Method 20080616
34 GET_SHARED_STRINGS Instance method Private Method 20080616
35 GET_WORKSHEET_BY_ID Instance method Private Method 20080616
36 GET_WORKSHEET_BY_NAME Instance method Private Method 20080616
37 GET_WORKSHEET_NAMES Instance method Private Method 20080616
38 INIT_SHARED_STRINGS_FILE Instance method Private Method 20080616
39 INSERT_EMPTY_WORKSHEET_ROW Instance method Private Method Create a new empty table row 20130521
40 LOAD_DEFINED_NAMES Instance method Private Method 20080616
41 LOAD_NUMFMTIDS Instance method Private Method 20080616
42 LOAD_SHARED_STRINGS Instance method Private Method 20080616
43 LOAD_WORKBOOK Instance method Private Method 20080616
44 LOAD_WORKSHEETS Instance method Private Method 20080616
45 OVERWRITE_WORKSHEET_BY_ID Instance method Private Method 20080616
46 OVERWRITE_WORKSHEET_BY_NAME Instance method Private Method 20080616
47 SET_CELL_VALUE_BY_XMLDOC Instance method Private Method 20080616
48 SET_HELP_DT_SHEETDATA Instance method Private Method Updates the Help for the excel spreadsheet 20090220
49 SET_HELP_SIM_SHEETDATA Instance method Private Method Updates the Help for the simulation of the function 20090309
50 SET_MAPPING Instance method Private Method 20080616
51 SET_NAMED_CELL_VALUE Instance method Private Method 20080616
52 SET_NAMED_RANGE_VALUES Instance method Private Method 20080616
53 SET_SHARED_STRINGS Instance method Private Method 20080616
54 SET_WORKSHEET_COLS Instance method Private Method 20080616
55 SET_WORKSHEET_DIMENSION Instance method Private Method 20080616
56 SET_WORKSHEET_FORMATPR Instance method Private Method Add the format Printer attribute for the grouping 20101208
57 SET_WORKSHEET_SHEETDATA Instance method Private Method 20080616
58 SET_WORKSHEET_WRAPTEXT Instance method Private Method Add the Wrap text in the document. 20110225
59 STORE_WORKBOOK_RELATIONS Instance method Private Method 20080616
Events
Class CL_FDT_XL_SPREADSHEET has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 OOXML_WORKSHEET Protected See coding 20080616 begin of ooxml_worksheet. types name type string. types id type string. types location type string. types end of ooxml_worksheet
2 OOXML_WORKSHEETS Protected See coding 20080616 ooxml_worksheets type standard table of ooxml_worksheet
3 STRUC_NAMED_CELL Protected See coding 20080616 begin of struc_named_cell. types name type string. types sheet_name type string. types cell type string. types format type string. types end of struc_named_cell
4 STRUC_NAMED_RANGE Protected See coding 20080616 begin of struc_named_range. types name type string. types sheet_name type string. types start_cell type string. types end_cell type string. types end of struc_named_range
5 TAB_NAMED_CELLS Protected See coding 20080616 tab_named_cells type standard table of struc_named_cell
6 TAB_NAMED_RANGES Protected See coding 20080616 tab_named_ranges type standard table of struc_named_range
7 T_NUMFMTIDS Protected See coding 20080616 t_numfmtids type standard table of t_struc_numfmtid
8 T_STRUC_NUMFMTID Protected See coding 20080616 begin of t_struc_numfmtid. types id type i. types formatCode type string. types end of t_struc_numfmtid
Method Signatures

Method CLEAR_WORKSHEET_SHEETDATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning SHEETDATA_NODE Value transfer Object reference (TYPE REF TO) IF_IXML_NODE 20080616
2 Importing SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method CLEAR_WORKSHEET_SHEETDATA on class CL_FDT_XL_SPREADSHEET has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DOCUMENT_NAME Value transfer Type reference (TYPE) STRING 20080616
2 Importing MIME_TYPE Call by reference Type reference (TYPE) STRING 20080616
3 Importing XDOCUMENT Value transfer Type reference (TYPE) XSTRING 20080616
# Exception Resumable Description Created on
1 CX_FDT_EXCEL_CORE 20080616

Method CONVERT_CELL_VALUE_BY_NUMFMT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CELL_VALUE Call by reference Type reference (TYPE) STRING 20080616
2 Returning FORMATTED_VALUE Value transfer Type reference (TYPE) STRING 20080616
3 Importing NUMBER_FORMAT Call by reference Type reference (TYPE) STRING 20080616

Method CONVERT_CELL_VALUE_BY_NUMFMT on class CL_FDT_XL_SPREADSHEET has no exception.

Method CONVERT_COLUMN_TO_I Signature

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

Method CONVERT_COLUMN_TO_I on class CL_FDT_XL_SPREADSHEET has no exception.

Method CONVERT_DEC_TIME_TO_HHMMSS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DEC_TIME_STRING Call by reference Type reference (TYPE) STRING 20080616
2 Returning TIME Value transfer Type reference (TYPE) T 20080616

Method CONVERT_DEC_TIME_TO_HHMMSS on class CL_FDT_XL_SPREADSHEET has no exception.

Method CONVERT_I_TO_COLUMN Signature

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

Method CONVERT_I_TO_COLUMN on class CL_FDT_XL_SPREADSHEET has no exception.

Method CONVERT_LONG_TO_DATE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DATE Value transfer Type reference (TYPE) D 20080616
2 Importing DATE_STRING Call by reference Type reference (TYPE) STRING 20080616

Method CONVERT_LONG_TO_DATE on class CL_FDT_XL_SPREADSHEET has no exception.

Method CONVERT_SER_VAL_TO_DATE_TIME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting DATE Call by reference Type reference (TYPE) D 20080616
2 Importing SERIAL_VALUE_STRING Call by reference Type reference (TYPE) STRING 20080616
3 Exporting TIME Call by reference Type reference (TYPE) T 20080616

Method CONVERT_SER_VAL_TO_DATE_TIME on class CL_FDT_XL_SPREADSHEET has no exception.

Method CREATE_BLANK_DOCUMENT_STRUCT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20080616
2 Importing IV_CALL_TYPE Call by reference Type reference (TYPE) I 20120618
3 Importing IV_SHEET_NAME Call by reference Type reference (TYPE) STRING 'Sheet1' 20130425
4 Importing META_DESCRIPTION Call by reference Type reference (TYPE) STRING 20080616
5 Importing META_KEYWORDS Call by reference Type reference (TYPE) STRING 20080616
6 Importing META_SUBJECT Call by reference Type reference (TYPE) STRING 20080616
7 Importing META_TITLE Call by reference Type reference (TYPE) STRING 20080616
8 Importing WORKSHEET_NAME Call by reference Type reference (TYPE) STRING DEFAULT_SHEET_NAME 20080616
9 Returning XBLANK_DOCUMENT Value transfer Type reference (TYPE) XSTRING 20080616

Method CREATE_BLANK_DOCUMENT_STRUCT on class CL_FDT_XL_SPREADSHEET has no exception.

Method CREATE_CELL_ELEMENTS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IO_ROW_ELEMENT Call by reference Object reference (TYPE REF TO) IF_IXML_ELEMENT Natural number 20130517
2 Importing IO_SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT XML Document in DOM Representation 20130517
3 Importing IS_ROW Call by reference Type reference (TYPE) ANY 20130517
4 Importing IT_COLUMN Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN 20130517
5 Importing IT_COLUMN_DESCRIPTION Call by reference Type reference (TYPE) ABAP_COMPONENT_TAB 20130517
6 Importing IV_CALL_TYPE Call by reference Type reference (TYPE) I 20130517
7 Importing IV_IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20130517
8 Importing IV_ROW_NUMBER Call by reference Type reference (TYPE) STRING 20130517

Method CREATE_CELL_ELEMENTS on class CL_FDT_XL_SPREADSHEET has no exception.

Method CREATE_CELL_ELEMENTS_HEADER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IO_ROW_ELEMENT Call by reference Object reference (TYPE REF TO) IF_IXML_ELEMENT Natural number 20130517
2 Importing IO_SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT XML Document in DOM Representation 20130517
3 Importing IT_COLUMN Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN 20130517
4 Importing IT_COLUMN_DESCRIPTION Call by reference Type reference (TYPE) ABAP_COMPONENT_TAB 20130517
5 Importing IV_CALL_TYPE Call by reference Type reference (TYPE) I 20130517
6 Importing IV_IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20130517

Method CREATE_CELL_ELEMENTS_HEADER on class CL_FDT_XL_SPREADSHEET has no exception.

Method CREATE_DOCUMENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COLUMNS Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN 20081224
2 Importing COLUMNS_AUX Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN Excel sheet column for Decision table column description 20120608
3 Importing IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20080616
4 Importing ITAB Call by reference Object reference (TYPE REF TO) DATA 20080616
5 Importing ITAB_AUX_COL_DESC Call by reference Object reference (TYPE REF TO) DATA Decision Table Column Description 20120608
6 Importing IT_DT_MAP_COL Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN 20120709
7 Importing IT_DT_MAP_COL_DESC Call by reference Object reference (TYPE REF TO) DATA 20120709
8 Importing IV_CALL_TYPE Call by reference Type reference (TYPE) I 20111214
9 Importing IV_SHEET_NAME Call by reference Type reference (TYPE) STRING 20130425
10 Importing NAME Call by reference Type reference (TYPE) STRING IF_FDT_DOC_SPREADSHEET=>DEFAULT_FILENAME 20080616
11 Returning XDOCUMENT Value transfer Type reference (TYPE) XSTRING 20080616
# Exception Resumable Description Created on
1 CX_FDT_EXCEL_CORE 20080616

Method CREATE_WORKSHEET_ROW Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CV_GROUP_NUMBER Call by reference Type reference (TYPE) INT4 Natural number 20130517
2 Changing CV_GROUP_NUMBER_MAX Call by reference Type reference (TYPE) INT4 Natural number 20130517
3 Importing IO_SHEET_DATA_NODE Call by reference Object reference (TYPE REF TO) IF_IXML_NODE Node of DOM 20130517
4 Importing IO_SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT XML Document in DOM Representation 20130517
5 Importing IS_ROW Call by reference Type reference (TYPE) ANY 20130517
6 Importing IT_COLUMN Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN 20130517
7 Importing IT_COLUMN_DESCRIPTION Call by reference Type reference (TYPE) ABAP_COMPONENT_TAB 20130517
8 Importing IV_CALL_TYPE Call by reference Type reference (TYPE) I 20130517
9 Importing IV_IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20130517
10 Importing IV_ROW_NUMBER Call by reference Type reference (TYPE) INT4 Natural number 20130517

Method CREATE_WORKSHEET_ROW on class CL_FDT_XL_SPREADSHEET has no exception.

Method CREATE_WORKSHEET_ROW_BASE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IO_SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT XML Document in DOM Representation 20130517
2 Importing IV_ROW Call by reference Type reference (TYPE) INT4 Natural number 20130517
3 Returning RO_ROW_ELEMENT Value transfer Object reference (TYPE REF TO) IF_IXML_ELEMENT Element of an XML Document 20130517

Method CREATE_WORKSHEET_ROW_BASE on class CL_FDT_XL_SPREADSHEET has no exception.

Method CREATE_WORKSHEET_ROW_NTL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CV_GROUP_NUMBER_MAX Call by reference Type reference (TYPE) INT4 Natural number 20130517
2 Changing CV_ROW_NUMBER Call by reference Type reference (TYPE) INT4 Natural number 20130517
3 Importing IO_SHEET_DATA_NODE Call by reference Object reference (TYPE REF TO) IF_IXML_NODE Node of DOM 20130517
4 Importing IO_SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT XML Document in DOM Representation 20130517
5 Importing IS_ROW Call by reference Type reference (TYPE) ANY 20130517
6 Importing IT_COLUMN Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN 20130517
7 Importing IT_COLUMN_DESCRIPTION Call by reference Type reference (TYPE) ABAP_COMPONENT_TAB 20130517
8 Importing IT_DATA Call by reference Type reference (TYPE) STANDARD TABLE 20130517
9 Importing IV_IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20130517
10 Importing IV_ROW_INDEX Call by reference Type reference (TYPE) SY-TABIX ABAP System Field: Row Index of Internal Tables 20130521

Method CREATE_WORKSHEET_ROW_NTL on class CL_FDT_XL_SPREADSHEET has no exception.

Method EXTRACT_COL_FROM_A1_STYLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning COLUMN Value transfer Type reference (TYPE) STRING 20080616
2 Importing INPUT Call by reference Type reference (TYPE) STRING 20080616

Method EXTRACT_COL_FROM_A1_STYLE on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_CELLXFS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting CELLXFS Call by reference Type reference (TYPE) STANDARD TABLE 20080616

Method GET_CELLXFS on class CL_FDT_XL_SPREADSHEET 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 CELL_COORDINATE Call by reference Type reference (TYPE) STRING 20080616
2 Returning STYLE_ID Value transfer Type reference (TYPE) I 20080616
3 Importing XML_DOC Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method GET_CELL_STYLE_ID on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_CELL_VALUE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CELL_COORDINATE Call by reference Type reference (TYPE) STRING 20080616
2 Returning CELL_VALUE Value transfer Type reference (TYPE) STRING 20080616
3 Importing SHEET_NAME Call by reference Type reference (TYPE) STRING 20080616

Method GET_CELL_VALUE on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_CELL_VALUE_BY_XMLDOC_SHRDS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CELL_COORDINATE Call by reference Type reference (TYPE) STRING 20080616
2 Returning CELL_VALUE Value transfer Type reference (TYPE) STRING 20080616
3 Importing SHARED_STRINGS Call by reference Type reference (TYPE) STANDARD TABLE 20080616
4 Importing XML_DOC Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method GET_CELL_VALUE_BY_XMLDOC_SHRDS on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_COL_AND_ROW_FROM_A1_STYLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting COLUMN_NUMBER Call by reference Type reference (TYPE) I 20080616
2 Importing COORDINATE Call by reference Type reference (TYPE) STRING 20080616
3 Exporting ROW_NUMBER Call by reference Type reference (TYPE) I 20080616

Method GET_COL_AND_ROW_FROM_A1_STYLE on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_COL_FROM_A1_STYLE Signature

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

Method GET_COL_FROM_A1_STYLE on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_ITAB_FOR_ALV_BY_XMLDOC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning ITAB Value transfer Object reference (TYPE REF TO) DATA 20080616
2 Importing RANGE_END Call by reference Type reference (TYPE) STRING 20080616
3 Importing RANGE_START Call by reference Type reference (TYPE) STRING 20080616
4 Importing XML_DOC Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method GET_ITAB_FOR_ALV_BY_XMLDOC on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_ITAB_FOR_ALV_UPDATE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning ITAB Value transfer Object reference (TYPE REF TO) DATA 20080616

Method GET_ITAB_FOR_ALV_UPDATE on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_ITAB_FROM_SHEET Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning ITAB Value transfer Object reference (TYPE REF TO) DATA 20080616
2 Importing IV_CALLER Call by reference Type reference (TYPE) I 20130430
3 Importing IV_GET_LANGUAGE Call by reference Type reference (TYPE) ABAP_BOOL 20130430
4 Importing WORKSHEET_NAME Call by reference Type reference (TYPE) STRING 20080616

Method GET_ITAB_FROM_SHEET on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_LANGU_TEXT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_LANGU Call by reference Type reference (TYPE) CHAR1 LangKey 20130503
2 Returning RV_TEXT Value transfer Type reference (TYPE) STRING Name of Language 20130503

Method GET_LANGU_TEXT on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_MAPPING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning MAPPING Value transfer Object reference (TYPE REF TO) CL_FDT_DOC_MAPPING 20080616

Method GET_MAPPING on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_NAMED_CELL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CELL_NAME Call by reference Type reference (TYPE) STRING 20080616
2 Returning CELL_VALUE Value transfer Type reference (TYPE) STRING 20080616

Method GET_NAMED_CELL on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_NAMED_CELLS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning NAMED_CELLS Value transfer Attribute reference (LIKE) NAMED_CELLS 20080616

Method GET_NAMED_CELLS on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_NAMED_RANGES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning NAMED_RANGES Value transfer Attribute reference (LIKE) NAMED_RANGES 20080616

Method GET_NAMED_RANGES on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_NAMED_RANGE_ITAB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning ITAB Value transfer Object reference (TYPE REF TO) DATA 20080616
2 Importing RANGE Call by reference Type reference (TYPE) STRING 20080616

Method GET_NAMED_RANGE_ITAB on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_OR_CREATE_INDEX_SHARED_STR Signature

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

Method GET_OR_CREATE_INDEX_SHARED_STR on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_RANGE_ITAB_FROM_XMLDOC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning ITAB Value transfer Object reference (TYPE REF TO) DATA 20080616
2 Importing RANGE_END Call by reference Type reference (TYPE) STRING 20080616
3 Importing RANGE_START Call by reference Type reference (TYPE) STRING 20080616
4 Importing XML_DOC Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method GET_RANGE_ITAB_FROM_XMLDOC on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_SHARED_STRINGS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting STRINGS Value transfer Type reference (TYPE) STANDARD TABLE 20080616

Method GET_SHARED_STRINGS on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_WORKSHEET_BY_ID Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing WORKSHEET_ID Call by reference Type reference (TYPE) STRING 20080616
2 Returning XSHEET Value transfer Type reference (TYPE) XSTRING 20080616

Method GET_WORKSHEET_BY_ID on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_WORKSHEET_BY_NAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing WORKSHEET_NAME Call by reference Type reference (TYPE) STRING 20080616
2 Returning XSHEET Value transfer Type reference (TYPE) XSTRING 20080616

Method GET_WORKSHEET_BY_NAME on class CL_FDT_XL_SPREADSHEET has no exception.

Method GET_WORKSHEET_NAMES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting WORKSHEET_NAMES Call by reference Type reference (TYPE) STANDARD TABLE 20080616

Method GET_WORKSHEET_NAMES on class CL_FDT_XL_SPREADSHEET has no exception.

Method INIT_SHARED_STRINGS_FILE Signature

Method INIT_SHARED_STRINGS_FILE on class CL_FDT_XL_SPREADSHEET has no parameter.
Method INIT_SHARED_STRINGS_FILE on class CL_FDT_XL_SPREADSHEET has no exception.

Method INSERT_EMPTY_WORKSHEET_ROW Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CV_ROW Call by reference Type reference (TYPE) INT4 Natural number 20130521
2 Importing IO_SHEET_DATA_NODE Call by reference Object reference (TYPE REF TO) IF_IXML_NODE Node of DOM 20130521
3 Importing IO_SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT XML Document in DOM Representation 20130521

Method INSERT_EMPTY_WORKSHEET_ROW on class CL_FDT_XL_SPREADSHEET has no exception.

Method LOAD_DEFINED_NAMES Signature

Method LOAD_DEFINED_NAMES on class CL_FDT_XL_SPREADSHEET has no parameter.
Method LOAD_DEFINED_NAMES on class CL_FDT_XL_SPREADSHEET has no exception.

Method LOAD_NUMFMTIDS Signature

Method LOAD_NUMFMTIDS on class CL_FDT_XL_SPREADSHEET has no parameter.
Method LOAD_NUMFMTIDS on class CL_FDT_XL_SPREADSHEET has no exception.

Method LOAD_SHARED_STRINGS Signature

Method LOAD_SHARED_STRINGS on class CL_FDT_XL_SPREADSHEET has no parameter.
Method LOAD_SHARED_STRINGS on class CL_FDT_XL_SPREADSHEET has no exception.

Method LOAD_WORKBOOK Signature

Method LOAD_WORKBOOK on class CL_FDT_XL_SPREADSHEET has no parameter.
Method LOAD_WORKBOOK on class CL_FDT_XL_SPREADSHEET has no exception.

Method LOAD_WORKSHEETS Signature

Method LOAD_WORKSHEETS on class CL_FDT_XL_SPREADSHEET has no parameter.
Method LOAD_WORKSHEETS on class CL_FDT_XL_SPREADSHEET has no exception.

Method OVERWRITE_WORKSHEET_BY_ID Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing WORKSHEET_ID Call by reference Type reference (TYPE) STRING 20080616
2 Importing XSHEET Call by reference Type reference (TYPE) XSTRING 20080616

Method OVERWRITE_WORKSHEET_BY_ID on class CL_FDT_XL_SPREADSHEET has no exception.

Method OVERWRITE_WORKSHEET_BY_NAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing WORKSHEET_NAME Call by reference Type reference (TYPE) STRING 20080616
2 Importing XSHEET Call by reference Type reference (TYPE) XSTRING 20080616

Method OVERWRITE_WORKSHEET_BY_NAME on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_CELL_VALUE_BY_XMLDOC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CELL_COORDINATE Call by reference Type reference (TYPE) STRING 20080616
2 Importing VALUE Call by reference Object reference (TYPE REF TO) DATA 20080616
3 Changing XML_DOC Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method SET_CELL_VALUE_BY_XMLDOC on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_HELP_DT_SHEETDATA Signature

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

Method SET_HELP_DT_SHEETDATA on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_HELP_SIM_SHEETDATA Signature

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

Method SET_HELP_SIM_SHEETDATA on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_MAPPING Signature

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

Method SET_MAPPING on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_NAMED_CELL_VALUE Signature

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

Method SET_NAMED_CELL_VALUE on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_NAMED_RANGE_VALUES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing ITAB Call by reference Object reference (TYPE REF TO) DATA 20080616
2 Importing RANGE_NAME Call by reference Type reference (TYPE) STRING 20080616

Method SET_NAMED_RANGE_VALUES on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_SHARED_STRINGS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SHARED_STRINGS Call by reference Type reference (TYPE) STANDARD TABLE 20080616

Method SET_SHARED_STRINGS on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_WORKSHEET_COLS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COLUMN_DESCRIPTION_TAB Call by reference Type reference (TYPE) ABAP_COMPONENT_TAB 20080616
2 Importing IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20080616
3 Importing IV_CALL_TYPE Call by reference Type reference (TYPE) I 20111214
4 Importing IV_COLUMN_DECTAB Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20111214
5 Importing SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method SET_WORKSHEET_COLS on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_WORKSHEET_DIMENSION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DIMENSION Call by reference Type reference (TYPE) STRING 20080616
2 Importing SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method SET_WORKSHEET_DIMENSION on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_WORKSHEET_FORMATPR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing OUTLINELEVEL Call by reference Type reference (TYPE) STRING 20101208
2 Importing SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT IF_IXML_DOCUMENT 20101208

Method SET_WORKSHEET_FORMATPR on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_WORKSHEET_SHEETDATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COLUMNS Call by reference Type reference (TYPE) IF_FDT_DOC_SPREADSHEET=>T_COLUMN 20081224
2 Importing IS_ALV_DOCUMENT Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20080616
3 Importing ITAB Call by reference Object reference (TYPE REF TO) DATA 20080616
4 Importing IV_CALL_TYPE Call by reference Type reference (TYPE) I 20111214
5 Importing IV_COLUMN_DECTAB Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20111214
6 Importing SHEET_XML_DOCUMENT Call by reference Object reference (TYPE REF TO) IF_IXML_DOCUMENT 20080616

Method SET_WORKSHEET_SHEETDATA on class CL_FDT_XL_SPREADSHEET has no exception.

Method SET_WORKSHEET_WRAPTEXT Signature

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

Method SET_WORKSHEET_WRAPTEXT on class CL_FDT_XL_SPREADSHEET has no exception.

Method STORE_WORKBOOK_RELATIONS Signature

Method STORE_WORKBOOK_RELATIONS on class CL_FDT_XL_SPREADSHEET has no parameter.
Method STORE_WORKBOOK_RELATIONS on class CL_FDT_XL_SPREADSHEET has no exception.
History
Last changed by/on SAP  20140121 
SAP Release Created in 712