Eplan Platform API
Eplan.EplApi.HEServices Namespace / DeviceService Class / ImportDevicesExcel Method
Project into which the devices will be imported.
Full file name of the devices file to import.
Name of the import scheme. If the scheme name is empty the last used scheme of the project will be used.
Excel sheet name.
The position of the head line that will be used to asssign the column values at the import.
The count of head lines that will be skipped at the import.
Default Function Definition
Default Terminal Function Definition
The import mode can be a combination of the XPProcImportMode enum and controls the import action (in)(optional) eCreateMode = 1: The import create only missing device tags eChangeMode = 2: The import change only existing device tags eDeleteMode = 4: The import delete only unnecessary existing device tags

ImportDevicesExcel Method
This function imports devices from an Excel file into a given project.
Syntax

Parameters

oProject
Project into which the devices will be imported.
strImportFilePath
Full file name of the devices file to import.
strSchemeName
Name of the import scheme. If the scheme name is empty the last used scheme of the project will be used.
strTableName
Excel sheet name.
nHeadLinePos
The position of the head line that will be used to asssign the column values at the import.
nHeadLineCount
The count of head lines that will be skipped at the import.
oFuncDef
Default Function Definition
oTermFuncDef
Default Terminal Function Definition
eMode
The import mode can be a combination of the XPProcImportMode enum and controls the import action (in)(optional) eCreateMode = 1: The import create only missing device tags eChangeMode = 2: The import change only existing device tags eDeleteMode = 4: The import delete only unnecessary existing device tags

Return Value

Result is returned as array of StorableObjects.
Exceptions
ExceptionDescription
Invalid parameters found.
Null was passed to a parameter.
The internal interface for importing devices could not be created.
An error occurred during the import of devices. Please refer to the exception message.
Remarks
If new schema is not present old import method is used
See Also