Utils: Set Value of Cell in Excel Sheet
Component Name and System Landscape
- Name: FCA_SAP_Utils_Excel_Set_Cell_Value
- Description: SAP - Utils: Set the value of a cell in an Excel sheet
- Application: FCA_SAP_Transactions
- Type: RedwoodScript
Brief Description
The purpose of this component is to populate data into Excel cells.
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. Location of file that needs to be populated. | Can be Doc file, Jobfile or file reference (shared drive) | Yes | doc:REDWOOD:/REDWOOD.CUS_FCA/NS_Journal_Template.xlsx |
| Parameters | OUT_PATH | Path to result excel. | Location of file after population. | jobfile:file.xlsx | |
| Parameters | IN_SHEET_NAME | Name of the sheet. | Name of the excel tab that needs populating. | Journal | |
| Parameters | IN_CELL_REFERENCE | Cell reference. | Can be a single cell or a list of cells (separated by a colon), multiple ranges can be specified separated by semi-colons. | Yes | B15:E16 |
| Parameters | IN_VALUE | Values. | Values are sequenced in the same order as per the excel columns. Semi-colon puts values in separate cells on the same line. Pipe symbol starts a new line. | 100;Test Account; 10;0|105;Test Account; 0;-10 | |
| Parameters | IN_FORMATTED | Formatting type | |||
| Parameters | SKIP_EXPRESSION_EVALUATION | Skip all expression evaluation after update | Defaults to false | Yes | |
| Parameters | IN_TRANSFORMATION | Transformation |
See Also
Redwood Finance Automation Reference
financeTopic