Home Search

DriveWorks Pro 21
Export Table Array To Excel Cell Reference

Send Feedback

Export Table Array To Excel Cell Reference

This Specification Flow Task exports a table array into a Microsoft Excel Workbook via a Cell Reference.

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 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.
ShowExcelWorkbook will be visible if set to TRUE.
Include Header TRUE to include first row, FALSE to exclude.
Insert New Rows TRUE to insert new rows, FALSE to overwrite data.
ShowExcel Workbook will be visible if set to TRUE.
Extension for Saving FilePipe-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

Sheet Name The name of the sheet to insert into.
Cell ReferenceA single cell reference that the table will use as the origin to insert into.

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 NameExample RuleExample ResultMeaning
Target File Name"C:\DriveWorks\MyFile.xlsx"C:\DriveWorks\MyFile.xlsxThe 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.
Include HeaderTRUETRUETRUE will export the data with headers, false will not include headers.
Insert New RowsTRUETRUETRUE will insert new rows into the spreadsheet. False will overwrite any existing cells.
ShowExcelTRUETRUEIf true will show the excel document as its being edited.
Extension for Saving File".PDF".PDFThis will produce a PDF of the exported data that has been exported to Excel.
Sheet name"sheet1"sheet1Will insert the Array Value into the worksheet named sheet1.
Cell reference"E5"E5Will insert the Array Value into the cell referenced by column E and row 5.

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

  • Data exported successfully.

Success with Warnings

  • N/A - Should never be fulfilled.

Failed (one of the following occurred).

  • The property 'Target File Name' cannot be left empty.
  • The property 'Array Value' cannot be left empty.
  • The property 'Sheet Name' cannot be left empty.
  • The property 'Cell Reference' cannot be left empty.
  • The spreadsheet <target file name> does not exist.
  • Target spreadsheet has an invalid extension - <target file name>. Valid extensions are: .xls, .xlsx, .xlsm, .xlsb.
  • Unable to retrieve table value.
  • Unable to find the worksheet <sheet name>
  • Error executing specification task. <error message>