Overview
Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel and CSV |
The Get Value step retrieves the value from a single cell in an Excel or CSV file. The row, column, and worksheet number are required to pull the value out of a particular cell.
Properties
Inputs
| Property | Description | Data Type | ||
|---|---|---|---|---|
| Column | The column number from the excel or CSV file. The starting value is one | Int32 | ||
| 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 | ||
| Ignore First Row | Ignores the first row in the excel file. | Boolean | ||
| Input | The excel or CSV file to pull the data from | FileData | ||
| Row | The specified Row for the Cell. The starting value is zero | Int32 | ||
| Worksheet Number | The Worksheet Number the cell is located in. The values start at zero. | Int32 | ||
Outputs
| Property | Description | Data Type | ||
|---|---|---|---|---|
| GetValue1_Output | Returns the value from the cell | String | ||
Related Forum Posts
Training Video:
Dynamic Excel Creation