SAP ABAP Class CL_UA_EXCEL_TOOLS (Access to MS Excel)

Hierarchy

☛ SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
   ⤷ FIN-BA (Application Component) Business Analytics
     ⤷ UA_TOOLBOX (Package) Useful Bits

Properties

Class	CL_UA_EXCEL_TOOLS
Short Description	Access to MS Excel
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class	UA_EXCEL_TOOLS
Program status
Category	0
Package	UA_TOOLBOX	Useful Bits
Created	20020805	SAP
Last change	20050705	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	OLE2	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_UA_EXCEL_TOOLS has no interface implemented.

Friends

Class CL_UA_EXCEL_TOOLS has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CNT_OBJTYPE	Constant	Private	☐	Type reference (TYPE)	BORIDENT-OBJTYPE	'BUS1154'	Object Type	20020906
2	GO_EXCEL	Static Attribute	Protected	☐	Type reference (TYPE)	OLE2_OBJECT			20020805
3	GO_WORKBOOKS	Static Attribute	Protected	☐	Type reference (TYPE)	OLE2_OBJECT			20020805
4	GT_MEMORY	Static Attribute	Protected	☐	Type reference (TYPE)	UAC_T_EXCEL_MEMORY		Table to Manage Excel Files	20020805

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	READ_AMOUNT_FROM_ANNOTATION	Static method	Public	Method	Read Amount from Connected File	20050616
2	READ_AMOUNT_FROM_LOCAL_FILE	Static method	Public	Method	Read Amount from a Local File	20050616
3	READ_CELL_FROM_ANNOTATION	Static method	Public	Method	Read cell contents from connected file	20020904
4	READ_CELL_FROM_LOCAL_FILE	Static method	Public	Method	Read Cell Contents from a Local File	20020805
5	READ_CELL_FROM_LOCAL_FILE_INT	Static method	Private	Method	Read Cell Contents from a Local File	20020906
6	READ_QUANTITY_FROM_ANNOTATION	Static method	Public	Method	Read Quantity from Connected File	20050616
7	READ_QUANTITY_FROM_LOCAL_FILE	Static method	Public	Method	Read Quantity from Local File	20050616

Events

Class CL_UA_EXCEL_TOOLS has no event.

Types

Class CL_UA_EXCEL_TOOLS has no local type.

Method Signatures

Method READ_AMOUNT_FROM_ANNOTATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ES_AMNT	Value transfer	☐	Type reference (TYPE)	UAB_S_AMNT		Kosten	20050616
2	Importing	ID_ALIAS	Call by reference	☑	Type reference (TYPE)	UAB_NAME		Aliasname	20050616
3	Importing	ID_CELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Zelle	20050616
4	Importing	ID_CURRCELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Zelle für Währung	20050616
5	Importing	ID_CURRENCY	Call by reference	☑	Type reference (TYPE)	FINB_CURRENCY		Währung	20050616
6	Importing	ID_FILE	Call by reference	☑	Type reference (TYPE)	UAB_EXCELFILE		Excel-Datei	20050616
7	Importing	ID_OBJECT_ID	Call by reference	☐	Type reference (TYPE)	UAB_ID		Objekt-ID	20050616
8	Importing	ID_SHEET	Call by reference	☑	Type reference (TYPE)	UAB_EXCELSHEET		Arbeitsblatt	20050616

#	Exception	Resumable	Description	Created on
1	CX_UA_FORMULA_EXCEPTION	☐		20050616

Method READ_AMOUNT_FROM_LOCAL_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ES_AMNT	Value transfer	☐	Type reference (TYPE)	UAB_S_AMNT		Kosten	20050616
2	Importing	ID_ALIAS	Call by reference	☑	Type reference (TYPE)	UAB_NAME		Aliasname	20050616
3	Importing	ID_CELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Excelzelle	20050616
4	Importing	ID_CURRCELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Excelzelle für Währung	20050616
5	Importing	ID_CURRENCY	Call by reference	☑	Type reference (TYPE)	FINB_CURRENCY		Währung	20050616
6	Importing	ID_PATH	Call by reference	☐	Type reference (TYPE)	RSPOFILE		Dateiname mit Pfad	20050616
7	Importing	ID_SHEET	Call by reference	☑	Type reference (TYPE)	UAB_EXCELSHEET		Excelsheet	20050616

#	Exception	Resumable	Description	Created on
1	CX_UA_FORMULA_EXCEPTION	☐		20050616

Method READ_CELL_FROM_ANNOTATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ED_VALUE	Value transfer	☐	Type reference (TYPE)	UAB_TEXT		Zellenwert	20020904
2	Importing	ID_ALIAS	Call by reference	☑	Type reference (TYPE)	UAB_NAME		Aliasname	20020917
3	Importing	ID_CELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Zelle	20020904
4	Importing	ID_FILE	Call by reference	☑	Type reference (TYPE)	UAB_EXCELFILE		Excel-Datei	20020920
5	Importing	ID_OBJECT_ID	Call by reference	☐	Type reference (TYPE)	UAB_ID		Objekt-ID	20050616
6	Importing	ID_SHEET	Call by reference	☑	Type reference (TYPE)	UAB_EXCELSHEET		Arbeitsblatt	20020904

#	Exception	Resumable	Description	Created on
1	CX_UA_FORMULA_EXCEPTION	☐		20050616

Method READ_CELL_FROM_LOCAL_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ED_VALUE	Value transfer	☐	Type reference (TYPE)	UAB_TEXT		Zellenwert	20020805
2	Importing	ID_ALIAS	Call by reference	☑	Type reference (TYPE)	UAB_NAME		Aliasname	20020917
3	Importing	ID_CELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Excelzelle	20020805
4	Importing	ID_PATH	Call by reference	☐	Type reference (TYPE)	RSPOFILE		Dateiname mit Pfad	20020805
5	Importing	ID_SHEET	Call by reference	☑	Type reference (TYPE)	UAB_EXCELSHEET		Excelsheet	20020805

#	Exception	Resumable	Description	Created on
1	CX_UA_FORMULA_EXCEPTION	☐		20050616

Method READ_CELL_FROM_LOCAL_FILE_INT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ED_UNIT	Value transfer	☐	Type reference (TYPE)	UASTRING			20050616
2	Exporting	ED_VALUE	Value transfer	☐	Type reference (TYPE)	UASTRING			20020906
3	Importing	ID_ALIAS	Call by reference	☑	Type reference (TYPE)	UASTRING			20020917
4	Importing	ID_CELL	Call by reference	☑	Type reference (TYPE)	UASTRING			20020906
5	Importing	ID_PATH	Call by reference	☐	Type reference (TYPE)	UASTRING			20020906
6	Importing	ID_SHEET	Call by reference	☑	Type reference (TYPE)	UASTRING			20020906
7	Importing	ID_UNITCELL	Call by reference	☑	Type reference (TYPE)	UASTRING			20050616

#	Exception	Resumable	Description	Created on
1	CX_UA_FORMULA_EXCEPTION	☐		20050616

Method READ_QUANTITY_FROM_ANNOTATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ES_QNTY	Value transfer	☐	Type reference (TYPE)	UAB_S_QNTY		Menge mit Einheit	20050616
2	Importing	ID_ALIAS	Call by reference	☑	Type reference (TYPE)	UAB_NAME		Aliasname	20050616
3	Importing	ID_CELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Zelle	20050616
4	Importing	ID_FILE	Call by reference	☑	Type reference (TYPE)	UAB_EXCELFILE		Excel-Datei	20050616
5	Importing	ID_OBJECT_ID	Call by reference	☐	Type reference (TYPE)	UAB_ID		Objekt-ID	20050616
6	Importing	ID_SHEET	Call by reference	☑	Type reference (TYPE)	UAB_EXCELSHEET		Arbeitsblatt	20050616
7	Importing	ID_UNIT	Call by reference	☑	Type reference (TYPE)	FINB_UNIT		Einheit	20050616
8	Importing	ID_UNITCELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Zelle für Einheit	20050616

#	Exception	Resumable	Description	Created on
1	CX_UA_FORMULA_EXCEPTION	☐		20050616

Method READ_QUANTITY_FROM_LOCAL_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ES_QNTY	Value transfer	☐	Type reference (TYPE)	UAB_S_QNTY		Menge mit Einheit	20050616
2	Importing	ID_ALIAS	Call by reference	☑	Type reference (TYPE)	UAB_NAME		Aliasname	20050616
3	Importing	ID_CELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Excelzelle	20050616
4	Importing	ID_PATH	Call by reference	☐	Type reference (TYPE)	RSPOFILE		Dateiname mit Pfad	20050616
5	Importing	ID_SHEET	Call by reference	☑	Type reference (TYPE)	UAB_EXCELSHEET		Excelsheet	20050616
6	Importing	ID_UNIT	Call by reference	☑	Type reference (TYPE)	FINB_UNIT		Einheit	20050616
7	Importing	ID_UNITCELL	Call by reference	☑	Type reference (TYPE)	UAB_EXCELCELL		Excelzelle für Einheit	20050616

#	Exception	Resumable	Description	Created on
1	CX_UA_FORMULA_EXCEPTION	☐		20050616

History

Last changed by/on	SAP	20050705
SAP Release Created in	320