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"); }