Import Named Range Values from Excel into Constants and Controls (DriveWorks Documentation)

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.

Named Ranges

Avoid using any merged cells as the named range.
When applying a Named Range using the Name Manager (in Microsoft Excel) it is possible to set the scope of the range to be worksheet specific. We recommend only using workbook specific ranges when setting up the Excel workbook to export into.

Microsoft Office

Ensure Microsoft Office is installed on all DriveWorks machines that will process this Task.

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.

Properties

Property Name	Description
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.

Example

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.

Example Excel File

The highlighted cells in the Excel example below have been named as follows:

Cell C1 - Customer
Cell B2 - Color
Cell D3 - Width
Cell A4 - Type
Cell E5 - Email

For information on how to name a range in Excel, please see Name a cell (Microsoft Office article).

	A	B	C	D	E
1			DriveWorks Ltd.
2		Green
3				760
4	7/16-20 UNF
5					sales@driveworks.co.uk

The DriveWorks Project these values will be imported into contains the following Constants and Controls.

Control - Customer
Control - Color
Control - Width
Constant - Type
Constant - Email

If a constant and control exist with the same name the constant will take precedence.

Status Outputs

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

Data from Excel was successfully imported

Success with Warnings

N/A - Should never be fulfilled.

Failed (one of the following occurred).

File name is empty
Target file not found or could not be accessed
Target file extension is invalid
Unknown error occurred

DriveWorks Pro 22 Import Named Range Values from Excel into Constants and Controls