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 |
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