Home Search

DriveWorks Pro 21
Export Control Values To Named Sheet In Excel

Send Feedback

Export Control Values To Named Sheet in Excel

This Specification Flow Task will recurse all forms in a Project and all Controls on each Form. For Controls that can have their values set by the user, these values are exported to a named sheet in an Excel file as 2 column data with each row being Name, Value.

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 NameDescription
TitleChanges the Title (not the name) of the task.
Source File NameFile Name of the source (template) spreadsheet.
Target File NameFile Name of the target (new) spreadsheet.
Target Sheet NameThe sheet name in the spreadsheet that will have the data exported to.
ShowExcelWorkbook will be visible if set to TRUE.
Extension for Saving FilePipe-bar (|) delimited list of extensions to save the file as (e.g. .pdf, .xps, .txt).

The following extensions are supported for saving the file:

.pdf, .xps, .txt, .xml, .htm, .html, .csv, .dif, .slk, .ods, .xlsm, .xlsb, .xls, .xltx, .xltm, .xlt, .xla and .xlam

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 NameExample RuleExample ResultMeaning
Source File Name"C:\MyDocuments\Templates\Template.xlsx"C:\MyDocuments\Templates\Template.xlsxThis is the location where the source (your template) spreadsheet is stored.
Target File Name"C:\MyDocuments\Exports\SpecInfo.xlsx"C:\MyDocuments\Exports\SpecInfo.xlsxThis is the location where the file will be created.
Target Sheet Name"Sheet1"Sheet1This is the name of the sheet on your exported spreadsheet that the data will be written to.
ShowExcelTRUETRUETRUE will show the Excel workbook opening when you run the Task.
Extension For Saving File".CSV".CSVThis will produce a CSV file of the exported data that has been exported to Excel.

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

  • Control values were successfully written to Excel

Success with Warnings

  • N/A - Should never be fulfilled.

Failed (one of the following occurred).

  • Target sheet name is empty
  • Target file name is empty
  • Source file name is empty
  • Source file not found or could not be accessed
  • Source file extension is invalid
  • Unable to copy source file
  • Could not find target sheet name
  • Unknown error occurred