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.
|Title||Changes the Title (not the name) of the task.|
|Source File Name||File Name of the source (template) spreadsheet.|
|Target File Name||File Name of the target (new) spreadsheet.|
|Target Sheet Name||The sheet name in the spreadsheet that will have the data exported to.|
|ShowExcel||Workbook will be visible if set to TRUE.|
|Extension for Saving File||Pipe-bar (|) delimited list of extensions to save the file as (e.g. .pdf, .xps, .txt).|
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 Name||Example Rule||Example Result||Meaning|
|Source File Name||"C:\MyDocuments\Templates\Template.xlsx"||C:\MyDocuments\Templates\Template.xlsx||This is the location where the source (your template) spreadsheet is stored.|
|Target File Name||"C:\MyDocuments\Exports\SpecInfo.xlsx"||C:\MyDocuments\Exports\SpecInfo.xlsx||This is the location where the file will be created.|
|Target Sheet Name||"Sheet1"||Sheet1||This is the name of the sheet on your exported spreadsheet that the data will be written to.|
|ShowExcel||TRUE||TRUE||TRUE will show the Excel workbook opening when you run the Task.|
|Extension For Saving File||".CSV"||.CSV||This will produce a CSV file of the exported data that has been exported to Excel.|
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).