SAP ABAP Class CL_CNV_MBT_SPRD_WORKSHEET (Spreadsheet Worksheet)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_MBT_SPRD (Package) Spreadsheet Upload / Download Classes

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_CNV_MBT_SPRD_TITLESHEET	Spreadsheet Title Sheet	20110825

Properties

Class	CL_CNV_MBT_SPRD_WORKSHEET
Short Description	Spreadsheet Worksheet
Super Class
Instantiability of a Class	1	Protected
Final	☐

General Data

Message Class
Program status
Category	0
Package	CNV_MBT_SPRD	Spreadsheet Upload / Download Classes
Created	20110825	SAP
Last change	20141030
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_CNV_MBT_SPRD_WORKSHEET has no forward declaration.

Interfaces

Class CL_CNV_MBT_SPRD_WORKSHEET has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_CNV_MBT_SPRD_WORKBOOK	☐	20110825	Spreadsheet Workbook

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	PT_DATA	Instance attribute	Private	☐	Type reference (TYPE)	CNV_MBT_SPRD_T_DEEP_STRINGS		Table of Table of Strings	20110825
2	PT_DATA_HEADER	Instance attribute	Private	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20110825
3	PT_HEADER	Instance attribute	Private	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20110825
4	PV_HEADER_LENGTH	Instance attribute	Private	☐	Type reference (TYPE)	CNV_MBT_SPRD_HEADER_LENGTH		Header Length	20110825
5	PV_NAME	Instance attribute	Private	☐	Type reference (TYPE)	CNV_MBT_SPRD_WORKSHEET_NAME		Worksheet name	20110825

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20110825
2	CONVERT_FROM_STRING_TABLE	Static method	Public	Method	Converts a deep string table to a flat standard table	20110829
3	CONVERT_TO_STRING_TABLE	Static method	Public	Method	Converts a flat standard table to a deep string table	20110829
4	GET_DATA	Instance method	Public	Method	Returns the data table contents	20110825
5	GET_DATA_HEADER	Instance method	Public	Method	Returns the header information for the data table	20110825
6	GET_HEADER	Instance method	Public	Method	Returns the header information	20110825
7	GET_HEADER_LENGTH	Instance method	Public	Method	Returns the number of lines reserved for the header	20110825
8	GET_NAME	Instance method	Public	Method	Returns the name of the worksheet	20110825
9	SET_DATA	Instance method	Public	Method	Set data table contents	20110825
10	SET_DATA_HEADER	Instance method	Public	Method	Set header information for the data table	20110825
11	SET_HEADER	Instance method	Public	Method	Set header information	20110825

Events

Class CL_CNV_MBT_SPRD_WORKSHEET has no event.

Types

Class CL_CNV_MBT_SPRD_WORKSHEET has no local type.

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_HEADER_LENGTH	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_HEADER_LENGTH		Header Length	20110825
2	Importing	IV_NAME	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_WORKSHEET_NAME		Worksheet name	20110825

Method CONSTRUCTOR on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

Method CONVERT_FROM_STRING_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FIELD_CATALOG	Call by reference	☐	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for List Viewer Control	20110829
2	Importing	IT_STRING_TABLE	Call by reference	☐	Type reference (TYPE)	CNV_MBT_SPRD_T_DEEP_STRINGS		Table of Table of Strings	20110829
3	Changing	XT_TABLE	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20110829

#	Exception	Resumable	Description	Created on
1	CX_CNV_MBT_SPRD_LOAD_ERROR	☐	Excel load error	20111124

Method CONVERT_TO_STRING_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FIELD_CATALOG	Call by reference	☐	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for List Viewer Control	20110829
2	Importing	IT_TABLE	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20110829
3	Returning	RT_STRING_TABLE	Value transfer	☐	Type reference (TYPE)	CNV_MBT_SPRD_T_DEEP_STRINGS		Table of Table of Strings	20110829

Method CONVERT_TO_STRING_TABLE on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

Method GET_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_DATA	Value transfer	☐	Type reference (TYPE)	CNV_MBT_SPRD_T_DEEP_STRINGS		Table of Table of Strings	20110825

Method GET_DATA on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

Method GET_DATA_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_DATA_HEADER	Value transfer	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20110825

Method GET_DATA_HEADER on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

Method GET_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_HEADER	Value transfer	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20110825

Method GET_HEADER on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

Method GET_HEADER_LENGTH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_HEADER_LENGTH	Value transfer	☐	Type reference (TYPE)	CNV_MBT_SPRD_HEADER_LENGTH		Header Length	20110825

Method GET_HEADER_LENGTH on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

Method GET_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_NAME	Value transfer	☐	Type reference (TYPE)	CNV_MBT_SPRD_WORKSHEET_NAME		Worksheet name	20110825

Method GET_NAME on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

Method SET_DATA 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)	CNV_MBT_SPRD_T_DEEP_STRINGS		Table of Table of Strings	20110825

#	Exception	Resumable	Description	Created on
1	CX_CNV_MBT_SPRD_NOT_SUPPORTED	☐	Method not supported	20110825

Method SET_DATA_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DATA_HEADER	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20110825

#	Exception	Resumable	Description	Created on
1	CX_CNV_MBT_SPRD_NOT_SUPPORTED	☐	Method not supported	20110825

Method SET_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_HEADER	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20110825

Method SET_HEADER on class CL_CNV_MBT_SPRD_WORKSHEET has no exception.

History

Last changed by/on	SAP	20141030
SAP Release Created in	2010_1_700