API Help
Eplan.EplApi.HEServices Namespace / ConnectionService3D Class / ImportExcel Method
Destination project.
Filename of the import file.
Name of the import schema. If the schema name is empty the last used schema 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
    The method imports the Connection3Ds from Excel file using schema into the giving project. If schema dos
    Syntax

    Parameters

    oProject
    Destination project.
    strImportFilePath
    Filename of the import file.
    strSchemeName
    Name of the import schema. If the schema name is empty the last used schema 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
    strIntern
    Designation for 'internal'.
    strExtern
    Designation for 'external'.
    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

    An array of imported Connections3D.
    Exceptions
    ExceptionDescription
    Invalid parameters found.
    Null was passed to a 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 schema is not present old import method is used
    See Also