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||Pipebar (|) 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.|