DriveWorks Pro 16: Import Named Range Values from Excel into Constants and Controls [send feedback...]

Import Named Range Values From Excel Into Constants And Controls

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.


Property NameDescription
TitleChanges the Title (not the name) of the task.
File NameFile Name of the Excel File Including Extension.
Show ExcelWorkbook will be visible if set to True.
Return ConstantThe 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 properties see How To: Change A Static Property To A Dynamic Property.

Property NameExample RuleExample ResultMeaning
File Name"C:\MyDocuments\ImportExcel.xlsx"C:\MyDocuments\ImportExcel.xlsxThis is the Full File Path including extension for the Excel File to import the Range values for the Constants and Controls.
Show ExcelTRUETRUETRUE will show the Excel workbook opening when you run the Task.
Return Constant"ImportReport"ImportReportThis is the name of the Constant that the Task will report to.

Table of Contents