Step Details | |
| Introduced in Version | 4.0.0 |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
Overview
The Get Worksheet Name From Index step returns the name of the worksheet based on the given numerical position of that specific sheet.
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 Index | The Worksheet Index to return the Name of the Worksheet Note: The Indexing of the worksheet starts from "Zero." | Int32 |
Outputs
| Property | Description | Data Type |
|---|---|---|
| Output | The name of the specified worksheet in the file. | String |
Related Forum Posts
Training Video:
Dynamic Excel Creation