private void InitializeControls() { this.Chart_1 = new Microsoft.Office.Tools.Excel.Chart(this.ItemProvider, this.HostContext, "Sheet1:Chart 1", this, "Chart_1"); this.ChartData = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ChartData", this, "ChartData"); }
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); }
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.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 = 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.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); }
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); }
internal void AddChart() { // Demo 3 Worksheet worksheet = Globals.Factory.GetVstoObject( Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet); //var currentRange = Globals.ThisAddIn.Application.ActiveWindow.RangeSelection; Worksheet worksheet2 = Globals.Factory.GetVstoObject( Globals.ThisAddIn.Application.ActiveWorkbook.Sheets[2]); var currentRange = worksheet2.Range["A1", "H20"]; Chart chart = worksheet2.Controls.AddChart(currentRange, "ratings"); chart.ChartType = Microsoft.Office.Interop.Excel.XlChartType.xlColumnClustered; var listObject = FindListObject("netflixTitles"); var end = listObject.DataBodyRange.get_End(XlDirection.xlDown).Row; Excel.Range cells = worksheet.Range["F1", "F" + end.ToString()]; chart.SetSourceData(cells, missing); chart.ApplyDataLabels(XlDataLabelsType.xlDataLabelsShowNone); }
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); }
private void InitializeControls() { this.Chart_1035 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 1035", "Chart_1035", this); this.Chart_1037 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 1037", "Chart_1037", this); this.Chart_1038 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 1038", "Chart_1038", this); this.Chart_1039 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 1039", "Chart_1039", this); this.Chart_1040 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 1040", "Chart_1040", this); this.Chart_21 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 21", "Chart_21", this); this.Chart_22 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 22", "Chart_22", this); this.Chart_23 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 23", "Chart_23", this); this.Chart_9 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 9", "Chart_9", this); this.Chart_13 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 13", "Chart_13", this); this.Chart_14 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 14", "Chart_14", this); this.Chart_15 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 15", "Chart_15", this); this.Chart_16 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 16", "Chart_16", this); this.Chart_17 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 17", "Chart_17", this); this.DAY = Globals.Factory.CreateNamedRange(null, null, "DAY", "DAY", this); this.PUEB_OBS = Globals.Factory.CreateNamedRange(null, null, "PUEB.OBS", "PUEB_OBS", 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.Chart_1 = new Microsoft.Office.Tools.Excel.Chart(this.ItemProvider, this.HostContext, "Sheet1:Chart 1", this, "Chart_1"); this.ChartData = new Microsoft.Office.Tools.Excel.NamedRange(this.ItemProvider, this.HostContext, "ChartData", this, "ChartData"); }
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, "Sheet3:Chart 1", "Chart_1", this); this.Chart_2 = Globals.Factory.CreateChart(null, null, "Sheet3:Chart 2", "Chart_2", this); this._lmr2 = Globals.Factory.CreateNamedRange(null, null, "_lmr2", "_lmr2", this); this.AMTY = Globals.Factory.CreateNamedRange(null, null, "AMTY", "AMTY", this); this.AMTY_NF = Globals.Factory.CreateNamedRange(null, null, "AMTY.NF", "AMTY_NF", this); this.amty2_nf = Globals.Factory.CreateNamedRange(null, null, "amty2.nf", "amty2_nf", this); this.BUFF = Globals.Factory.CreateNamedRange(null, null, "BUFF", "BUFF", this); this.BUFF_NF = Globals.Factory.CreateNamedRange(null, null, "BUFF.NF", "BUFF_NF", this); this.BUFF2 = Globals.Factory.CreateNamedRange(null, null, "BUFF2", "BUFF2", this); this.buffd = Globals.Factory.CreateNamedRange(null, null, "buffd", "buffd", this); this.COOL = Globals.Factory.CreateNamedRange(null, null, "COOL", "COOL", this); this.COOL_NF = Globals.Factory.CreateNamedRange(null, null, "COOL.NF", "COOL_NF", this); this.cool2_nf = Globals.Factory.CreateNamedRange(null, null, "cool2.nf", "cool2_nf", this); this.feefb2_nf = Globals.Factory.CreateNamedRange(null, null, "feefb2.nf", "feefb2_nf", this); this.FRON = Globals.Factory.CreateNamedRange(null, null, "FRON", "FRON", this); this.FRON_NF = Globals.Factory.CreateNamedRange(null, null, "FRON.NF", "FRON_NF", this); this.FRON2 = Globals.Factory.CreateNamedRange(null, null, "FRON2", "FRON2", this); this.fron2_nf = Globals.Factory.CreateNamedRange(null, null, "fron2.nf", "fron2_nf", this); this.GRAN = Globals.Factory.CreateNamedRange(null, null, "GRAN", "GRAN", this); this.GRAN_NF = Globals.Factory.CreateNamedRange(null, null, "GRAN.NF", "GRAN_NF", this); this.gran2 = Globals.Factory.CreateNamedRange(null, null, "gran2", "gran2", this); this.HYDE = Globals.Factory.CreateNamedRange(null, null, "HYDE", "HYDE", this); this.HYDE_NF = Globals.Factory.CreateNamedRange(null, null, "HYDE.NF", "HYDE_NF", this); this.hyde2 = Globals.Factory.CreateNamedRange(null, null, "hyde2", "hyde2", this); this.hyde2_nf = Globals.Factory.CreateNamedRange(null, null, "hyde2.nf", "hyde2_nf", this); this.KEE_FB = Globals.Factory.CreateNamedRange(null, null, "KEE.FB", "KEE_FB", this); this.KEEFB = Globals.Factory.CreateNamedRange(null, null, "KEEFB", "KEEFB", this); this.keefb2 = Globals.Factory.CreateNamedRange(null, null, "keefb2", "keefb2", this); this.keefb2_nf = Globals.Factory.CreateNamedRange(null, null, "keefb2.nf", "keefb2_nf", this); this.KEEFBNF = Globals.Factory.CreateNamedRange(null, null, "KEEFBNF", "KEEFBNF", this); this.LMR = Globals.Factory.CreateNamedRange(null, null, "LMR", "LMR", this); this.LMR_D = Globals.Factory.CreateNamedRange(null, null, "LMR.D", "LMR_D", this); this.LMR_NF = Globals.Factory.CreateNamedRange(null, null, "LMR.NF", "LMR_NF", this); this.lmr2_nf = Globals.Factory.CreateNamedRange(null, null, "lmr2.nf", "lmr2_nf", this); this.lmrg = Globals.Factory.CreateNamedRange(null, null, "lmrg", "lmrg", this); this.lmrg_nf = Globals.Factory.CreateNamedRange(null, null, "lmrg.nf", "lmrg_nf", this); this.SISS = Globals.Factory.CreateNamedRange(null, null, "SISS", "SISS", this); this.SISS_NF = Globals.Factory.CreateNamedRange(null, null, "SISS.NF", "SISS_NF", this); this.siss2_nf = Globals.Factory.CreateNamedRange(null, null, "siss2.nf", "siss2_nf", this); this.XY = Globals.Factory.CreateNamedRange(null, null, "XY", "XY", this); this.XY_NF = Globals.Factory.CreateNamedRange(null, null, "XY.NF", "XY_NF", this); }
private void InitializeControls() { this.Chart_10 = Globals.Factory.CreateChart(null, null, "Sheet2:Chart 10", "Chart_10", this); this.StartDeliveryFraction = Globals.Factory.CreateNamedRange(null, null, "StartDeliveryFraction", "StartDeliveryFraction", this); }
private void InitializeControls() { this.Chart_10 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 10", "Chart_10", this); this.Chart_11 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 11", "Chart_11", this); this.Chart_12 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 12", "Chart_12", this); this.Chart_21 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 21", "Chart_21", this); this.Chart_22 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 22", "Chart_22", this); this.Chart_23 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 23", "Chart_23", this); this.Chart_24 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 24", "Chart_24", this); this.Chart_20 = Globals.Factory.CreateChart(null, null, "Sheet4:Chart 20", "Chart_20", this); }
private void InitializeControls() { this.Chart_2049 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2049", "Chart_2049", this); this.Chart_2050 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2050", "Chart_2050", this); this.Chart_2051 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2051", "Chart_2051", this); this.Chart_2052 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2052", "Chart_2052", this); this.Chart_2053 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2053", "Chart_2053", this); this.Chart_2054 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2054", "Chart_2054", this); this.Chart_2055 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2055", "Chart_2055", this); this.Chart_2056 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2056", "Chart_2056", this); this.Chart_2057 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 2057", "Chart_2057", this); this.Chart_38 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 38", "Chart_38", this); this.Chart_39 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 39", "Chart_39", this); this.Chart_40 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 40", "Chart_40", this); this.Chart_42 = Globals.Factory.CreateChart(null, null, "Sheet5:Chart 42", "Chart_42", this); }
private void InitializeControls() { this.Chart_1 = Globals.Factory.CreateChart(null, null, "Sheet6:Chart 1", "Chart_1", this); this.ChartSelect = new Microsoft.Office.Tools.Excel.Controls.ComboBox(Globals.Factory, this.ItemProvider, this.HostContext, "122DDB3D21742C14D851A1B31D2CF12300FED1", "122DDB3D21742C14D851A1B31D2CF12300FED1", this, "ChartSelect"); this.GotoMainButton = new Microsoft.Office.Tools.Excel.Controls.Button(Globals.Factory, this.ItemProvider, this.HostContext, "2C928815A2098124E082A0D6261B9401EF9D52", "2C928815A2098124E082A0D6261B9401EF9D52", this, "GotoMainButton"); }
private void InitializeControls() { this.Chart_1 = Globals.Factory.CreateChart(null, null, "Sheet7:Chart 1", "Chart_1", this); this.Chart_2 = Globals.Factory.CreateChart(null, null, "Sheet7:Chart 2", "Chart_2", this); }
private void InitializeControls() { this.Chart_1 = Globals.Factory.CreateChart(null, null, "Sheet1:Chart 1", "Chart_1", 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"); }