Step Details | |
| Introduced in Version | 5.0.0 |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel and CSV |
Overview
The Get Worksheet Index From Name step returns the numerical position of a worksheet based on the given worksheet name.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File Type | The type of file being used by the step. The step supports Excel_xls and Excel_xlsx file types only. Use Constant mapping to view the drop-down. | CsvFileType |
| Input | Excel file to pull the data from. | FileData |
| Worksheet Name | The Worksheet Name to return the Index of the Worksheet | String |
Outputs
| Property | Description | Data Type |
|---|---|---|
| Output | Returns the Index of the Sheet. Note: The Indexing of the worksheet starts from "Zero." | Int32 |
Related Forum Posts
Training Video:
Dynamic Excel Creation