Replace the cell value.
Replace the value of an Excel cell with specified cell value.
This activity can only be used after the Open Excel File activity.
The cell that is to be replaced shouldn't have a null value for .xls file inputs.
Last updated
Input : ExcelHandle Variable
A variable name that references the opened excel file handle.
Sheet Name : String Argument
The name of the sheet in which the cell data is to be replaced.
Cell : String Argument
The name of the cell that is to be replaced.
Cell Value : Object Argument
The new cell value that is to be used for replacement. The property accepts String, Integer, DateTime, Double and Boolean inputs.
