SAP ABAP Class CL_CNV_MBT_700_SPRD_TABLE_IO (Upload or download a table from / to a spreadsheet)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_MBT_MAIN_700 (Package) MBT PCL Main Objects release 700

Properties

Class	CL_CNV_MBT_700_SPRD_TABLE_IO
Short Description	Upload or download a table from / to a spreadsheet
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	CNV_MBT_MAIN_700	MBT PCL Main Objects release 700
Created	20120110	SAP
Last change	20141030
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	CL_CNV_MBT_SPRD_WB_ODS_PRCSR	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
2	CL_CNV_MBT_SPRD_WORKBOOK	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)

Interfaces

Class CL_CNV_MBT_700_SPRD_TABLE_IO has no interface implemented.

Friends

Class CL_CNV_MBT_700_SPRD_TABLE_IO has no friend class.

Attributes

Class CL_CNV_MBT_700_SPRD_TABLE_IO has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_FIELD_CATALOG	Instance method	Public	Method	Creates the field catalog for the given table	20121119
2	GET_ALL_COMPONENTS	Instance method	Private	Method	Recursively get all components of a structure	20130415
3	LOAD	Instance method	Public	Method	Load the table from the binary file	20121119
4	SAVE	Instance method	Public	Method	Save the table to a binary file	20121119

Events

Class CL_CNV_MBT_700_SPRD_TABLE_IO has no event.

Types

Class CL_CNV_MBT_700_SPRD_TABLE_IO has no local type.

Method Signatures

Method BUILD_FIELD_CATALOG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TABLE	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20121119
2	Returning	RT_FIELD_CATALOG	Value transfer	☐	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for List Viewer Control	20121119

Method BUILD_FIELD_CATALOG on class CL_CNV_MBT_700_SPRD_TABLE_IO has no exception.

Method GET_ALL_COMPONENTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STRUCT_DESCR	Call by reference	☐	Object reference (TYPE REF TO)	CL_ABAP_STRUCTDESCR		Runtime Type Services	20130415
2	Returning	RT_COMPONENTS	Value transfer	☐	Type reference (TYPE)	ABAP_COMPONENT_TAB			20130415

Method GET_ALL_COMPONENTS on class CL_CNV_MBT_700_SPRD_TABLE_IO has no exception.

Method LOAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FIELD_CATALOG	Value transfer	☑	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for List Viewer Control	20121119
2	Importing	IV_FILE	Call by reference	☐	Type reference (TYPE)	XSTRING		File to be loaded to the table	20121119
3	Importing	IV_FORMAT	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_FORMAT	CL_CNV_MBT_SPRD_WB_ODS_PRCSR=>NC_FILE_FORMAT	Workbook Format	20121119
4	Importing	IV_HEADER_LENGTH	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_HEADER_LENGTH	CL_CNV_MBT_SPRD_WORKBOOK=>NC_DEFAULT_HEADER_LENGTH	Header length	20121119
5	Importing	IV_WORKSHEET_NAME	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_WORKSHEET_NAME	'Sheet1'	Worksheet name	20121119
6	Changing	XT_TABLE	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		Table for file contents	20121119

#	Exception	Resumable	Description	Created on
1	CX_CNV_MBT_SPRD_LOAD_ERROR	☐	Error loading document	20121119
2	CX_CNV_MBT_SPRD_NOT_SUPPORTED	☐	Not supported	20121119

Method SAVE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FIELD_CATALOG	Value transfer	☑	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for List Viewer Control	20121119
2	Importing	IT_HEADER	Value transfer	☑	Type reference (TYPE)	STRING_TABLE		Header lines	20121119
3	Importing	IT_TABLE	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		Table to be written to the file	20121119
4	Importing	IV_FORMAT	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_FORMAT	CL_CNV_MBT_SPRD_WB_ODS_PRCSR=>NC_FILE_FORMAT	Workbook Format	20121119
5	Importing	IV_HEADER_LENGTH	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_HEADER_LENGTH	CL_CNV_MBT_SPRD_WORKBOOK=>NC_DEFAULT_HEADER_LENGTH	Header Length	20121119
6	Importing	IV_WORKSHEET_NAME	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_WORKSHEET_NAME	'Sheet1'	Worksheet name	20121119
7	Returning	RV_FILE	Value transfer	☐	Type reference (TYPE)	XSTRING		Resulting binary file	20121119

#	Exception	Resumable	Description	Created on
1	CX_CNV_MBT_SPRD_NOT_SUPPORTED	☐	Not supported	20121119
2	CX_CNV_MBT_SPRD_SAVE_ERROR	☐	Error saving document	20121119

History

Last changed by/on	SAP	20141030
SAP Release Created in