Eplan Platform API
Eplan.EplApi.HEServices Namespace / ConnectionService3D Class / ImportExcel Method
Destination project.
Filename of the import file.
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
Designation for 'internal'.
Designation for 'external'.
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
    ImportExcel Method
    In This Topic
    Imports the Connection3Ds from an Excel file into the given project using a scheme.
    Syntax

    Parameters

    Parameter NameDescription
    oProjectDestination project.
    strImportFilePathFilename of the import file.
    strSchemeNameName of the import scheme. If the scheme name is empty, the last used scheme of the project will be used.
    strTableNameExcel sheet name.
    nHeadLinePosThe position of the head line that will be used to asssign the column values at the import.
    nHeadLineCountThe count of head lines that will be skipped at the import.
    oFuncDefDefault Function Definition
    strInternDesignation for 'internal'.
    strExternDesignation for 'external'.
    eModeThe 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

    An array of imported Connections3D.
    Exceptions
    ExceptionDescription
    Invalid parameters found.
    Thrown if NULL was passed as a required parameter.
    The internal interface for importing could not be created.
    An error occurred during the import. Please refer to the exception message.
    Remarks
    If new scheme is not present, the old import method is used.
    See Also