This specification task deletes a specified list of Excel Worksheets from a provided Microsoft Excel Workbook.
Microsoft Office
Microsoft Office and DriveWorks Live running as a service through IIS
Services (IIS) do not have access to many applications, especially COM programs such as Microsoft Word and Excel.
When using DriveWorks Live and IIS please read the following articles for information on where to place this Task.
| Property Name | Description |
|---|---|
| Title | Changes the title (not the name) of the task. |
| Path to Workbook | The path to the workbook (including the workbook file). |
| Sheet Names | A single columned table array of sheet names to delete. |
When this Task is added the properties are static. To be able to build rules on a static property see How To: Change A Static Property To A Dynamic Property.
| Property Name | Example Rule | Example Result | Meaning |
|---|---|---|---|
| Path to Workbook | "D:\Book1.xlsx" | D:\Book1.xlsx | This will modify the workbook located at D:\Book1.xlsx. |
| Sheet Names | {"";"sheet1";"sheet2"} | {"";"sheet1";"sheet2"} | This will delete the sheets specified, header is not included. |
Sheet Names Property
An easy method of creating a single column array is to use the TableFromList function.
This task has different types of Outputs. For more information about Outputs see Specification Macros Task Node.
Outputs are only available within Specification Macros. Currently Outputs are not available for Specification Flow.
This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.
The status output navigation is as follows:
Success
Success with Warnings
Failed (one of the following occurred).