C# Class Smrf.NodeXL.ExcelTemplate.ImportFromWorkbookDialog

Imports edge and vertex columns from another open workbook to an object.
If Form.ShowDialog() returns DialogResult.OK, the imported IGraph object can be obtained from the property.
Inheritance: ExcelTemplateForm
Afficher le fichier Open project: 2014-sed-team3/term-project

Protected Properties

Свойство Type Description
m_oDestinationNodeXLWorkbook Microsoft.Office.Interop.Excel.Workbook
m_oGraph IGraph
m_oImportFromWorkbookDialogUserSettings ImportFromWorkbookDialogUserSettings

Méthodes publiques

Méthode Description
AssertValid ( ) : void
ImportFromWorkbookDialog ( Microsoft destinationNodeXLWorkbook ) : System

Initializes a new instance of the class.

Méthodes protégées

Méthode Description
CheckAllIsEdgeColumnCheckBoxes ( System.Boolean bCheck ) : void
Dispose ( bool disposing ) : void

Clean up any resources being used.
DoDataExchange ( System.Boolean bFromControls ) : System.Boolean
EnableControls ( ) : void
GetOneBasedColumnNumbersToImport ( Int32 iDataGridViewColumnIndex ) : ICollection
GetSourceColumnItemText ( String sFirstSourceCellValue, String sColumnLetter, System.Boolean bSourceColumnsHaveHeaders ) : String
ImportFromEdgeWorkbook ( ) : void
ObjectWithTextToColumnNumberOneBased ( ObjectWithText oObjectWithText ) : Int32
OnLoad ( EventArgs e ) : void
OnSourceWorkbookChanged ( ) : void
PopulateSourceColumnsDataGridView ( ) : void
PopulateVertexComboBox ( ComboBox cbxVertex ) : void
PopulateVertexComboBoxes ( ) : void
TryGetSourceWorkbookNonEmptyRange ( Range &oNonEmptyRange ) : System.Boolean

Private Methods

Méthode Description
InitializeComponent ( ) : void

Required method for Designer support - do not modify the contents of this method with the code editor.
btnCheckAllIsEdgeColumnCheckBoxes_Click ( object sender, EventArgs e ) : void
btnOK_Click ( object sender, System e ) : void
btnUncheckAllIsEdgeColumnCheckBoxes_Click ( object sender, EventArgs e ) : void
cbxSourceColumnsHaveHeaders_CheckedChanged ( object sender, EventArgs e ) : void
cbxVertex_SelectedIndexChanged ( object sender, EventArgs e ) : void
dgvSourceColumns_CellContentClick ( object sender, System.Windows.Forms.DataGridViewCellEventArgs e ) : void
lbxSourceWorkbook_SelectedIndexChanged ( object sender, EventArgs e ) : void

Method Details

AssertValid() public méthode

public AssertValid ( ) : void
Résultat void

CheckAllIsEdgeColumnCheckBoxes() protected méthode

protected CheckAllIsEdgeColumnCheckBoxes ( System.Boolean bCheck ) : void
bCheck System.Boolean
Résultat void

Dispose() protected méthode

Clean up any resources being used.
protected Dispose ( bool disposing ) : void
disposing bool true if managed resources should be disposed; otherwise, false.
Résultat void

DoDataExchange() protected méthode

protected DoDataExchange ( System.Boolean bFromControls ) : System.Boolean
bFromControls System.Boolean
Résultat System.Boolean

EnableControls() protected méthode

protected EnableControls ( ) : void
Résultat void

GetOneBasedColumnNumbersToImport() protected méthode

protected GetOneBasedColumnNumbersToImport ( Int32 iDataGridViewColumnIndex ) : ICollection
iDataGridViewColumnIndex System.Int32
Résultat ICollection

GetSourceColumnItemText() protected méthode

protected GetSourceColumnItemText ( String sFirstSourceCellValue, String sColumnLetter, System.Boolean bSourceColumnsHaveHeaders ) : String
sFirstSourceCellValue String
sColumnLetter String
bSourceColumnsHaveHeaders System.Boolean
Résultat String

ImportFromEdgeWorkbook() protected méthode

protected ImportFromEdgeWorkbook ( ) : void
Résultat void

ImportFromWorkbookDialog() public méthode

Initializes a new instance of the class.
public ImportFromWorkbookDialog ( Microsoft destinationNodeXLWorkbook ) : System
destinationNodeXLWorkbook Microsoft /// Workbook into which the edges and vertices will be imported. This is /// used only to avoid including the workbook in the list of workbooks /// that can be imported; the workbook itself is not modified by this /// class. ///
Résultat System

ObjectWithTextToColumnNumberOneBased() protected méthode

protected ObjectWithTextToColumnNumberOneBased ( ObjectWithText oObjectWithText ) : Int32
oObjectWithText Smrf.AppLib.ObjectWithText
Résultat System.Int32

OnLoad() protected méthode

protected OnLoad ( EventArgs e ) : void
e System.EventArgs
Résultat void

OnSourceWorkbookChanged() protected méthode

protected OnSourceWorkbookChanged ( ) : void
Résultat void

PopulateSourceColumnsDataGridView() protected méthode

protected PopulateSourceColumnsDataGridView ( ) : void
Résultat void

PopulateVertexComboBox() protected méthode

protected PopulateVertexComboBox ( ComboBox cbxVertex ) : void
cbxVertex System.Windows.Forms.ComboBox
Résultat void

PopulateVertexComboBoxes() protected méthode

protected PopulateVertexComboBoxes ( ) : void
Résultat void

TryGetSourceWorkbookNonEmptyRange() protected méthode

protected TryGetSourceWorkbookNonEmptyRange ( Range &oNonEmptyRange ) : System.Boolean
oNonEmptyRange Range
Résultat System.Boolean

Property Details

m_oDestinationNodeXLWorkbook protected_oe property

protected Workbook,Microsoft.Office.Interop.Excel m_oDestinationNodeXLWorkbook
Résultat Microsoft.Office.Interop.Excel.Workbook

m_oGraph protected_oe property

protected IGraph m_oGraph
Résultat IGraph

m_oImportFromWorkbookDialogUserSettings protected_oe property

protected ImportFromWorkbookDialogUserSettings,Smrf.NodeXL.ExcelTemplate m_oImportFromWorkbookDialogUserSettings
Résultat ImportFromWorkbookDialogUserSettings