Delete_Rows

When Delete_Rows is selected in the General tab, the input for the activity is as follows.

Input Item Data Type Description
FilePath String Enter the absolute path for the Excel file with double quotation marks, where the specified rows in a sheet are deleted.
Note: The FilePath is not displayed when Use Process Data check box is selected on the General tab.
processData Binary Get binary data on the Input tab when Use Process Data check box is selected on the General tab.

Available only when Use Process Data check box is selected on General tab.

SheetName|SheetPointer None Select SheetName or SheetPointer to delete rows in the Excel file.
Note: Before selecting SheetName or SheetPointer, complete the following steps:
  1. Drag SheetName|SheetPointer under the Sheet node in the XPath Expression view to the Data Source view. The Drop window opens.
  2. In the Drop window, select SheetName or SheetPointer from the list. Click Finish.
SheetName String Enter the name of the sheet with double quotation marks, where the rows are deleted.
Note: If the maximum length of the sheet name is more than 31 characters, the process can run successfully and only the first 31 characters of the sheet name are used.
SheetPointer Positive integer Enter the index number of the sheet, where the rows are deleted.
StartingRowPointerToDelete Positive integer Specify the starting row pointer, where the rows start to be deleted.
Note: The value entered in this field must be greater than zero.
EndingRowPointerToDelete Integer Specify the ending row pointer, where the rows stop to be deleted.
Note: If the value in this field is -1, rows are deleted from the specified starting row to the last row in the sheet.