Delete_Sheets

When Delete_Sheets 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 one or multiple sheets 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.

Sheet None This node supports duplication.

You can right-click the SheetName node and click Duplicate to delete multiple sheets.

SheetName|SheetPointer None Select SheetName or SheetPointer to delete a sheet from 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 to be deleted with double quotation marks.
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 to be deleted.