Deletes a specified sheet from an Excel file. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.
- Select sheet - Click Plus on the right side of the field and then, from the menu, select the file and then the sheet to delete. If you select Indicate in Excel, you can select any cell or range from the sheet you want to delete directly from the file. Alternatively, you can select Custom Input to enter the sheet name manually, or Open in Advanced Editor to enter a VB expression.
- DisplayName - The name displayed for the activity in the Designer panel.
- Select sheet - See Select sheet in the body of the activity.
- Private - If selected, the data used in the activity is not logged by StudioX.
Updated about a year ago