Microsoft Excel

Get Value from Cell

Fill the WorkbookName position with custom internal name of your Excel file. Put the worksheet name in appropriate textbox in properties window. Use the variable for column and variable for row (or enter the number of column and row) to specify the cell whose value will be retrieved.

Declare the variable for Value and put it in Output part of properties window – it will store found value.

 

NOTE: by default, Excel uses the A1 reference style, which refers to columns as letters (A, B, C, ...) and to rows as numbers (1, 2, 3, ...). These letters and numbers are called row and column headings.
Wizlink uses R1C1 reference style, in which both the rows and the columns on the worksheet are numbered.

You can use the R1C1 reference style in Excel (it is useful if you want to compute row and column positions in macros). In Microsoft Excel: Tools menu > Options > Formulas, and under Working with formulas check the box to allow R1C1 reference style.

v2_ex_get-from-cell
Acquired TextStringOutputtext input by user
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
ColumnInt32Inputnumber of Excel column (column numbers start from 1)
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)
RowInt32Inputnumber of Excel row (row numbers start from 1)
Workbook NameStringInputcustom internal name Wizlink will use to identify the workbook
Worksheet NameStringInputname of the Excel sheet
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 will return 1. See the table of Extended Result Codes for more info
ValueStringOutputvalue returned by activity