Export A Table Array To Named Range In Excel (DriveWorks Documentation)

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.

Microsoft Office

Ensure Microsoft Office is installed on all DriveWorks machines that will process this Task.

Microsoft Office and DriveWorks Live running as a service through IIS

Services (IIS) do not have access to many applications, especially COM programs such as Microsoft Word and Excel.

When using DriveWorks Live and IIS please read the following articles for information on where to place this Task.

Properties

Property Name	Description
Title	Changes the Title (not the name) of the task.
Target File Name	File Name of the target spreadsheet. A full file path is required.
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. Named Ranges 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. If the Named Range exists on two different sheets within the same Workbook, the export will only occur in the worksheet in the first position (left most item in the tab order at the bottom of the Excel application).
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	Pipe-bar (\|) delimited list of extensions to save the file as (e.g. .pdf, .xps, .txt). The following extensions are supported for saving the file: .pdf, .xps, .txt, .xml, .htm, .html, .csv, .dif, .slk, .ods, .xlsm, .xlsb, .xls, .xltx, .xltm, .xlt, .xla and .xlam

Example

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
Target File Name	"C:\DriveWorks\MyFile.xlsx"	C:\DriveWorks\MyFile.xls	The full file path to the Excel file to use for the export.
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"	.PDF	This will produce a PDF of the exported data that has been exported to Excel.

Status Outputs

This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.

The status output navigation is as follows:

Success

Table was successfully exported to Excel

Success with Warnings

N/A - Should never be fulfilled.

Failed (one of the following occurred).

Target range name is empty
Target file name is empty
Target file not found or could not be accessed
Target file extension is invalid
Array value is not a valid DriveWorks table.
Unknown error occurred

DriveWorks Pro 22 Export A Table Array To Named Range In Excel