Fill Data Range
Fill the data into an excel sheet.
Last updated
Fill the data into an excel sheet.
Last updated
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 : 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.