This Specification Flow Task will look in all named ranges in an Excel file, and for each one, checks to see if a Variable exists with the same name.
If a Variable exists, it will drive the named range value to be the Variables value.
It will then run a Macro called CreateReports if it exists, this will only work for .xls and .xlsm files.
It then looks in the named ranges again and reads in all data found in named ranges in the Excel file and passes them into the Specification for driving into Constants or Controls.
If a Constant is found with the same name as the named range (Not case sensitive) then the value from that named range will be passed through to the Constant.
If no Constant is found with that name, then it 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 named range data.
|Title||Changes the Title (not the name) of the task.|
|File Name||File Name of the Excel File Including Extension.|
|Show Excel||Workbook will be visible if set to True.|
|Constant Name||Constant into which the input and output count will be stored.|
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 Name||Example Rule||Example Result||Meaning|
|FileName||"C:\MyDocuments\SpecData\NamedRanges.xlsx"||C:\MyDocuments\SpecData\NamedRanges.xlsx||This is the Full File Path including extension for the Excel File that contains the Ranges.|
|ShowExcel||TRUE||TRUE||TRUE will show the Excel workbook opening when you run the Task.|
|Constant Name||"ExportReport"||ExportReport||This is the Constant that will have the Input and Output count values stored into it.|