public static CT_LineChart Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_LineChart ctObj = new CT_LineChart();
ctObj.ser = new List <CT_LineSer>();
ctObj.axId = new List <CT_UnsignedInt>();
ctObj.extLst = new List <CT_Extension>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "grouping")
{
ctObj.grouping = CT_Grouping.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "varyColors")
{
ctObj.varyColors = CT_Boolean.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "dLbls")
{
ctObj.dLbls = CT_DLbls.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "dropLines")
{
ctObj.dropLines = CT_ChartLines.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "hiLowLines")
{
ctObj.hiLowLines = CT_ChartLines.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "upDownBars")
{
ctObj.upDownBars = CT_UpDownBars.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "marker")
{
ctObj.marker = CT_Boolean.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "smooth")
{
ctObj.smooth = CT_Boolean.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "ser")
{
ctObj.ser.Add(CT_LineSer.Parse(childNode, namespaceManager));
}
else if (childNode.LocalName == "axId")
{
ctObj.axId.Add(CT_UnsignedInt.Parse(childNode, namespaceManager));
}
else if (childNode.LocalName == "extLst")
{
ctObj.extLst.Add(CT_Extension.Parse(childNode, namespaceManager));
}
}
return(ctObj);
}
internal void AddToChart(CT_LineChart ctLineChart)
{
CT_LineSer ctLineSer = ctLineChart.AddNewSer();
CT_Grouping ctGrouping = ctLineChart.AddNewGrouping();
ctGrouping.val = ST_Grouping.standard;
ctLineSer.AddNewIdx().val = (uint)id;
ctLineSer.AddNewOrder().val = (uint)order;
// No marker symbol on the chart line.
ctLineSer.AddNewMarker().AddNewSymbol().val = ST_MarkerStyle.none;
CT_AxDataSource catDS = ctLineSer.AddNewCat();
XSSFChartUtil.BuildAxDataSource(catDS, categories);
CT_NumDataSource valueDS = ctLineSer.AddNewVal();
XSSFChartUtil.BuildNumDataSource(valueDS, values);
if (IsTitleSet)
{
ctLineSer.tx = GetCTSerTx();
}
if (fillColor != null)
{
ctLineSer.spPr = new OpenXmlFormats.Dml.Chart.CT_ShapeProperties();
CT_LineProperties ctLineProperties = ctLineSer.spPr.AddNewLn();
CT_SolidColorFillProperties ctSolidColorFillProperties = ctLineProperties.AddNewSolidFill();
CT_SRgbColor ctSRgbColor = ctSolidColorFillProperties.AddNewSrgbClr();
ctSRgbColor.val = fillColor;
}
}
public static CT_Area3DChart Parse(XElement node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_Area3DChart ctObj = new CT_Area3DChart();
ctObj.ser = new List <CT_AreaSer>();
ctObj.axId = new List <CT_UnsignedInt>();
ctObj.extLst = new List <CT_Extension>();
foreach (XElement childNode in node.ChildElements())
{
if (childNode.Name.LocalName == "grouping")
{
ctObj.grouping = CT_Grouping.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "varyColors")
{
ctObj.varyColors = CT_Boolean.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "dLbls")
{
ctObj.dLbls = CT_DLbls.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "dropLines")
{
ctObj.dropLines = CT_ChartLines.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "gapDepth")
{
ctObj.gapDepth = CT_GapAmount.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "ser")
{
ctObj.ser.Add(CT_AreaSer.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "axId")
{
ctObj.axId.Add(CT_UnsignedInt.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "extLst")
{
ctObj.extLst.Add(CT_Extension.Parse(childNode, namespaceManager));
}
}
return(ctObj);
}
internal void AddToChart(CT_LineChart ctLineChart)
{
CT_LineSer ctLineSer = ctLineChart.AddNewSer();
CT_Grouping ctGrouping = ctLineChart.AddNewGrouping();
ctGrouping.val = ST_Grouping.standard;
ctLineSer.AddNewIdx().val = (uint)id;
ctLineSer.AddNewOrder().val = (uint)order;
// No marker symbol on the chart line.
ctLineSer.AddNewMarker().AddNewSymbol().val = ST_MarkerStyle.none;
CT_AxDataSource catDS = ctLineSer.AddNewCat();
XSSFChartUtil.BuildAxDataSource(catDS, categories);
CT_NumDataSource valueDS = ctLineSer.AddNewVal();
XSSFChartUtil.BuildNumDataSource(valueDS, values);
if (IsTitleSet)
{
ctLineSer.tx = GetCTSerTx();
}
}
public CT_Grouping AddNewGrouping()
{
this.groupingField = new CT_Grouping();
return(this.groupingField);
}