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.