DriveWorks Pro 16: Export All Control Names To Named Sheet In Excel [send feedback...]

Export All Control Names To Named Sheet in Excel

This Specification Flow Task recurses all forms in a Project and all Controls on each form.

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 FilePipebar (|) delimited list of extensions to save the file as (e.g. .pdf, .xps, .txt).

Example

When this Task is added the properties are static. To be able to build rules on a static properties 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.

Table of Contents