/// <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); }
/// <summary> /// Fills a <see cref="OfficeOpenXml.Drawing.Chart.ExcelChartAxis"/> object with model data. /// </summary> /// <param name="axis"><see cref="OfficeOpenXml.Drawing.Chart.ExcelChartAxis" /> object.</param> /// <param name="axisNodeAsXml"><c>Xml</c> node than represent an axis definition.</param> /// <param name="model">Axis model definition.</param> private static void FormatFromModel(this ExcelChartAxis axis, XmlNode axisNodeAsXml, AxisDefinitionModel model) { if (model.Values.HasMaximunValue) { axis.MaxValue = double.Parse(model.Values.Maximun, CultureInfo.InvariantCulture); } if (model.Values.HasMinimunValue) { axis.MinValue = double.Parse(model.Values.Minimun, CultureInfo.InvariantCulture); } axis.MajorTickMark = model.Marks.Major.ToEppTickMark(); axis.MinorTickMark = model.Marks.Minor.ToEppTickMark(); axis.LabelPosition = model.Labels.Position.ToEppLabelPosition(); axis.TickLabelPosition = model.Labels.Position.ToEppLabelPosition(); axisNodeAsXml.AddAxisGridLinesMode(model.GridLines); axisNodeAsXml.AddAxisLabelProperties(model.Labels); axisNodeAsXml.AddAxisLabelAlignment(model.Labels.Alignment); axisNodeAsXml.ModifyAxisCrosses(); var axisType = axisNodeAsXml.ExtractAxisType(); axis.Title.FormatFromModel(axisType.ToKnownChartElement(), model.Title); }