DriveWorks Pro 15: Export/Calculate/Import To and From Named Sheets in Excel [send feedback...]

Export/Calculate/Import To and From Named Sheets in Excel

This Specification Flow Task will look for the text in the first column of a specified input sheet.

If the project has a variable with the same name, it will take the variable result and insert it in the second column for each one found.

It will then calculate the sheet and also run a macro called CreateReports if it exists.

It will then read the data from a two column multi row output sheet, and pass it into the specification for driving into constants or controls.

Export/Calculate/Import To and From Named Sheets in Excel Properties

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.
Input Sheet NameSheet name of the inputs sheet.
Output Sheet NameSheet name of the outputs sheet.
Constant NameConstant into which the input and output count will be stored.

Example Data

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

  • The first column contains the name of the variable (do not include the DWVariable prefix).
  • The second column is where the value of the variable will be imported.

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

NameValue
Variable1
Variable2
Variable3

The Excel sheet used for the export is to have two columns:

  • The first column contains the name of the constant or control (do not include the DWConstant prefix or the Return suffix).
  • The second column contains the value 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 second column will be passed into it.

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:

NameValue
OverallLength485
ClevisOptionUniversal Clevis
TotalPrice$253.75

Table of Contents