|
Write EXCEL Document Cell
Writes the value or formula into a cell of an opened Microsoft Excel Document.
Click here to show the figure
Parameters
-
Document name Specifies the document for modifying, the document should be opened by the instruction "Open Document" without the option "Read-only" checked before this step.
-
Worksheet name Specifies the name of the worksheet which contains the cell to be written.
-
Column of cell Specifies the column of the cell, the column should be in range from 'A' to 'IV'.
-
Row of cell Specifies the row number of the cell, the number should be in range from 1 to 65535.
-
Value to write Specifies the data to write.
-
Write as formula Specifies whether to write into the cell as either the value or the formula.
-
When failed to write data into cell Specifies the secondary error level if gets an error during writing. It would be the option follwing:
1¡¢Generate a waring message, and then goto the next step.
2¡¢Generate an error message, and then stop the play or goto the next step according to the setting of error handle of this step.
 Note:
Microsoft Excel program must be present in the computer before playing a macro which contains this instruction.
|
