C# Chart.ExcelChart类代码示例

        //internal ExcelBarChart(ExcelDrawings drawings, XmlNode node) :
        //    base(drawings, node/*, 1*/)
        //{
        //    SetChartNodeText("");
        //}
        //internal ExcelBarChart(ExcelDrawings drawings, XmlNode node, eChartType type) :
        //    base(drawings, node, type)
        //{
        //    SetChartNodeText("");
        //    SetTypeProperties(drawings, type);
        //}
        internal ExcelBarChart(ExcelDrawings drawings, XmlNode node, eChartType type, ExcelChart topChart, ExcelPivotTable PivotTableSource)
            : base(drawings, node, type, topChart, PivotTableSource)
        {
            SetChartNodeText("");

            SetTypeProperties(drawings, type);
        }

 internal ExcelChartSeries(ExcelChart chart, XmlNamespaceManager ns, XmlNode node, bool isPivot)
     : base(ns,node)
 {
     _ns = ns;
     _chart=chart;
     _node=node;
     _isPivot = isPivot;
     SchemaNodeOrder = new string[] { "view3D", "plotArea", "barDir", "grouping", "scatterStyle", "varyColors", "ser", "explosion", "dLbls", "firstSliceAng", "holeSize", "shape", "legend", "axId" };
     foreach(XmlNode n in node.SelectNodes("c:ser",ns))
     {
         ExcelChartSerie s;
         if (chart.ChartNode.LocalName == "scatterChart")
         {
             s = new ExcelScatterChartSerie(this, ns, n, isPivot);
         }
         else if (chart.ChartNode.LocalName == "lineChart")
         {
             s = new ExcelLineChartSerie(this, ns, n, isPivot);
         }
         else if (chart.ChartNode.LocalName == "pieChart" ||
                  chart.ChartNode.LocalName == "ofPieChart" ||
                  chart.ChartNode.LocalName == "pie3DChart" ||
                  chart.ChartNode.LocalName == "doughnutChart")                                                                       
         {
             s = new ExcelPieChartSerie(this, ns, n, isPivot);
         }
         else
         {
             s = new ExcelChartSerie(this, ns, n, isPivot);
         }
         _list.Add(s);
     }
 }

 internal ExcelBubbleChart(ExcelDrawings drawings, XmlNode node, eChartType type, ExcelChart topChart, ExcelPivotTable PivotTableSource)
     : base(drawings, node, type, topChart, PivotTableSource)
 {
     ShowNegativeBubbles = false;
     BubbleScale = 100;
     _chartSeries = new ExcelBubbleChartSeries(this, drawings.NameSpaceManager, _chartNode, PivotTableSource!=null);
     //SetTypeProperties();
 }

        internal ExcelChartSeries(ExcelChart chart, XmlNamespaceManager ns, XmlNode node)
            : base(ns,node)
        {
            _ns = ns;
               _chart=chart;
               _node=node;

               foreach(XmlNode n in node.SelectNodes("//c:ser",ns))
               {
               ExcelChartSerie s = new ExcelChartSerie(this, ns, n);
               _list.Add(s);
               }
        }

 public ExcelDoughnutChart(ExcelChart topChart, XmlNode chartNode)
     : base(topChart, chartNode)
 {
     //SetPaths();
 }

 internal ExcelDoughnutChart(ExcelDrawings drawings, XmlNode node, eChartType type, ExcelChart topChart, ExcelPivotTable PivotTableSource) :
     base(drawings, node, type, topChart, PivotTableSource)
 {
     //SetPaths();
 }

 internal static ExcelChart GetNewChart(ExcelDrawings drawings, XmlNode drawNode, eChartType chartType, ExcelChart topChart)
 {
     switch(chartType)
     {
         case eChartType.Pie:
         case eChartType.PieExploded:
         case eChartType.Pie3D:
         case eChartType.PieExploded3D:
             return new ExcelPieChart(drawings, drawNode, chartType, topChart);
         case eChartType.BarOfPie:
         case eChartType.PieOfPie:
             return new ExcelOfPieChart(drawings, drawNode, chartType, topChart);
         case eChartType.Doughnut:
         case eChartType.DoughnutExploded:
             return new ExcelDoughnutChart(drawings, drawNode, chartType, topChart);
         case eChartType.BarClustered:
         case eChartType.BarStacked:
         case eChartType.BarStacked100:
         case eChartType.BarClustered3D:
         case eChartType.BarStacked3D:
         case eChartType.BarStacked1003D:
         case eChartType.ConeBarClustered:
         case eChartType.ConeBarStacked:
         case eChartType.ConeBarStacked100:
         case eChartType.CylinderBarClustered:
         case eChartType.CylinderBarStacked:
         case eChartType.CylinderBarStacked100:
         case eChartType.PyramidBarClustered:
         case eChartType.PyramidBarStacked:
         case eChartType.PyramidBarStacked100:
         case eChartType.ColumnClustered:
         case eChartType.ColumnStacked:
         case eChartType.ColumnStacked100:
         case eChartType.Column3D:
         case eChartType.ColumnClustered3D:
         case eChartType.ColumnStacked3D:
         case eChartType.ColumnStacked1003D:
         case eChartType.ConeCol:
         case eChartType.ConeColClustered:
         case eChartType.ConeColStacked:
         case eChartType.ConeColStacked100:
         case eChartType.CylinderCol:
         case eChartType.CylinderColClustered:
         case eChartType.CylinderColStacked:
         case eChartType.CylinderColStacked100:
         case eChartType.PyramidCol:
         case eChartType.PyramidColClustered:
         case eChartType.PyramidColStacked:
         case eChartType.PyramidColStacked100:
             return new ExcelBarChart(drawings, drawNode, chartType, topChart);
         case eChartType.XYScatter:
         case eChartType.XYScatterLines:
         case eChartType.XYScatterLinesNoMarkers:
         case eChartType.XYScatterSmooth:
         case eChartType.XYScatterSmoothNoMarkers:
             return new ExcelScatterChart(drawings, drawNode, chartType, topChart);
         case eChartType.Line:
         case eChartType.Line3D:
         case eChartType.LineMarkers:
         case eChartType.LineMarkersStacked:
         case eChartType.LineMarkersStacked100:
         case eChartType.LineStacked:
         case eChartType.LineStacked100:
             return new ExcelLineChart(drawings, drawNode, chartType, topChart);
         default:
             return new ExcelChart(drawings, drawNode, chartType, topChart);
     }
 }

 internal ExcelLineChart(ExcelChart topChart, XmlNode chartNode)
     : base(topChart, chartNode)
 {
     // _chartTopPath = string.Format(_chartTopPath, chartNode.Name);
 }

 internal static ExcelChart GetChart(XmlElement chartNode, ExcelDrawings drawings, XmlNode node,  Uri uriChart, Packaging.ZipPackagePart part, XmlDocument chartXml, ExcelChart topChart)
 {
     switch (chartNode.LocalName)
        {
        case "area3DChart":
        case "areaChart":
        case "stockChart":
            if (topChart == null)
            {
                return new ExcelChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelChart(topChart, chartNode);
            }
        case "surface3DChart":
        case "surfaceChart":
            if (topChart == null)
            {
                return new ExcelSurfaceChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelSurfaceChart(topChart, chartNode);
            }
        case "radarChart":
            if (topChart == null)
            {
                return new ExcelRadarChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelRadarChart(topChart, chartNode);
            }
        case "bubbleChart":
            if (topChart == null)
            {
                return new ExcelBubbleChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelBubbleChart(topChart, chartNode);
            }
        case "barChart":
        case "bar3DChart":
            if (topChart == null)
            {
                return new ExcelBarChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelBarChart(topChart, chartNode);
            }
        case "doughnutChart":
            if (topChart == null)
            {
                return new ExcelDoughnutChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelDoughnutChart(topChart, chartNode);
            }
        case "pie3DChart":
        case "pieChart":
            if (topChart == null)
            {
                return new ExcelPieChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelPieChart(topChart, chartNode);
            }
        case "ofPieChart":
            if (topChart == null)
            {
                return new ExcelOfPieChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelBarChart(topChart, chartNode);
            }
        case "lineChart":
        case "line3DChart":
            if (topChart == null)
            {
                return new ExcelLineChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelLineChart(topChart, chartNode);
            }
        case "scatterChart":
            if (topChart == null)
            {
                return new ExcelScatterChart(drawings, node, uriChart, part, chartXml, chartNode);
            }
            else
            {
                return new ExcelScatterChart(topChart, chartNode);
            }
//.........这里部分代码省略.........

 internal ExcelChartLegend(XmlNamespaceManager ns, XmlNode node, ExcelChart chart)
     : base(ns,node)
 {
     _chart=chart;
        SchemaNodeOrder = new string[] { "legendPos", "layout","overlay", "txPr", "bodyPr", "lstStyle", "spPr" };
 }

 internal ExcelPieChart(ExcelDrawings drawings, XmlNode node, eChartType type, ExcelChart topChart, ExcelPivotTable PivotTableSource) :
     base(drawings, node, type, topChart, PivotTableSource)
 {
 }

 internal ExcelBubbleChartSeries(ExcelChart chart, XmlNamespaceManager ns, XmlNode node, bool isPivot)
    : base(chart,ns,node, isPivot)
 {
     //_chartSeries = new ExcelChartSeries(this, _drawings.NameSpaceManager, _chartNode, isPivot);
 }

 internal ExcelChartLegend(XmlNamespaceManager ns, XmlNode node, ExcelChart chart)
     : base(ns,node)
 {
     _chart=chart;
 }

        internal ExcelChart(ExcelDrawings drawings, XmlNode node, eChartType type, ExcelChart topChart, ExcelPivotTable PivotTableSource)
            : base(drawings, node, "xdr:graphicFrame/xdr:nvGraphicFramePr/xdr:cNvPr/@name")
        {
            ChartType = type;
               CreateNewChart(drawings, type, topChart);

               Init(drawings, _chartNode);

               _chartSeries = new ExcelChartSeries(this, drawings.NameSpaceManager, _chartNode, PivotTableSource!=null);
               if (PivotTableSource != null) SetPivotSource(PivotTableSource);

               SetTypeProperties();
               if (topChart == null)
               LoadAxis();
               else
               {
               _axis = topChart.Axis;
               if (_axis.Length > 0)
               {
                   XAxis = _axis[0];
                   YAxis = _axis[1];
               }
               }
        }

  internal ExcelChartPlotArea(XmlNamespaceManager ns, XmlNode node, ExcelChart firstChart)
     : base(ns,node)
 {
     _firstChart = firstChart;
 }