private void InitializeControls()
{
this.ProductList = Globals.Factory.CreateListObject(null, null, "Sheet1:ProductList", "ProductList", this);
this.Status = Globals.Factory.CreateNamedRange(null, null, "Status", "Status", this);
this.PaintEvents = Globals.Factory.CreateNamedRange(null, null, "PaintEvents", "PaintEvents", this);
this.OrdersChart = Globals.Factory.CreateChart(null, null, "Sheet1:Chart 25", "OrdersChart", this);
}
private void InitializeControls()
{
this.表8 = Globals.Factory.CreateListObject(null, null, "Sheet1:表8", "表8", this);
this.Count = Globals.Factory.CreateNamedRange(null, null, "Count", "Count", this);
this.discount = Globals.Factory.CreateNamedRange(null, null, "discount", "discount", this);
this.button1 = new Microsoft.Office.Tools.Excel.Controls.Button(Globals.Factory, this.ItemProvider, this.HostContext, "3F589F41D36498341533BDE73D9DA96A113F43", "3F589F41D36498341533BDE73D9DA96A113F43", this, "button1");
}
private void InitializeControls()
{
this.ProductList = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:ProductList", this, "ProductList");
this.Status = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Status", this, "Status");
this.PaintEvents = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "PaintEvents", this, "PaintEvents");
this.OrdersChart = new Microsoft.Office.Tools.Excel.Chart(this.ItemProvider, this.HostContext, "Sheet1:Chart 25", this, "OrdersChart");
}
private void InitializeControls()
{
this.Chart_1 = Globals.Factory.CreateChart(null, null, "Sheet2:Chart 1", "Chart_1", this);
this.表2 = Globals.Factory.CreateListObject(null, null, "Sheet2:表2", "表2", this);
this.factor = Globals.Factory.CreateNamedRange(null, null, "factor", "factor", this);
this.factor2 = Globals.Factory.CreateNamedRange(null, null, "factor2", "factor2", this);
}
public void FromListObject(ListObject listObject)
{
var columnByIndex = new Dictionary <int, DataColumn>();
for (var index = 0; index < this.Columns.Count; index++)
{
var column = this.Columns[index];
columnByIndex.Add(index, column);
}
var listRows = listObject
.ListRows
.Cast <ListRow>()
.Select(v => v.Range.Cells.Cast <Range>().Select(cell => cell.Value).ToArray())
.ToArray();
foreach (var listRow in listRows)
{
var row = this.NewRow();
foreach (var kvp in columnByIndex)
{
var index = kvp.Key;
var column = kvp.Value;
row[column] = listRow[index] ?? DBNull.Value;
}
this.Add(row);
}
}
private void InitializeControls()
{
this.表8 = Globals.Factory.CreateListObject(null, null, "Sheet1:表8", "表8", this);
this.Count = Globals.Factory.CreateNamedRange(null, null, "Count", "Count", this);
this.discount = Globals.Factory.CreateNamedRange(null, null, "discount", "discount", this);
this.button1 = new Microsoft.Office.Tools.Excel.Controls.Button(Globals.Factory, this.ItemProvider, this.HostContext, "3BBDAE1F0334533412E3B5E03F5ACE08A42BD3", "3BBDAE1F0334533412E3B5E03F5ACE08A42BD3", this, "button1");
}
private void InitializeControls()
{
this.PriceDelivery = Globals.Factory.CreateListObject(null, null, "Лист6:PriceDelivery", "PriceDelivery", this);
this.weght = Globals.Factory.CreateNamedRange(null, null, "weght", "weght", this);
this.weghtCell = Globals.Factory.CreateNamedRange(null, null, "weghtCell", "weghtCell", this);
this.ProviderTable = Globals.Factory.CreateListObject(null, null, "Лист6:ProviderTable", "ProviderTable", this);
}
private void InitializeControls()
{
this.orderIDNamedRange = Globals.Factory.CreateNamedRange(null, null, "orderIDNamedRange", "orderIDNamedRange", this);
this.order_DetailsListObject = Globals.Factory.CreateListObject(null, null, "Sheet2:order_DetailsListObject", "order_DetailsListObject", this);
this.button1 = new Microsoft.Office.Tools.Excel.Controls.Button(Globals.Factory, this.ItemProvider, this.HostContext, "18BA3DA301382514D871827C101F215697E8A1", "18BA3DA301382514D871827C101F215697E8A1", this, "button1");
this.button2 = new Microsoft.Office.Tools.Excel.Controls.Button(Globals.Factory, this.ItemProvider, this.HostContext, "2056938C4206B824BD62B69027BAF5BD5CC132", "2056938C4206B824BD62B69027BAF5BD5CC132", this, "button2");
}
private void InitializeControls()
{
this.Chart_1 = new Microsoft.Office.Tools.Excel.Chart(this.ItemProvider, this.HostContext, "Sheet2:Chart 1", this, "Chart_1");
this.History = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet2:History", this, "History");
this.FlavorNamedRange = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "FlavorNamedRange", this, "FlavorNamedRange");
this.IceCreamLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "IceCreamLabel", this, "IceCreamLabel");
this.Sheet2_TitleLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Sheet2!TitleLabel", this, "Sheet2_TitleLabel");
}
private void InitializeControls()
{
this.tblClkrQuizGrades = Globals.Factory.CreateListObject(null, null, "Sheet1:tblClkrQuizGrades", "tblClkrQuizGrades", this);
this.Sheet1_rowCourseWkNmbr = Globals.Factory.CreateNamedRange(null, null, "Sheet1!rowCourseWkNmbr", "Sheet1_rowCourseWkNmbr", this);
this.Sheet1_rowSessionEnum = Globals.Factory.CreateNamedRange(null, null, "Sheet1!rowSessionEnum", "Sheet1_rowSessionEnum", this);
this.Sheet1_rowSessionNmbr = Globals.Factory.CreateNamedRange(null, null, "Sheet1!rowSessionNmbr", "Sheet1_rowSessionNmbr", this);
this.Sheet1_rowTtlQuizPts = Globals.Factory.CreateNamedRange(null, null, "Sheet1!rowTtlQuizPts", "Sheet1_rowTtlQuizPts", this);
}
private void InitializeControls()
{
this.ValidEdgeVisibilities = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidEdgeVisibilities", this, "ValidEdgeVisibilities");
this.ValidVertexShapes = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidVertexShapes", this, "ValidVertexShapes");
this.ValidVertexVisibilities = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidVertexVisibilities", this, "ValidVertexVisibilities");
this.ValidBooleansDefaultFalse = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidBooleansDefaultFalse", this, "ValidBooleansDefaultFalse");
this.PerWorkbookSettings = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet4:PerWorkbookSettings", this, "PerWorkbookSettings");
this.DynamicFilterSettings = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet4:DynamicFilterSettings", this, "DynamicFilterSettings");
}
private void InitializeControls()
{
this.DayInventory = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:DayInventory", this, "DayInventory");
this.TitleLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "TitleLabel", this, "TitleLabel");
this.DateLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "DateLabel", this, "DateLabel");
this.Sheet1_TitleLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Sheet1!TitleLabel", this, "Sheet1_TitleLabel");
this.DateSelector = new Microsoft.Office.Tools.Excel.Controls.DateTimePicker(this.ItemProvider, this.HostContext, "13F0570EE1C65B14D231B91D1FF48A03B3C881", "13F0570EE1C65B14D231B91D1FF48A03B3C881", this, "DateSelector");
this.newDateButton = new Microsoft.Office.Tools.Excel.Controls.Button(this.ItemProvider, this.HostContext, "1D1E00CA416B0B1463D1B95B13A0D67E3EDD31", "1D1E00CA416B0B1463D1B95B13A0D67E3EDD31", this, "newDateButton");
this.saveButton = new Microsoft.Office.Tools.Excel.Controls.Button(this.ItemProvider, this.HostContext, "1CFF0A45519D3714F7E1B951152AA2DB497CF1", "1CFF0A45519D3714F7E1B951152AA2DB497CF1", this, "saveButton");
}
public OrderEntity(Host.Excel.Worksheet worksheet)
{
// セルの書式設定を文字列へ
worksheet.Range["A:B"].NumberFormatLocal = "@";
// アクティブセルをテーブルの外にしてデザインタブがアクティブになるのを防ぐ
worksheet.Range["A3"].Select();
// ListObject追加
Native.Excel.Range cell = worksheet.Range["$A$1:$C$2"];
list1 = worksheet.Controls.AddListObject(cell, Guid.NewGuid().ToString("N"));
}
//*************************************************************************
// Constructor: Sheets1And2Helper()
//
/// <summary>
/// Initializes a new instance of the <see cref="Sheets1And2Helper" />
/// class.
/// </summary>
///
/// <param name="worksheet">
/// The worksheet that owns this object.
/// </param>
///
/// <param name="table">
/// The edge or vertex table.
/// </param>
//*************************************************************************
public Sheets1And2Helper
(
Microsoft.Office.Tools.Excel.WorksheetBase worksheet,
Microsoft.Office.Tools.Excel.ListObject table
)
: base(worksheet, table)
{
// (Do nothing.)
AssertValid();
}
//*************************************************************************
// Constructor: SheetHelper()
//
/// <summary>
/// Initializes a new instance of the <see cref="SheetHelper" /> class.
/// </summary>
///
/// <param name="worksheet">
/// The worksheet that owns this object.
/// </param>
///
/// <param name="table">
/// The NodeXL table in the worksheet.
/// </param>
//*************************************************************************
public SheetHelper
(
Microsoft.Office.Tools.Excel.WorksheetBase worksheet,
Microsoft.Office.Tools.Excel.ListObject table
)
{
m_oWorksheet = worksheet;
m_oTable = table;
// AssertValid();
}
private void InitializeControls()
{
this.defaultSavePath = Globals.Factory.CreateNamedRange(null, null, "defaultSavePath", "defaultSavePath", this);
this.dateComment = Globals.Factory.CreateNamedRange(null, null, "dateComment", "dateComment", this);
this.data2001 = Globals.Factory.CreateNamedRange(null, null, "data2001", "data2001", this);
this.data2002 = Globals.Factory.CreateNamedRange(null, null, "data2002", "data2002", this);
this.dataAll = Globals.Factory.CreateNamedRange(null, null, "dataAll", "dataAll", this);
this.rangeStyles = Globals.Factory.CreateNamedRange(null, null, "rangeStyles", "rangeStyles", this);
this.Fruits = Globals.Factory.CreateNamedRange(null, null, "Fruits", "Fruits", this);
this.message = Globals.Factory.CreateNamedRange(null, null, "message", "message", this);
this.fruitList = Globals.Factory.CreateListObject(null, null, "Sheet1:fruitList", "fruitList", this);
}
private void InitializeControls()
{
this.Table1 = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:Table1", this, "Table1");
this.BundleId = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleId", this, "BundleId");
this.BundleDate = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleDate", this, "BundleDate");
this.BundleFund = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleFund", this, "BundleFund");
this.BundleTotal = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleTotal", this, "BundleTotal");
this.Amount = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Amount", this, "Amount");
this.Fund = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Fund", this, "Fund");
this.PeopleId = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "PeopleId", this, "PeopleId");
this.Pledge = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Pledge", this, "Pledge");
this.Name1 = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Name", this, "Name1");
}
private void InitializeControls()
{
this.ValidEdgeVisibilities = Globals.Factory.CreateNamedRange(null, null, "ValidEdgeVisibilities", "ValidEdgeVisibilities", this);
this.ValidVertexShapes = Globals.Factory.CreateNamedRange(null, null, "ValidVertexShapes", "ValidVertexShapes", this);
this.ValidVertexVisibilities = Globals.Factory.CreateNamedRange(null, null, "ValidVertexVisibilities", "ValidVertexVisibilities", this);
this.ValidBooleansDefaultFalse = Globals.Factory.CreateNamedRange(null, null, "ValidBooleansDefaultFalse", "ValidBooleansDefaultFalse", this);
this.PerWorkbookSettings = Globals.Factory.CreateListObject(null, null, "Sheet4:PerWorkbookSettings", "PerWorkbookSettings", this);
this.DynamicFilterSettings = Globals.Factory.CreateListObject(null, null, "Sheet4:DynamicFilterSettings", "DynamicFilterSettings", this);
this.DynamicFilterHistogram = Globals.Factory.CreateChart(null, null, "Sheet4:DynamicFilterHistogram", "DynamicFilterHistogram", this);
this.ValidEdgeStyles = Globals.Factory.CreateNamedRange(null, null, "ValidEdgeStyles", "ValidEdgeStyles", this);
this.ValidGroupShapes = Globals.Factory.CreateNamedRange(null, null, "ValidGroupShapes", "ValidGroupShapes", this);
this.ValidGroupVisibilities = Globals.Factory.CreateNamedRange(null, null, "ValidGroupVisibilities", "ValidGroupVisibilities", this);
this.ValidVertexLabelPositions = Globals.Factory.CreateNamedRange(null, null, "ValidVertexLabelPositions", "ValidVertexLabelPositions", this);
}
internal void BindToProtectedList(Microsoft.Office.Tools.Excel.ListObject list, params string[] mappedColumns)
{
try
{
Globals.ThisWorkbook.MakeReadWrite();
list.SetDataBinding(this, "", mappedColumns);
boundToList = true;
}
finally
{
Globals.ThisWorkbook.MakeReadOnly();
}
}
public void ToListObject(ListObject listObject)
{
var dataSet = new DataSet();
dataSet.Tables.Add(this);
listObject.SetDataBinding(dataSet, this.TableName);
var headers = listObject.HeaderRowRange;
for (var i = 0; i < this.Columns.Count; i++)
{
var column = this.Columns[i];
Range header = headers.Cells[1, i + 1];
header.Value = column.ColumnName;
}
}
private void InitializeControls()
{
this.OverallMetrics = Globals.Factory.CreateListObject(null, null, "Sheet7:OverallMetrics", "OverallMetrics", this);
this.DegreeHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:DegreeHistogram", "DegreeHistogram", this);
this.InDegreeHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:InDegreeHistogram", "InDegreeHistogram", this);
this.OutDegreeHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:OutDegreeHistogram", "OutDegreeHistogram", this);
this.BetweennessCentralityHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:BetweennessCentralityHistogram", "BetweennessCentralityHistogram", this);
this.ClosenessCentralityHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:ClosenessCentralityHistogram", "ClosenessCentralityHistogram", this);
this.EigenvectorCentralityHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:EigenvectorCentralityHistogram", "EigenvectorCentralityHistogram", this);
this.ClusteringCoefficientHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:ClusteringCoefficientHistogram", "ClusteringCoefficientHistogram", this);
this.HistogramBins = Globals.Factory.CreateListObject(null, null, "Sheet7:HistogramBins", "HistogramBins", this);
this.HistogramProperties = Globals.Factory.CreateListObject(null, null, "Sheet7:HistogramProperties", "HistogramProperties", this);
this.OverallReadabilityMetrics = Globals.Factory.CreateListObject(null, null, "Sheet7:OverallReadabilityMetrics", "OverallReadabilityMetrics", this);
this.BinDivisor = Globals.Factory.CreateNamedRange(null, null, "BinDivisor", "BinDivisor", this);
this.DynamicFilterForceCalculationRange = Globals.Factory.CreateNamedRange(null, null, "DynamicFilterForceCalculationRange", "DynamicFilterForceCalculationRange", this);
this.DynamicFilterSourceColumnRange = Globals.Factory.CreateNamedRange(null, null, "DynamicFilterSourceColumnRange", "DynamicFilterSourceColumnRange", this);
this.NoMetricMessage = Globals.Factory.CreateNamedRange(null, null, "NoMetricMessage", "NoMetricMessage", this);
this.NotAvailable = Globals.Factory.CreateNamedRange(null, null, "NotAvailable", "NotAvailable", this);
}
private void InitializeControls() {
this.tblExpenses = Globals.Factory.CreateListObject(null, null, "Expenses:tblExpenses", "tblExpenses", this);
}
private void InitializeControls()
{
this.customerListObject = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:customerListObject", this, "customerListObject");
this.dateNamedRange = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "dateNamedRange", this, "dateNamedRange");
this.dateTextBox = new Microsoft.Office.Tools.Excel.Controls.TextBox(this.ItemProvider, this.HostContext, "565B10E3B5F844543425AB1F59CFD31EEAB255", "565B10E3B5F844543425AB1F59CFD31EEAB255", this, "dateTextBox");
}
private void InitializeControls() {
this.list1 = Globals.Factory.CreateListObject(null, null, "Arkusz1:list1", "list1", this);
}
private void InitializeControls() {
this.ValidEdgeVisibilities = Globals.Factory.CreateNamedRange(null, null, "ValidEdgeVisibilities", "ValidEdgeVisibilities", this);
this.ValidVertexShapes = Globals.Factory.CreateNamedRange(null, null, "ValidVertexShapes", "ValidVertexShapes", this);
this.ValidVertexVisibilities = Globals.Factory.CreateNamedRange(null, null, "ValidVertexVisibilities", "ValidVertexVisibilities", this);
this.ValidBooleansDefaultFalse = Globals.Factory.CreateNamedRange(null, null, "ValidBooleansDefaultFalse", "ValidBooleansDefaultFalse", this);
this.PerWorkbookSettings = Globals.Factory.CreateListObject(null, null, "Sheet4:PerWorkbookSettings", "PerWorkbookSettings", this);
this.DynamicFilterSettings = Globals.Factory.CreateListObject(null, null, "Sheet4:DynamicFilterSettings", "DynamicFilterSettings", this);
this.DynamicFilterHistogram = Globals.Factory.CreateChart(null, null, "Sheet4:DynamicFilterHistogram", "DynamicFilterHistogram", this);
this.ValidEdgeStyles = Globals.Factory.CreateNamedRange(null, null, "ValidEdgeStyles", "ValidEdgeStyles", this);
this.ValidGroupShapes = Globals.Factory.CreateNamedRange(null, null, "ValidGroupShapes", "ValidGroupShapes", this);
this.ValidGroupVisibilities = Globals.Factory.CreateNamedRange(null, null, "ValidGroupVisibilities", "ValidGroupVisibilities", this);
this.ValidVertexLabelPositions = Globals.Factory.CreateNamedRange(null, null, "ValidVertexLabelPositions", "ValidVertexLabelPositions", this);
}
//*************************************************************************
// Constructor: WorksheetContextMenuManager()
//
/// <summary>
/// Initializes a new instance of the <see
/// cref="WorksheetContextMenuManager" /> class.
/// </summary>
///
/// <param name="workbook">
/// Excel workbook.
/// </param>
///
/// <param name="edgeWorksheet">
/// The edge worksheet in the Excel workbook.
/// </param>
///
/// <param name="edgeTable">
/// The edge table on the edge worksheet.
/// </param>
///
/// <param name="vertexWorksheet">
/// The vertex worksheet in the Excel workbook.
/// </param>
///
/// <param name="vertexTable">
/// The vertex table on the vertex worksheet.
/// </param>
///
/// <param name="groupWorksheet">
/// The group worksheet in the Excel workbook.
/// </param>
///
/// <param name="groupTable">
/// The group table on the group worksheet.
/// </param>
//*************************************************************************
public WorksheetContextMenuManager(
Microsoft.Office.Tools.Excel.Workbook workbook,
Microsoft.Office.Tools.Excel.Worksheet edgeWorksheet,
Microsoft.Office.Tools.Excel.ListObject edgeTable,
Microsoft.Office.Tools.Excel.Worksheet vertexWorksheet,
Microsoft.Office.Tools.Excel.ListObject vertexTable,
Microsoft.Office.Tools.Excel.Worksheet groupWorksheet,
Microsoft.Office.Tools.Excel.ListObject groupTable
)
{
Debug.Assert(workbook != null);
Debug.Assert(edgeWorksheet != null);
Debug.Assert(edgeTable != null);
Debug.Assert(vertexWorksheet != null);
Debug.Assert(vertexTable != null);
Debug.Assert(groupWorksheet != null);
Debug.Assert(groupTable != null);
m_oWorkbook = workbook;
m_oEdgeTable = edgeTable;
m_oVertexTable = vertexTable;
m_oGroupTable = groupTable;
// Handle the events involved in adding, handling, and removing custom
// menu items.
workbook.Deactivate += new Microsoft.Office.Interop.
Excel.WorkbookEvents_DeactivateEventHandler(
this.Workbook_Deactivate);
edgeWorksheet.Deactivate += new Microsoft.Office.Interop.
Excel.DocEvents_DeactivateEventHandler(this.Worksheet_Deactivate);
vertexWorksheet.Deactivate += new Microsoft.Office.Interop.
Excel.DocEvents_DeactivateEventHandler(this.Worksheet_Deactivate);
groupWorksheet.Deactivate += new Microsoft.Office.Interop.
Excel.DocEvents_DeactivateEventHandler(this.Worksheet_Deactivate);
edgeTable.BeforeRightClick += new Microsoft.Office.Interop.Excel.
DocEvents_BeforeRightClickEventHandler(EdgeTable_BeforeRightClick);
vertexTable.BeforeRightClick += new Microsoft.Office.Interop.Excel.
DocEvents_BeforeRightClickEventHandler(
VertexTable_BeforeRightClick);
groupTable.BeforeRightClick += new Microsoft.Office.Interop.Excel.
DocEvents_BeforeRightClickEventHandler(
GroupTable_BeforeRightClick);
}
private void InitializeControls()
{
this.Edges = Globals.Factory.CreateListObject(null, null, "Sheet1:Edges", "Edges", this);
}
private void InitializeControls() {
this.OverallMetrics = Globals.Factory.CreateListObject(null, null, "Sheet7:OverallMetrics", "OverallMetrics", this);
this.DegreeHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:DegreeHistogram", "DegreeHistogram", this);
this.InDegreeHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:InDegreeHistogram", "InDegreeHistogram", this);
this.OutDegreeHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:OutDegreeHistogram", "OutDegreeHistogram", this);
this.BetweennessCentralityHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:BetweennessCentralityHistogram", "BetweennessCentralityHistogram", this);
this.ClosenessCentralityHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:ClosenessCentralityHistogram", "ClosenessCentralityHistogram", this);
this.EigenvectorCentralityHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:EigenvectorCentralityHistogram", "EigenvectorCentralityHistogram", this);
this.ClusteringCoefficientHistogram = Globals.Factory.CreateChart(null, null, "Sheet7:ClusteringCoefficientHistogram", "ClusteringCoefficientHistogram", this);
this.HistogramBins = Globals.Factory.CreateListObject(null, null, "Sheet7:HistogramBins", "HistogramBins", this);
this.HistogramProperties = Globals.Factory.CreateListObject(null, null, "Sheet7:HistogramProperties", "HistogramProperties", this);
this.OverallReadabilityMetrics = Globals.Factory.CreateListObject(null, null, "Sheet7:OverallReadabilityMetrics", "OverallReadabilityMetrics", this);
this.BinDivisor = Globals.Factory.CreateNamedRange(null, null, "BinDivisor", "BinDivisor", this);
this.DynamicFilterForceCalculationRange = Globals.Factory.CreateNamedRange(null, null, "DynamicFilterForceCalculationRange", "DynamicFilterForceCalculationRange", this);
this.DynamicFilterSourceColumnRange = Globals.Factory.CreateNamedRange(null, null, "DynamicFilterSourceColumnRange", "DynamicFilterSourceColumnRange", this);
this.NoMetricMessage = Globals.Factory.CreateNamedRange(null, null, "NoMetricMessage", "NoMetricMessage", this);
this.NotAvailable = Globals.Factory.CreateNamedRange(null, null, "NotAvailable", "NotAvailable", this);
}
private void InitializeControls() {
this.DayInventory = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:DayInventory", this, "DayInventory");
this.TitleLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "TitleLabel", this, "TitleLabel");
this.DateLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "DateLabel", this, "DateLabel");
this.Sheet1_TitleLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Sheet1!TitleLabel", this, "Sheet1_TitleLabel");
this.DateSelector = new Microsoft.Office.Tools.Excel.Controls.DateTimePicker(this.ItemProvider, this.HostContext, "13F0570EE1C65B14D231B91D1FF48A03B3C881", "13F0570EE1C65B14D231B91D1FF48A03B3C881", this, "DateSelector");
this.newDateButton = new Microsoft.Office.Tools.Excel.Controls.Button(this.ItemProvider, this.HostContext, "1D1E00CA416B0B1463D1B95B13A0D67E3EDD31", "1D1E00CA416B0B1463D1B95B13A0D67E3EDD31", this, "newDateButton");
this.saveButton = new Microsoft.Office.Tools.Excel.Controls.Button(this.ItemProvider, this.HostContext, "1CFF0A45519D3714F7E1B951152AA2DB497CF1", "1CFF0A45519D3714F7E1B951152AA2DB497CF1", this, "saveButton");
}
private void InitializeControls() {
this.OverallMetrics = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet7:OverallMetrics", this, "OverallMetrics");
}
private void InitializeControls() {
this.customerListObject = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:customerListObject", this, "customerListObject");
this.dateNamedRange = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "dateNamedRange", this, "dateNamedRange");
this.dateTextBox = new Microsoft.Office.Tools.Excel.Controls.TextBox(this.ItemProvider, this.HostContext, "565B10E3B5F844543425AB1F59CFD31EEAB255", "565B10E3B5F844543425AB1F59CFD31EEAB255", this, "dateTextBox");
}
private void InitializeControls() {
this.Table1 = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:Table1", this, "Table1");
this.BundleId = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleId", this, "BundleId");
this.BundleDate = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleDate", this, "BundleDate");
this.BundleFund = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleFund", this, "BundleFund");
this.BundleTotal = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "BundleTotal", this, "BundleTotal");
this.Amount = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Amount", this, "Amount");
this.Fund = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Fund", this, "Fund");
this.PeopleId = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "PeopleId", this, "PeopleId");
this.Pledge = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Pledge", this, "Pledge");
this.Name1 = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Name", this, "Name1");
}
private void InitializeControls() {
this.Vertices = Globals.Factory.CreateListObject(null, null, "Sheet2:Vertices", "Vertices", this);
}
private void InitializeControls() {
this.ProductList = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet1:ProductList", this, "ProductList");
this.Status = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Status", this, "Status");
this.PaintEvents = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "PaintEvents", this, "PaintEvents");
this.OrdersChart = new Microsoft.Office.Tools.Excel.Chart(this.ItemProvider, this.HostContext, "Sheet1:Chart 25", this, "OrdersChart");
}
private void InitializeControls()
{
this.employeesListObject = Globals.Factory.CreateListObject(null, null, "Sheet3:employeesListObject", "employeesListObject", this);
this.button1 = new Microsoft.Office.Tools.Excel.Controls.Button(Globals.Factory, this.ItemProvider, this.HostContext, "1C977F8191153814C6F1B341189615A10D8D41", "1C977F8191153814C6F1B341189615A10D8D41", this, "button1");
}
private void InitializeControls() {
this.tblSalesOrderDetails = Globals.Factory.CreateListObject(null, null, "Sheet1:tblSalesOrderDetails", "tblSalesOrderDetails", this);
}
private void InitializeControls()
{
this.Table2 = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet2:Table2", this, "Table2");
}
private void InitializeControls() {
this.Edges = Globals.Factory.CreateListObject(null, null, "Sheet1:Edges", "Edges", this);
}
private void InitializeControls() {
this.tblAccounts = Globals.Factory.CreateListObject(null, null, "Config:tblAccounts", "tblAccounts", this);
}
private void InitializeControls()
{
this.datePaymentListObject = Globals.Factory.CreateListObject(null, null, "Sheet4:datePaymentListObject", "datePaymentListObject", this);
}
private void InitializeControls() {
this.GroupVertices = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet6:GroupVertices", this, "GroupVertices");
}
private void InitializeControls() {
this.StatusValuesList = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet2:StatusValuesList", this, "StatusValuesList");
this.StatusValuesRange = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "StatusValuesRange", this, "StatusValuesRange");
}
private void InitializeControls()
{
this.renewAgreementListObject = Globals.Factory.CreateListObject(null, null, "Sheet3:renewAgreementListObject", "renewAgreementListObject", this);
}
private void InitializeControls() {
this.ValidEdgeVisibilities = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidEdgeVisibilities", this, "ValidEdgeVisibilities");
this.ValidVertexShapes = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidVertexShapes", this, "ValidVertexShapes");
this.ValidVertexVisibilities = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidVertexVisibilities", this, "ValidVertexVisibilities");
this.ValidBooleansDefaultFalse = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ValidBooleansDefaultFalse", this, "ValidBooleansDefaultFalse");
this.PerWorkbookSettings = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet4:PerWorkbookSettings", this, "PerWorkbookSettings");
this.DynamicFilterSettings = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet4:DynamicFilterSettings", this, "DynamicFilterSettings");
}
private void InitializeControls()
{
this.Таблица3 = Globals.Factory.CreateListObject(null, null, "Лист1:Таблица3", "Таблица3", this);
}
private void InitializeControls() {
this.tblGoogleData = Globals.Factory.CreateListObject(null, null, "Sheet1:tblGoogleData", "tblGoogleData", this);
}
private void InitializeControls()
{
this.logList = Globals.Factory.CreateListObject(null, null, "Foglio1:logList", "logList", this);
}
private void InitializeControls()
{
this.landlordListObject = Globals.Factory.CreateListObject(null, null, "Sheet2:landlordListObject", "landlordListObject", this);
}
private void InitializeControls() {
this.Table2 = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet2:Table2", this, "Table2");
}
private void InitializeControls() {
this.Groups = Globals.Factory.CreateListObject(null, null, "Sheet5:Groups", "Groups", this);
}
private void InitializeControls() {
this.tblTransfers1 = Globals.Factory.CreateListObject(null, null, "Transfers:tblTransfers", "tblTransfers1", this);
}
private void InitializeControls() {
this.Chart_1 = new Microsoft.Office.Tools.Excel.Chart(this.ItemProvider, this.HostContext, "Sheet2:Chart 1", this, "Chart_1");
this.History = new Microsoft.Office.Tools.Excel.ListObject(this.ItemProvider, this.HostContext, "Sheet2:History", this, "History");
this.FlavorNamedRange = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "FlavorNamedRange", this, "FlavorNamedRange");
this.IceCreamLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "IceCreamLabel", this, "IceCreamLabel");
this.Sheet2_TitleLabel = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "Sheet2!TitleLabel", this, "Sheet2_TitleLabel");
}
