Get Worksheets
Activity lists all worksheets of an Excel file identified by Workbook Name.
Activity returns Array of <String> (System.String[]) with a list of all worksheet names.
| Name | Type | Category | Description |
|---|---|---|---|
| Workbook Name | String | Input | custom internal name Wizlink will use to identify the workbook |
| Retry Timeout [s] | Double | Input | determines behaviour if the activity fails to execute. value < 0: try executing once, 0: try indefinitely; value >0: time in seconds during which the activity repeatedly tries to execute (if time elapses without success then Result = False, end activity) |
| Alternative Scenario If Failed | Boolean | Misc | checkbox; default is "on" |
| Display Name | Literal | Misc | changes display name of the activity |
| Exclude from Transaction Check | Boolean | Misc | checkbox; default is "off" |
| Worksheets List | String[] | Output | array of worksheet names |
| Result | Boolean | Output | returns a Boolean value. True if no error in activity, otherwise will return False |
| Result Code | Int32 | Output | Result Code will return 0 if there is no error in activity, otherwise in most cases will return 1. See the table of Extended Result Codes for more info |