DriveWorks Pro 15: 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.

Export a Table Array To Named Range in Excel Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Target File NameFile Name of the target (new) spreadsheet.
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).

Table of Contents