Insert Row
Insert a row into an excel sheet.
Last updated
Insert a row into an excel sheet.
Last updated
Insert a row with values into a specified row index in the excel sheet.
This activity can only be used after the Open Excel File activity.
Input : ExcelHandle Variable
A variable name that references the opened excel filehandle.
Sheet Name : String Argument
The name of the sheet in which the row of data is to be inserted.
Number Format : The number format of the row in which the data is to be inserted.
Auto - set number format of the cell as the exact format of the given input.
Number - set number format of the cell as the number in which data is to be inserted.
Date - set number format of the cell as the date on which data is to be inserted.
Text - set number format of the cell as the text in which data is to be inserted.
Row Data : Object Argument
Required
The variable that contains row values is a list of objects to be inserted.
Insert Row activity accepts input from Read Row activity