DriveWorks Pro 17: Export A Table Array To Named Range In Excel [send feedback...]

Export a Table Array To Named Range in Excel

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.

There is an option to set whether headers are sent, and if new rows are inserted into Excel.

Avoid using any merged cells as the named range.

This will produce an undesirable outcome for the export.

When applying a Named Range using the Name Manager (in Microsoft Excel) it is possible to set the scope of the range to be worksheet specific.

We recommend only using workbook specific ranges when setting up the Excel workbook to export into.


Property NameDescription
TitleChanges the Title (not the name) of the task.
Target File NameFile Name of the target spreadsheet. A full file path is required.
Array ValueA Table array value, such as the result of a QueryDataValues function.
Target Range NameThe range name in the spreadsheet that will have the data exported to.
Include HeaderTRUE to include first row, FALSE to exclude.
Insert New RowsTRUE to insert new rows into the spreadsheet, FALSE to overwrite data.
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).


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 NameExample RuleExample ResultMeaning
Target File Name"C:\DriveWorks\MyFile.xlsx"C:\DriveWorks\MyFile.xlsThe full file path to the Excel file to use for the export.
Array ValueDWVariableTableArrayDWVariableTableArrayThis Variable contains the Table Array that will be exported to Excel.
Target Range Name"ArrayExportRange"ArrayExportRangeArrayExportRange 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 HeaderTRUETRUETRUE will export the Data with Headers. FALSE will not include the Headers.
Insert New RowsTRUETRUETRUE will Insert New Rows into the spreadsheet. FALSE will overwrite any existing Cells.
ShowExcelTRUETRUETRUE will show the Excel workbook opening when you run the Task.
Extension For Saving File".PDF".PDFThis will produce a PDF of the exported data that has been exported to Excel.

Table of Contents