Insert Row

Insert a row into an excel sheet.

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

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

Options

• 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