Purpose
Gets the name of all the worksheets in a given Excel file.
Description
The Get Sheet Names component gets the name of all the worksheets present in a given Excel file. In the given example, the Get Sheet Names component is designed to get the name of all the worksheets available in the AccountsMasterFile.
Properties
|
Property |
Data Type |
Description |
|---|---|---|
|
General |
|
|
|
Display Name |
-NA- |
Display name of the component. |
|
Enable Pause |
-NA- |
Option to pause the activity (related to the component) during a job execution after receiving a pause control signal from the Cockpit application. The checkbox is selected by default. |
|
Misc |
|
|
|
Enable Bookmark |
-NA- |
Option to set a bookmark. |
|
Is Reserved |
-NA- |
Option to disable data tracing related to the component. |
|
Output |
|
|
|
Sheet Names* |
List of names of the worksheets available in the given Excel workbook. |
|
|
Note: The property names marked with * sign are the mandatory properties. |
||
