Smrf.NodeXL.ExcelTemplate.ImportFromWorkbookDialog.ImportFromEdgeWorkbook C# (CSharp) Method

    ImportFromEdgeWorkbook()
    {
        AssertValid();

        String sSourceWorkbookName = this.SourceWorkbookName;

        Debug.Assert(cbxVertex1.SelectedItem != null);

        Int32 iColumnToUseForVertex1OneBased =
            ObjectWithTextToColumnNumberOneBased(
                (ObjectWithText)cbxVertex1.SelectedItem);

        Debug.Assert(cbxVertex2.SelectedItem != null);

        Int32 iColumnToUseForVertex2OneBased =
            ObjectWithTextToColumnNumberOneBased(
                (ObjectWithText)cbxVertex2.SelectedItem);

        // Get the collection of edge columns to import, not including the
        // vertex 1 or vertex 2 columns.

        ICollection<Int32> oOneBasedEdgeColumnNumbersToImport =
            GetOneBasedColumnNumbersToImport(IsEdgeColumnIndex);

        oOneBasedEdgeColumnNumbersToImport.Remove(
            iColumnToUseForVertex1OneBased);

        oOneBasedEdgeColumnNumbersToImport.Remove(
            iColumnToUseForVertex2OneBased);

        m_oGraph = ( new WorkbookImporter() ).ImportWorkbook(
            m_oDestinationNodeXLWorkbook.Application,
            sSourceWorkbookName,
            iColumnToUseForVertex1OneBased, iColumnToUseForVertex2OneBased,
            oOneBasedEdgeColumnNumbersToImport,
            GetOneBasedColumnNumbersToImport(IsVertex1PropertyColumnIndex),
            GetOneBasedColumnNumbersToImport(IsVertex2PropertyColumnIndex),

            m_oImportFromWorkbookDialogUserSettings.
                SourceColumnsHaveHeaders
            );
    }