Home Search

DriveWorks Pro 21
Import Named Sheet From Excel Into An Existing Simple Table

Send Feedback

Import Named Sheet From Excel Into An Existing Simple Table

This Specification Macro Task will import a named Sheet from Excel into an existing Simple Table.

Please ensure that Microsoft Office is installed on all DriveWorks machines that will process this Task.
This Task imports data into a Simple Table only.

Other Table types (Excel, ODBC, SQL, Rollup, Calculation or Group Data Tables) are not supported.

Properties

Property Name Description
TitleChanges the Title (not the name) of the task.
File NameThe file name of the spreadsheet.
Sheet Name(s)The name of the sheet to pull the data from. This can be the sheet name or the index of the sheet. Pipe-bar (|) delimit this string for multiple sheets.
ShowExcelThe workbook will be visible if set to TRUE.
Simple Table NameThe name of the DriveWorks Simple Table that the sheet will be written to (when importing multiple sheets, use a pipebar (|) delimited list of Table names).
Sheet Name Return ConstantThe name of the Constant that the imported sheet names will be written to.
Table Name return ConstantThe name of the Constant that the imported Table names will be written to.
Maximum RowsThe maximum number of rows to retrieve from each Table (use 0 for all rows).

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
File Name"C:\MyDocuments\ExcelFiles\ExcelData.xlsx"C:\MyDocuments\ExcelFiles\ExcelData.xlsxThis is the Full File Path of the Excel file to use.
Sheet Name(s)"DataToUse"DataToUseThis is the name of the Sheet in the Excel file to take the data from to insert into the specified Simple Table.
Show ExcelTRUETRUEThis will show the opening of the Excel Application when the Task is run.
Simple Table Name"ProductData"ProductDataThis is the name of an existing Simple Table in that the data will be inserted into.
Sheet Name Return Constant"DWConstantSheetName"SheetNameThis is the name of the Constant that will report back with the Excel Sheet name that took the data from to insert into the Simple Table.
Table Name Return Constant"DWConstantTable"DWConstantTableThis is the name of the Constant that will report back with the Table that the Data was inserted into.
Maximum Rows00This will use all the Rows in the Excel document.

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 from Excel successfully imported

Success with Warnings

  • N/A - Should never be fulfilled.

Failed (one of the following occurred).

  • File name is empty.
  • Target file not found or could not be accessed.
  • Target file extension is invalid.
  • Sheet name is empty.
  • Failed to find Sheet in Excel.
  • Table must be a Simple Table.
  • Unknown error occurred.