|
Write Array to Cell
Writes or appends the contents of an array to an Excel sheet. Compared with the action "Write Cell", this action can write a lot of data at one time and has better performance.
Parameters
-
Document name Specifies the name of the opened/connected document.
-
Worksheet Specifies the worksheet which contains the starting cell to be written.
-
Position Specifies the starting cell to write to.
-
Array name Specifies the name of the array.
-
Set property Specifies which property of the cell is set using the data, it can be value, forumla, hyperlink, comment, array forumla.
-
Puplate variable with row number of last cellSpecifies a variable to receive the row number of the last cell.
-
Puplate variable with column of last cellSpecifies a variable to receive the column of the last cell.
 Notes
The document must be opened by the instruction "Open Document" or "Create a Microsoft Excel Document" , or be connected by the instruction "Connect an Open Document" before this step.
Microsoft Excel program must be present in the computer before playing a macro which contains this action.
|
