SAP ABAP Class CL_LXE_TEXTEXT_EXCEL_OLE (OLE access)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DOC-TTL (Application Component) Translation Tools
     ⤷ SLXE_EX (Package) Externalization of ABAP texts

Properties

Class	CL_LXE_TEXTEXT_EXCEL_OLE
Short Description	OLE access
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SLXE_EX	Externalization of ABAP texts
Created	20110401	SAP
Last change	20110908	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_LXE_TEXTEXT_EXCEL_OLE has no forward declaration.

Interfaces

Class CL_LXE_TEXTEXT_EXCEL_OLE has no interface implemented.

Friends

Class CL_LXE_TEXTEXT_EXCEL_OLE has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	EXCEL	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT		Excel Application	20110401

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	EXCEL_APPLICATION_CLOSE	Instance method	Private	Method		20110401
2	EXCEL_APPLICATION_CREATE	Instance method	Private	Method		20110401
3	EXCEL_ASSIGN_CELL	Instance method	Private	Method		20110401
4	EXCEL_CHECK_CELL_MERGED	Instance method	Private	Method		20110401
5	EXCEL_CLOSE_WORKBOOK	Instance method	Private	Method		20110401
6	EXCEL_CREATE_WORKSHEET	Instance method	Private	Method		20110401
7	EXCEL_FREEZE_FIRST_ROW	Instance method	Private	Method		20110401
8	EXCEL_GET_CELL_VALUE	Instance method	Private	Method		20110401
9	EXCEL_MERGE_OBJNAME_CELLS	Instance method	Private	Method		20110401
10	EXCEL_OPEN_WORKSHEET	Instance method	Private	Method		20110401
11	EXCEL_PROTECT_SHEET	Instance method	Private	Method		20110401
12	EXCEL_QUIT	Instance method	Private	Method		20110401
13	EXCEL_READ_DATA	Instance method	Private	Method		20110401
14	EXCEL_SAVE_QUIT	Instance method	Private	Method		20110401
15	EXCEL_SET_COL_WIDTH	Instance method	Private	Method		20110401
16	EXCEL_WRITE_DATA	Instance method	Private	Method		20110401
17	EXCEL_WRITE_HEADER	Instance method	Private	Method		20110401
18	IMPORT_EXCEL	Instance method	Private	Method		20110401
19	WRITE_EXCEL	Instance method	Private	Method		20110401

Events

Class CL_LXE_TEXTEXT_EXCEL_OLE has no event.

Types

Class CL_LXE_TEXTEXT_EXCEL_OLE has no local type.

Method Signatures

Method EXCEL_APPLICATION_CLOSE Signature

Method EXCEL_APPLICATION_CLOSE on class CL_LXE_TEXTEXT_EXCEL_OLE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_APPLICATION_CREATE Signature

Method EXCEL_APPLICATION_CREATE on class CL_LXE_TEXTEXT_EXCEL_OLE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_ASSIGN_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_BOLD	Call by reference	☑	Type reference (TYPE)	LXEBOOL		Text	20110401
2	Importing	I_BORDER	Call by reference	☑	Type reference (TYPE)	LXEBOOL		Boolean	20110401
3	Importing	I_COLOR	Call by reference	☑	Type reference (TYPE)	INT4		Natural number	20110401
4	Importing	I_COLUMN	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20110401
5	Importing	I_ROW	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20110401
6	Importing	I_UNLOCK	Call by reference	☑	Type reference (TYPE)	LXEBOOL		Boolean	20110401
7	Importing	I_VALUE	Call by reference	☐	Type reference (TYPE)	LXESTRING		Text	20110401
8	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_CHECK_CELL_MERGED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ROW	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20110401
2	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401
3	Returning	R_MERGED	Value transfer	☐	Type reference (TYPE)	LXEBOOL		Boolean	20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_CLOSE_WORKBOOK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_WORKBOOK	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_CREATE_WORKSHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_WORKBOOK	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401
2	Exporting	E_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401
3	Importing	I_T_LANG	Call by reference	☐	Type reference (TYPE)	LXEISOLANG		ISO Language ID	20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_FREEZE_FIRST_ROW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_WORKBOOK	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_GET_CELL_VALUE 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)	LXESTRING		Text	20110401
2	Importing	I_COLUMN	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20110401
3	Importing	I_ROW	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20110401
4	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_MERGE_OBJNAME_CELLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ROW	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20110401
2	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_OPEN_WORKSHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_WORKBOOK	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401
2	Exporting	E_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401
3	Importing	I_FILEPATH	Call by reference	☐	Type reference (TYPE)	LXESTRING		Text	20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_PROTECT_SHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_QUIT Signature

Method EXCEL_QUIT on class CL_LXE_TEXTEXT_EXCEL_OLE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_READ_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_OBJECTS	Call by reference	☐	Type reference (TYPE)	CL_LXE_TEXTEXT_AUX=>TT_LXE_OBJECT_FULL		Full text information (short texts)	20110401
2	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_SAVE_QUIT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FILE_SUFFIX	Call by reference	☐	Type reference (TYPE)	LXESTRING		Text	20110401
2	Importing	I_T_LANG	Call by reference	☐	Type reference (TYPE)	LXEISOLANG		ISO Language ID	20110401
3	Importing	I_WORKBOOK	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401
4	Returning	R_FILENAME	Value transfer	☐	Type reference (TYPE)	LXEEXPFILENAME		File Name	20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_SET_COL_WIDTH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_WRITE_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_OBJECTS	Call by reference	☐	Type reference (TYPE)	CL_LXE_TEXTEXT_AUX=>TT_LXE_OBJECT_FULL		Full text information (short texts)	20110401
2	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method EXCEL_WRITE_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_WORKSHEET	Call by reference	☐	Type reference (TYPE)	OLE2_OBJECT			20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method IMPORT_EXCEL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FILES	Call by reference	☐	Type reference (TYPE)	LXE_TT_LXESTRING		Table type for strings	20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

Method WRITE_EXCEL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_OBJECTS	Call by reference	☐	Type reference (TYPE)	CL_LXE_TEXTEXT_AUX=>TT_LXE_OBJECT_FULL		Full text information (short texts)	20110401
2	Importing	I_FILE_SUFFIX	Call by reference	☐	Type reference (TYPE)	LXESTRING		Text	20110401
3	Importing	I_T_LANG	Call by reference	☐	Type reference (TYPE)	LXEISOLANG		ISO Language ID	20110401
4	Returning	R_FILENAME	Value transfer	☐	Type reference (TYPE)	LXEEXPFILENAME		File Name	20110401

#	Exception	Resumable	Description	Created on
1	CX_LXE_TEXTEXT	☐		20110401

History

Last changed by/on	SAP	20110908
SAP Release Created in	731