Utils: Get Value from Cell in Excel Sheet

Component Name and System Landscape

• Name: FCA_SAP_Utils_Excel_Get_Cell_Value
• Description: SAP - Utils: Get value from a cell in an Excel sheet
• Application: FCA_SAP_Transactions
• Type: RedwoodScript

Brief Description

The purpose of this component is to get data from Excel files.

Parameter Mapping - Generic Tabs

There are several tabs under this section. Some will be generic, and others are specific to the component. The generic tabs usually are:

• Target: Requires SAP and Client information. You can also hard code the SAP username.
• Infrastructure: Used for Action rules. See the Redwood Finance Automation Reference.
• Recipient parameters: Generally left to default values.
• Job output parameters: Defines the format of the required output. Defaults to RTX and Text. See Porgam Handling for more information.

note

Most of the time these tabs will be shown, but there are components where these differ and either do not appear at all, or they are specific tabs.

Parameter Mapping - Specific Tabs

This guide shows the minimum parameter values required for the component to run. Please refer to the Redwood Automation Engineering Training course for submission and monitoring activities.

Tab	Technical Name	Description	Format	Mandatory Field	Example
Parameters	IN_PATH	Path to Excel	Reference to the full path of an Excel file. The Excel file can be a document or a jobfile. Within filenames wildcards (? and *) are allowed, although the result must be a single file	Location of the Excel file.	Document: doc:REDWOOD:/REDWOOD.CUS_FCA/Journal_Template.xlsx Job file: Step 2, job 1:Vendor_List_2202.xlsx Step 2, job 1:Vendor_List_${P:IO_VENDOR_ID}.xls
Parameters	IN_SHEET_NAME	Name of the sheet	Sheet name of the Excel file from which data should be read out.	string	Sheet1
Parameters	IN_CELL_REFERENCE	Cell reference	Reference of the cell(s) to obtain data from. This can be a single cell reference, a cell range or a list of cells (comma-separated) or cell ranges (semi-colon-separated).	string	Single cell: A14 Cell range(s): B:E;A14:B22 List of cells: A14,B22,B32
Parameters	IN_FORMATED	Formatting Type	Select the desired format for numbers and dates. Available options are: None S SAP Format X Excel Format	selection	X
Parameters	SKIP_EXPRESSION_EVALUATION	Skip all expression evaluation after update	Choose if expressions should be re-evaluated. true Evaluate false Skip evaluation	selection	false
Parameters	TRANSFORMATION	Transformation	Activates XSL transformation preprocessing.	selection	None
Parameters	IN_FILE_LANGUAGE	Excel File Language	Set language of Excel file to get values in correct format. None DE German EN English	selection	DE (German)

See Also

Redwood Finance Automation Reference

financeTopic