This Specification Task reads in all data found in named ranges in an Excel file and passes them into the Specification for driving into Constants or Controls.
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.
|Title||Changes the Title (not the name) of the task.|
|File Name||File Name of the Excel File Including Extension.|
|Show Excel||Workbook will be visible if set to True.|
|Return Constant||The name of the Constant that the named pairs will be posted to for reference.|
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|
|File Name||"C:\MyDocuments\ImportExcel.xlsx"||C:\MyDocuments\ImportExcel.xlsx||This is the Full File Path including extension for the Excel File to import the Range values for the Constants and Controls.|
|Show Excel||TRUE||TRUE||TRUE will show the Excel workbook opening when you run the Task.|
|Return Constant||"ImportReport"||ImportReport||This is the name of the Constant that the Task will report to.|
The highlighted cells in the Excel example below have been named as follows:
For information on how to name a range in Excel, please see Name a cell (Microsoft Office article).
The DriveWorks Project these values will be imported into contains the following Constants and Controls.
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 with Warnings
Failed (one of the following occurred).