使用OpenXML向Excel添加背景图像

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using DocumentFormat.OpenXml.Drawing.Spreadsheet;
using A = DocumentFormat.OpenXml.Drawing;
using Ap = DocumentFormat.OpenXml.ExtendedProperties;
using Vt = DocumentFormat.OpenXml.VariantTypes;

class Program
{
    static void Main(string[] args)
    {
        string excelFilePath = "path_to_excel_file.xlsx";
        string imageFilePath = "path_to_image_file.png";

        // 创建一个新的Excel文档
        using (SpreadsheetDocument document = SpreadsheetDocument.Create(excelFilePath, SpreadsheetDocumentType.Workbook))
        {
            // 添加Workbook部分
            WorkbookPart workbookPart = document.AddWorkbookPart();
            workbookPart.Workbook = new Workbook();

            // 添加Worksheet部分
            WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();
            worksheetPart.Worksheet = new Worksheet();

            // 添加Worksheet到Workbook
            Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
            Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" };
            sheets.Append(sheet);

            // 添加图像
            DrawingsPart drawingsPart = worksheetPart.AddNewPart<DrawingsPart>();
            worksheetPart.Worksheet.Append(new Drawing() { Id = worksheetPart.GetIdOfPart(drawingsPart) });
            ImagePart imagePart = drawingsPart.AddImagePart(ImagePartType.Png, worksheetPart.GetIdOfPart(drawingsPart));
            using (System.IO.FileStream stream = new System.IO.FileStream(imageFilePath, System.IO.FileMode.Open))
            {
                imagePart.FeedData(stream);
            }

            // 创建工作表背景
            WorksheetDrawing worksheetDrawing = new WorksheetDrawing();
            drawingsPart.WorksheetDrawing = worksheetDrawing;

            // 添加背景图像
            TwoCellAnchor twoCellAnchor = new TwoCellAnchor();

            // 图像定位
            FromMarker fromMarker = new FromMarker();
            fromMarker.ColumnId = new ColumnId("0");
            fromMarker.ColumnOffset = new ColumnOffset("0");
            fromMarker.RowId = new RowId("0");
            fromMarker.RowOffset = new RowOffset("0");

            ToMarker toMarker = new ToMarker();
            toMarker.ColumnId = new ColumnId("9");
            toMarker.ColumnOffset = new ColumnOffset("102");
            toMarker.RowId = new RowId("9");
            toMarker.RowOffset = new RowOffset("198");

            twoCellAnchor.Append(fromMarker);
            twoCellAnchor.Append(toMarker);

            // 创建图片对象
            Picture picture = new Picture();
            picture.NonVisualPictureProperties = new NonVisualPictureProperties();
            picture.BlipFill = new BlipFill();
            picture.ShapeProperties = new ShapeProperties();

            // 关联图像和图形
            picture.NonVisualPictureProperties.Append(new NonVisualPictureDrawingProperties(new A.PictureLocks() { NoChangeAspect = true }));
            picture.BlipFill.Blip = new A.Blip() { Embed = drawingsPart.GetIdOfPart(imagePart), CompressionState = A.BlipCompressionValues.Print };
            picture.BlipFill.SourceRectangle = new A.SourceRectangle();
            picture.BlipFill.Append(new A.Stretch(new A.FillRectangle()));
            picture.ShapeProperties.Append(new A.Transform2D(new A.Offset() { X = 0, Y = 0 }, new A.Extents() { Cx = 9928800, Cy = 7257600 }));
            picture.ShapeProperties.Append(new A.PresetGeometry(new A.AdjustValueList()) { Preset = A.ShapeTypeValues.Rectangle });

            twoCellAnchor.Append(picture);
            worksheetDrawing.Append(twoCellAnchor);

            // 保存Excel文档
            worksheetPart.Worksheet.Save();
            workbookPart.Workbook.Save();
            document.Close();
        }
    }
}