Microsoft Excel

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.

getworksheets1
getworksheets.2
Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display NameLiteralInputchanges display name of the activity
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
Retry Timeout [s]DoubleInputdetermines 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)
Workbook NameStringInputcustom internal name Wizlink will use to identify the workbook
ResultBooleanOutputreturns a Boolean value. True if no error in activity, otherwise will return False
Result CodeInt32OutputResult Code will return 0 if there is no error in activity, otherwise in most cases it will return 1, the extended result code will show only in several chosen activities
Worksheets ListString[]Outputarray of worksheet names in Excel workbook