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.
| Parameter Name | Parameter Type | In/Out | Description |
|---|---|---|---|
| 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 | you can change the name of activity for greater clarity of the scenario |
| Exclude from Transaction Check | Boolean | Input | checkbox; default is "off" |
| Format Mask | String | Input | custom 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 Column | Int32 | Input | column number in Excel (left border of the area) |
| Retry timeout [s] | Double | Input | waiting 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 Column | Int32 | Input | column number in Excel (right border of the area) |
| Top Row | Int32 | Input | row number in Excel (area upper boundary) |
| Values | String[][] | Input | values pasted into Excel sheet |
| Workbook Name | String | Input | custom internal name for Excel file, in order to identify Excel workbook in Wizlink |
| Worksheet Name | String | Input | name of the Excel sheet |
| Result | Boolean | Output | returns the Boolean value: it will return True if no error is in activity, otherwise it will return False |
| Result Code | Int32 | Output | Result 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 |