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 assign 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

In This Topic
    ImportDevicesExcel Method
    In This Topic
    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 assign 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. In case of eDeleteMode, the whole project must be locked (i.e be Project::LockAllObjects method)
    See Also