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 Evaluatefalse 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. NoneDE GermanEN English | selection | DE (German) |
ApplicationCustomizing Parameters
You specify the following parameters in the ApplicationCustomizing table:
| Parameter | Description | Default |
|---|---|---|
POI_Zip_Entry_Size | The maximum size of a compressed file in the ZIP archive, in MB. | 50 |
POI_Zip_Ratio | Sets the minimum inflation ratio for ZIP files. The default value of 0.01 specifies that an inflated file might be up to 100 times larger than the compressed file. Setting this to 0 allows all possible ratios. | 0.01 |
POI_Zip_Text_Size | The maximum size of a text file to be zipped, in millions of characters. | 50 |
See POI ZipSecureFile for more information.
See Also
Redwood Finance Automation Reference
financeTopic