Delete Row Column
Delete the row or column of excel sheet.
Last updated
Delete the row or column of excel sheet.
Last updated
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.
Input : A variable name that references the opened excel file handle.
Sheet Name : 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 : The row or column number to be deleted.
Shift :
shift columns to left and shift rows to up when select true
. the rows and columns will not be shifted if it selects false
.