EPPlus将多个工作表复制到一个带有图像的工作表中

using OfficeOpenXml;

// 创建一个新的Excel文件
var newFile = new FileInfo("newFile.xlsx");
using (var package = new ExcelPackage(newFile))
{
    // 在新文件中创建一个带有图像的工作表
    var worksheet = package.Workbook.Worksheets.Add("Combined");
    worksheet.Cells["A1"].Value = "Combined Worksheet";
    
    // 复制多个工作表到新工作表中
    var sourceFile = new FileInfo("sourceFile.xlsx");
    using (var sourcePackage = new ExcelPackage(sourceFile))
    {
        foreach (var sourceWorksheet in sourcePackage.Workbook.Worksheets)
        {
            // 复制工作表数据
            for (int row = 1; row <= sourceWorksheet.Dimension.Rows; row++)
            {
                for (int column = 1; column <= sourceWorksheet.Dimension.Columns; column++)
                {
                    worksheet.Cells[row, column].Value = sourceWorksheet.Cells[row, column].Value;
                }
            }
            
            // 复制工作表图像
            foreach (var picture in sourceWorksheet.Drawings.Pictures)
            {
                var copiedPicture = worksheet.Drawings.AddPicture(picture.Name, picture.Image);
                copiedPicture.SetPosition(picture.From.Row, picture.From.Column, picture.From.OffsetX, picture.From.OffsetY);
            }
        }
    }
    
    // 保存新文件
    package.Save();
}