在OpenXML BarChart上添加自定义文本

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Drawing;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using DocumentFormat.OpenXml.Drawing.Charts;

public class OpenXmlHelper
{
    public static void AddCustomTextToBarChart(string fileName)
    {
        using (SpreadsheetDocument document = SpreadsheetDocument.Open(fileName, true))
        {
            WorkbookPart workbookPart = document.WorkbookPart;
            WorksheetPart worksheetPart = workbookPart.WorksheetParts.FirstOrDefault();
            SheetData sheetData = worksheetPart.Worksheet.Elements<SheetData>().First();

            // 创建一个新的图表
            ChartPart chartPart = worksheetPart.AddNewPart<ChartPart>();
            ChartSpace chartSpace = new ChartSpace();
            chartPart.ChartSpace = chartSpace;

            // 创建柱状图对象
            BarChart barChart = chartSpace.AppendChild(new BarChart());

            // 设置柱状图的类型和样式
            barChart.Append(new BarDirection() { Val = new EnumValue<BarDirectionValues>(BarDirectionValues.Column) });
            barChart.Append(new GapWidth() { Val = new UInt16Value(150) });

            // 创建数据系列和数据点
            barChart.AppendChild(CreateSeries());
            barChart.AppendChild(CreateCategoryAxis());
            barChart.AppendChild(CreateValueAxis());

            // 添加自定义文本
            barChart.AppendChild(CreateDataLabel());

            // 将图表添加到工作表
            Drawing drawing = worksheetPart.DrawingsPart?.Drawing ?? worksheetPart.AddNewPart<DrawingsPart>().Drawing;
            ChartReference chartReference = drawing.AppendChild(new ChartReference() { Id = worksheetPart.GetIdOfPart(chartPart) });

            // 设置图表位置
            TwoCellAnchor anchor = drawing.AppendChild(new TwoCellAnchor());
            anchor.Append(new FromMarker() { RowId = new RowIdValue(0), ColumnId = new ColumnIdValue(0) });
            anchor.Append(new ToMarker() { RowId = new RowIdValue(10), ColumnId = new ColumnIdValue(10) });
            anchor.Append(chartReference);
            anchor.Append(new ClientData());

            worksheetPart.Worksheet.Save();
        }
    }

    private static CategoryAxis CreateCategoryAxis()
    {
        CategoryAxis categoryAxis = new CategoryAxis(new AxisId() { Val = new UInt32Value(48650112u) });
        categoryAxis.Append(new Scaling(new Orientation() { Val = new EnumValue<DocumentFormat.OpenXml.Drawing.Charts.OrientationValues>(DocumentFormat.OpenXml.Drawing.Charts.OrientationValues.MinMax) }),
            new AxisPosition() { Val = new EnumValue<AxisPositionValues>(AxisPositionValues.Bottom) },
            new NumberingFormat() { FormatCode = "General", SourceLinked = true },
            new TickLabelPosition() { Val = new EnumValue<TickLabelPositionValues>(TickLabelPositionValues.NextTo) },
            new CrossingAxis() { Val = new UInt32Value(48650112U) },
            new AutoLabeled() { Val = new BooleanValue(true) },
            new LabelAlignment() { Val = new EnumValue<LabelAlignmentValues>(LabelAlignmentValues.Center) },
            new LabelOffset() { Val = new UInt16Value(100) },
            new NoMultiLevelLabels() { Val = new BooleanValue(false) }
        );

        return categoryAxis;
    }

    private static ValueAxis CreateValueAxis()
    {
        ValueAxis valueAxis = new ValueAxis(new AxisId() { Val = new UInt32Value(48650112u) });
        valueAxis.Append(new Scaling(new Orientation() { Val = new EnumValue<DocumentFormat.OpenXml.Drawing.Charts.OrientationValues>(DocumentFormat.OpenXml.Drawing.Charts.OrientationValues.MinMax) }),
            new AxisPosition() { Val = new EnumValue<AxisPositionValues>(AxisPositionValues.Left) },
            new MajorGridlines(),
            new NumberingFormat() { FormatCode = "General", SourceLinked = true },
            new TickLabelPosition() { Val = new EnumValue<TickLabelPositionValues>(TickLabelPositionValues.NextTo) },
            new CrossingAxis() { Val = new UInt32Value(48650112U) },
            new Crosses() { Val = new EnumValue<CrossesValues>(CrossesValues.AutoZero) },
            new CrossBetween() { Val = new EnumValue<CrossBetweenValues>(CrossBetweenValues.Between) }
        );

        return valueAxis;
    }

    private static BarChartSeries CreateSeries()
    {
        BarChartSeries barChartSeries = new BarChartSeries(new Index() { Val = new UInt32Value(0u) })
        {
            SeriesText = new SeriesText(new NumericValue() { Text = "Sample" })
        };

        BarChartSeriesExtensionList extensionList = new BarChartSeriesExtensionList();
        BarChartSeriesExtension extension = new BarChartSeriesExtension() { Uri = "{CE6537A1-D6FC-4f65-9D91-7224C49458BB}" };

        // 设置柱状图的样式
        extension.AppendChild(new DocumentFormat.OpenXml.Office2010.Drawing.Charts.FirstSliceAngle() { Val = 0 });
        extensionList.Append(extension);

        barChartSeries.AppendChild(extensionList);

        return barChartSeries;
    }

    private static DataLabel CreateDataLabel()
    {
        DataLabel dataLabel = new DataLabel();
        dataLabel.Append(new ShowLegendKey() { Val = new BooleanValue(true) });
        dataLabel.Append(new ShowValue() { Val = new BooleanValue(true) });
        dataLabel.Append(new ShowCategoryName() { Val = new BooleanValue(true) });
        dataLabel.Append(new ShowSeriesName() { Val = new BooleanValue(true) });
        dataLabel.Append(new ShowPercent() { Val = new BooleanValue(true) });
        dataLabel.Append(new ShowBubbleSize() { Val = new BooleanValue(false) });
        dataLabel.Append(new ShowLeaderLines() { Val = new BooleanValue(true) });

        // 设置自定义文本
        TextProperties textProperties = new TextProperties();
        textProperties.Append(new BodyProperties());
        textProperties.Append(new ListStyle());
        dataLabel.Append(textProperties);

        return dataLabel;
    }
}