Get Formula Value
- 09 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Get Formula Value
- Updated on 09 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
Step Details | |
| Introduced in Version | 5.0.0 |
| Last Modified in Version | 5.0.0 |
| Location | Data > Excel and CSV |
The Get Formula Value step accepts an Excel file where the user selects the worksheet, row(s), and column(s) where the formula to modify resides and then provides its new values as a String.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| Input File | The excel or CSV file to pull the data from | FileData |
| File Type | The type of file being used by the step. The step currently supports CSV, Excel_xls, or Excel_xlsx. Use Constant mapping to view the drop-down | CsvFileType |
| Worksheet Number | The Worksheet Number the cell is located in. The values start at zero. | Int32 |
| Row | The specified Row for the Cell. The starting value is zero | Int32 |
| Column | The specified column for the cell | Int32 |
Outputs
| Property | Description | Data Type |
|---|---|---|
| Output | Returns the formula value from the cell | String |
Related Forum Posts
Was this article helpful?
