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.
|Title||Changes the Title (not the name) of the task.|
|File Name||File Name of the Excel File Including Extension.|
|Sheet Name||Sheet to pull the data from|
|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.|
The Excel sheet used for the import is to have a minimum of two columns:
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:
|ClevisOption||Universal Clevis||No Clevis||Clevis Adapter|