This Specification Flow Task exports a table array to a named range in an Excel file. The named range will be used as the top left cell and the table exported down and right.
For more information about named ranges and how to create them see the Mircrosoft Excel tutorial video here.
There is an option to set whether headers are sent, and if new rows are inserted into Excel.
|Title||Changes the Title (not the name) of the task.|
|Target File Name||File Name of the target (new) spreadsheet.|
|Array Value||A Table array value, such as the result of a QueryDataValues function.|
|Target Range Name||The range name in the spreadsheet that will have the data exported to.|
|Include Header||TRUE to include first row, FALSE to exclude.|
|Insert New Rows||TRUE to insert new rows into the spreadsheet, FALSE to overwrite data.|
|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 properties see How To: Change A Static Property To A Dynamic Property.
|Property Name||Example Rule||Example Result||Meaning|
|Array Value||DWVariableTableArray||DWVariableTableArray||This Variable contains the Table Array that will be exported to Excel.|
|Target Range Name||"ArrayExportRange"||ArrayExportRange||ArrayExportRange is the name of the Range in excel where the exported data will be placed. A named Range can be a either a Cell or Range of Cells.|
|Include Header||TRUE||TRUE||TRUE will export the Data with Headers. FALSE will not include the Headers|
|Insert New Rows||TRUE||TRUE||TRUE will Insert New Rows into the spreadsheet. FALSE will overwrite any existing Cells.|
|ShowExcel||TRUE||TRUE||TRUE will show the Excel workbook opening when you run the Task.|
|Extension For Saving File||".PDF"||This will produce a PDF of the exported data that has been exported to Excel.|