Microsoft Excel

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.

v2_ex_get-range
Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Bottom RowInt32Inputrow number in Excel (bottom boundary of the area)
Display NameLiteralInputyou can change the name of activity for greater clarity of the scenario
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
Left ColumnInt32Inputcolumn number in Excel (left border of the area)
Retry timeout [s]DoubleInputwaiting time until the activity will execute: 1. any negative value means try once, if you fail – set Result to False and finish activity; 2. “0” means try until you get the effect; 3. any positive value is time in seconds in which the activity will persist trying until successful or the time elapses, if failed – set Result to False and finish activity
Right ColumnInt32Inputcolumn number in Excel (right border of the area)
Top RowInt32Inputrow number in Excel (area upper boundary)
Workbook NameStringInputcustom internal name for Excel file, in order to identify Excel workbook in Wizlink
Worksheet NameStringInputname of the Excel sheet
ResultBooleanOutputreturns the Boolean value: it will return True if no error is in activity, otherwise it 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
ValuesString[][]Outputvalues retrived from Excel sheet