Delete Row Column

Delete the row or column of excel sheet.

Delete Row or Column with a specified column name or row index in the workbook. It can only be used after the Open Excel File activity.

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 sheet name of the workbook from which the row or column is to be deleted.

• Delete Type :

  • Row - Delete the specified row in the excel sheet. Default

  • Column - Delete the specified column in the excel sheet.

• Row Column Number : Integer Argument The row or column number to be deleted.

• Shift : Boolean Argument

  shift columns to left and shift rows to up when select true. the rows and columns will not be shifted if it selects false.