Fill Data Range

Fill the data into an excel sheet.

Fills the given input in all the cells in the specified cell range in an excel sheet.

This activity can only be used after the Open Excel File activity.

Input

• Input : ExcelHandle Argument A variable name that references the opened excel filehandle.
• Sheet Name : String Argument The name of the sheet in which the data is to be filled.
• Range : String Argument The range of the sheet in which the data is to be filled.

If the range is specified as A1:E10 then the activity will select all cells of the first five columns from rows 1 to 10.

• Fill Data : Object Argument Specifies the data that are to be filled in the cells of the specified range.

The Fill Data property can have inputs of type Double, String, Int, or DateTime.