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|
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 with Warnings
Failed (one of the following occurred).