Write Cell


Writes or appends a value or formula into a cell of an open Microsoft Excel Document.

Parameters

  • Document name Specifies the name of the opened/connected document.

  • Worksheet name Specifies the name of the worksheet which contains the cell to be written.

  • Position Specifies the cell to be written. The value can also be appended to the last row or column.

  • Puplate variable with row/column number Specifies a variable to store the number of new row/column when the field Position is Append to last row or Append to last column.

  • Cell Specifies the cell to be written.

  • Value to write Specifies the data to write.

  • How to write Specifies which property of the cell to be written, it can be Write value, Write forumla, Write hyperlink, Add comment.

  • When failed to write data into cell Specifies the secondary error level if gets an error during writing.

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.