//*************************************************************************
// Constructor: AutoFillWorkbookWithSchemeDialog()
//
/// <overloads>
/// Initializes a new instance of the <see
/// cref="AutoFillWorkbookWithSchemeDialog" /> class.
/// </overloads>
///
/// <summary>
/// Initializes a new instance of the <see
/// cref="AutoFillWorkbookWithSchemeDialog" /> class with a workbook.
/// </summary>
///
/// <param name="workbook">
/// Workbook containing the graph data.
/// </param>
//*************************************************************************
public AutoFillWorkbookWithSchemeDialog
(
Microsoft.Office.Interop.Excel.Workbook workbook
)
: this()
{
Debug.Assert(workbook != null);
m_oWorkbook = workbook;
// Instantiate an object that saves and retrieves the user settings for
// this dialog. Note that the object automatically saves the settings
// when the form closes.
m_oAutoFillWorkbookWithSchemeDialogUserSettings =
new AutoFillWorkbookWithSchemeDialogUserSettings(this);
// Populate the column ComboBoxes with the names of the table columns
// that can be used.
ListObject oTable;
if (ExcelUtil.TryGetTable(m_oWorkbook, WorksheetNames.Vertices,
TableNames.Vertices, out oTable))
{
cbxVertexCategoryColumnName.PopulateWithTableColumnNames(oTable);
cbxVertexLabelColumnName.PopulateWithTableColumnNames(oTable);
cbxVertexLabelColumnName.Items.Add(
VertexTableColumnNames.VertexName);
}
if (ExcelUtil.TryGetTable(m_oWorkbook, WorksheetNames.Edges,
TableNames.Edges, out oTable))
{
cbxEdgeWeightColumnName.PopulateWithTableColumnNames(oTable);
cbxEdgeTimestampColumnName.PopulateWithTableColumnNames(oTable);
}
DoDataExchange(false);
// Select default column names if the user settings didn't specify
// other column names.
//
// Note that because the DropDownStyle of all the ComboBoxes is set to
// DropDownList, setting the ComboBox text to a column name that is not
// currently in the workbook leaves the text empty.
cbxVertexCategoryColumnName.SetTextIfEmpty(
DefaultVertexCategoryColumnName);
cbxEdgeWeightColumnName.SetTextIfEmpty(DefaultEdgeWeightColumnName);
AssertValid();
}
//*************************************************************************
// Constructor: AutoFillWorkbookWithSchemeDialog()
//
/// <overloads>
/// Initializes a new instance of the <see
/// cref="AutoFillWorkbookWithSchemeDialog" /> class.
/// </overloads>
///
/// <summary>
/// Initializes a new instance of the <see
/// cref="AutoFillWorkbookWithSchemeDialog" /> class with a workbook.
/// </summary>
///
/// <param name="workbook">
/// Workbook containing the graph data.
/// </param>
//*************************************************************************
public AutoFillWorkbookWithSchemeDialog(
Microsoft.Office.Interop.Excel.Workbook workbook
)
: this()
{
Debug.Assert(workbook != null);
m_oWorkbook = workbook;
// Instantiate an object that saves and retrieves the user settings for
// this dialog. Note that the object automatically saves the settings
// when the form closes.
m_oAutoFillWorkbookWithSchemeDialogUserSettings =
new AutoFillWorkbookWithSchemeDialogUserSettings(this);
// Populate the column ComboBoxes with the names of the table columns
// that can be used.
ListObject oTable;
if ( ExcelUtil.TryGetTable(m_oWorkbook, WorksheetNames.Vertices,
TableNames.Vertices, out oTable) )
{
cbxVertexCategoryColumnName.PopulateWithTableColumnNames(oTable);
cbxVertexLabelColumnName.PopulateWithTableColumnNames(oTable);
cbxVertexLabelColumnName.Items.Add(
VertexTableColumnNames.VertexName);
}
if ( ExcelUtil.TryGetTable(m_oWorkbook, WorksheetNames.Edges,
TableNames.Edges, out oTable) )
{
cbxEdgeWeightColumnName.PopulateWithTableColumnNames(oTable);
cbxEdgeTimestampColumnName.PopulateWithTableColumnNames(oTable);
}
DoDataExchange(false);
// Select default column names if the user settings didn't specify
// other column names.
//
// Note that because the DropDownStyle of all the ComboBoxes is set to
// DropDownList, setting the ComboBox text to a column name that is not
// currently in the workbook leaves the text empty.
cbxVertexCategoryColumnName.SetTextIfEmpty(
DefaultVertexCategoryColumnName);
cbxEdgeWeightColumnName.SetTextIfEmpty(DefaultEdgeWeightColumnName);
AssertValid();
}
