Replace Cell

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.

Input

• 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.

The cell that is to be replaced shouldn't have a null value for .xls file inputs.

• 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.