DriveWorks Pro 15: Import Multi Column Named Sheet from Excel into Constants and Controls [send feedback...]

Import Multi Column Named Sheet from Excel into Constants and Controls

This Specification Flow Task reads in multiline, multi column data from a named sheet in an Excel file, and passes them into the specification for driving into constants or controls.

Import Multi Column Named Sheet from Excel into Constants and Controls Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
File NameFile Name of the Excel File Including Extension.
Sheet NameSheet to pull the data from
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.

Example Data

The Excel sheet used for the import is to have a minimum of two columns:

  • The first column contains the name of the constant or control (do not include the DWConstant prefix or the Return suffix).
  • The remaining columns contain the values to be passed into the constant or control.

If a constant is found with the same name (Not case sensitive) then the value from the remaining columns will be passed into it as a pipe bar delimited text string.

If no constant is found with that name, then DriveWorks will look for a form control with that name to pass the value to.

If no control is found, then no action will be taken with that rows data.

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

The sheet needs headers in the first row, which need to be in the format:

NameValue1Value2Value3
OverallLength485679952
ClevisOptionUniversal ClevisNo ClevisClevis Adapter
TotalPrice$253.75$206.50$375.80

Table of Contents