/// <summary>
/// Fills a <see cref="ExcelChartAxis"/> object with model data.
/// </summary>
/// <param name="axis"><see cref="ExcelChartAxis"/> object.</param>
/// <param name="axisNodeAsXml"><b>XML</b> node than represent an axis definition.</param>
/// <param name="model">Axis model definition.</param>
/// <param name="documentHelper">Target xml document helper.</param>
public static void SetAxis(this ExcelChartAxis axis, XmlNode axisNodeAsXml, XlsxChartAxisDefinition model, IXmlHelper documentHelper)
{
if (model.Values.HasMaximumValue)
{
axis.MaxValue = double.Parse(model.Values.Maximum, CultureInfo.InvariantCulture);
}
if (model.Values.HasMinimumValue)
{
axis.MinValue = double.Parse(model.Values.Minimum, CultureInfo.InvariantCulture);
}
axis.MajorTickMark = model.Marks.Major.AsEnumType <eAxisTickMark>();
axis.MinorTickMark = model.Marks.Minor.AsEnumType <eAxisTickMark>();
axis.LabelPosition = model.Labels.Position.AsEnumType <eTickLabelPosition>();
axis.TickLabelPosition = model.Labels.Position.AsEnumType <eTickLabelPosition>();
axisNodeAsXml.AddAxisGridLinesMode(model.GridLines, documentHelper);
axisNodeAsXml.AddAxisLabelProperties(model.Labels, documentHelper);
axisNodeAsXml.AddAxisLabelAlignment(model.Labels.Alignment, documentHelper);
axisNodeAsXml.ModifyAxisCrosses(documentHelper);
var axisType = axisNodeAsXml.ExtractAxisType(documentHelper);
//axis.Title.SetTitle(.FormatFromModel(axisType.ToKnownChartElement(), model.Title);
}
public void Initialize()
{
var xmlDoc = new XmlDocument();
var xmlNsm = new XmlNamespaceManager(new NameTable());
xmlNsm.AddNamespace("c", ExcelPackage.schemaChart);
axis = new ExcelChartAxis(xmlNsm, xmlDoc.CreateElement("axis"));
}
public void Initialize()
{
var xmlDoc = new XmlDocument();
xmlDoc.LoadXml("<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><c:chartSpace xmlns:c=\"http://schemas.openxmlformats.org/drawingml/2006/chart\" xmlns:a=\"http://schemas.openxmlformats.org/drawingml/2006/main\" xmlns:r=\"http://schemas.openxmlformats.org/officeDocument/2006/relationships\" ></c:chartSpace>");
var xmlNsm = new XmlNamespaceManager(new NameTable());
xmlNsm.AddNamespace("c", ExcelPackage.schemaChart);
xmlNsm.AddNamespace("a", ExcelPackage.schemaDrawings);
var node = xmlDoc.CreateElement("axis");
xmlDoc.DocumentElement.AppendChild(node);
axis = new ExcelChartAxisStandard(null, xmlNsm, node, "c");
}
