Microsoft Excel

Set Range

This activity sets data attributed to a variable (name: Values, type: two-dimensional array) into cells of an Excel sheet.

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 colums). Choose type of data that will be pasted to cells (the same type for all cells in range). The options are: String, Number, Formula A1, Formula R1C1, Raw data. When it comes to merged cells in Excel: the value will be written in top-left cell of the merged range, writing in other cells of the merged range will do nothing (and Wizlink reports no error).

NOTE: if size of a source array and the range in Excel are different, the activity ends with an error.

v2_ex_set-range
Acquired TextStringOutputtext input by user
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Bottom RowInt32Inputrow number in Excel (bottom boundary of the area)
Display NameLiteralInputchanges display name of the activity
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
Format MaskStringInputcustom numeric, date and time format, e.g. ##0.00 (1234.56), ##0 (1235); dd/MM/yyyy (01/01/2021), d/MMM/yy (1/Jan/21)
Left ColumnInt32Inputcolumn number in Excel (left border of the area)
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)
Right ColumnInt32Inputcolumn number in Excel (right border of the area)
Top RowInt32Inputrow number in Excel (upper boundary)
ValuesString[][]Inputvalues pasted into Excel sheet
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