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.
|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.