DriveWorks Pro 15: Import Named Sheet from Excel into an Existing Project Table [send feedback...]

Import Named Sheet from Excel into an Existing Project Table

This Specification Task will import a named sheet from Excel into an existing project table.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
File NameThe file name of the spreadsheet.
Maximum RowsThe maximum number of rows to retrieve from each table (use 0 for all rows).
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. Pipebar (|) delimit this string for multiple sheets.
ShowExcelThe workbook will be visible if set to TRUE.
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.
Simple Table NameThe name of the DriveWorks project Simple Table that the sheet will be written to (when importing multiple sheets, use a pipebar (|) delimited list of table names).

Table of Contents