Get Range

This activity gets all cell values from an indicated range of data and attributes it to a variable declared for Values. Fill the WorkbookName position with custom internal name of your Excel file. Put the worksheet name in appropriate textbox in properties window. Determine the limits of data range (top and bottom rows, and left and right columns).

For merged cells in Excel: the top-left cell of a range returns the value, all other cells returns an empty string.

Acquired Text	String	Output	text input by user
Alternative Scenario If Failed	Boolean	Input	checkbox; default is "on"
Bottom Row	Int32	Input	row number in Excel (bottom boundary of the area)
Display Name	Literal	Input	changes display name of the activity
Exclude from Transaction Check	Boolean	Input	checkbox; default is "off"
Left Column	Int32	Input	column number in Excel (left border of the area)
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)
Right Column	Int32	Input	column number in Excel (right border of the area)
Top Row	Int32	Input	row number in Excel (upper boundary)
Workbook Name	String	Input	custom internal name Wizlink will use to identify the workbook
Worksheet Name	String	Input	name of the Excel sheet
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
Values	String[][]	Output	values retrived from Excel sheet