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
ファイルを表示 Open project: 2014-sed-team3/term-project

Protected Properties

Property Type Description
m_oDestinationNodeXLWorkbook Microsoft.Office.Interop.Excel.Workbook
m_oGraph IGraph
m_oImportFromWorkbookDialogUserSettings ImportFromWorkbookDialogUserSettings

Public Methods

Method Description
AssertValid ( ) : void
ImportFromWorkbookDialog ( Microsoft destinationNodeXLWorkbook ) : System

Initializes a new instance of the class.

Protected Methods

Method 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

Method 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 method

public AssertValid ( ) : void
return void

CheckAllIsEdgeColumnCheckBoxes() protected method

protected CheckAllIsEdgeColumnCheckBoxes ( System.Boolean bCheck ) : void
bCheck System.Boolean
return void

Dispose() protected method

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

DoDataExchange() protected method

protected DoDataExchange ( System.Boolean bFromControls ) : System.Boolean
bFromControls System.Boolean
return System.Boolean

EnableControls() protected method

protected EnableControls ( ) : void
return void

GetOneBasedColumnNumbersToImport() protected method

protected GetOneBasedColumnNumbersToImport ( Int32 iDataGridViewColumnIndex ) : ICollection
iDataGridViewColumnIndex System.Int32
return ICollection

GetSourceColumnItemText() protected method

protected GetSourceColumnItemText ( String sFirstSourceCellValue, String sColumnLetter, System.Boolean bSourceColumnsHaveHeaders ) : String
sFirstSourceCellValue String
sColumnLetter String
bSourceColumnsHaveHeaders System.Boolean
return String

ImportFromEdgeWorkbook() protected method

protected ImportFromEdgeWorkbook ( ) : void
return void

ImportFromWorkbookDialog() public method

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. ///
return System

ObjectWithTextToColumnNumberOneBased() protected method

protected ObjectWithTextToColumnNumberOneBased ( ObjectWithText oObjectWithText ) : Int32
oObjectWithText Smrf.AppLib.ObjectWithText
return System.Int32

OnLoad() protected method

protected OnLoad ( EventArgs e ) : void
e System.EventArgs
return void

OnSourceWorkbookChanged() protected method

protected OnSourceWorkbookChanged ( ) : void
return void

PopulateSourceColumnsDataGridView() protected method

protected PopulateSourceColumnsDataGridView ( ) : void
return void

PopulateVertexComboBox() protected method

protected PopulateVertexComboBox ( ComboBox cbxVertex ) : void
cbxVertex System.Windows.Forms.ComboBox
return void

PopulateVertexComboBoxes() protected method

protected PopulateVertexComboBoxes ( ) : void
return void

TryGetSourceWorkbookNonEmptyRange() protected method

protected TryGetSourceWorkbookNonEmptyRange ( Range &oNonEmptyRange ) : System.Boolean
oNonEmptyRange Range
return System.Boolean

Property Details

m_oDestinationNodeXLWorkbook protected_oe property

protected Workbook,Microsoft.Office.Interop.Excel m_oDestinationNodeXLWorkbook
return Microsoft.Office.Interop.Excel.Workbook

m_oGraph protected_oe property

protected IGraph m_oGraph
return IGraph

m_oImportFromWorkbookDialogUserSettings protected_oe property

protected ImportFromWorkbookDialogUserSettings,Smrf.NodeXL.ExcelTemplate m_oImportFromWorkbookDialogUserSettings
return ImportFromWorkbookDialogUserSettings