如何在c#中从一个SpreadsheetDocument获取工作表并将其添加到另一个

Install-Package DocumentFormat.OpenXml

using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

// 打开源Excel文件
using (SpreadsheetDocument sourceDoc = SpreadsheetDocument.Open("source.xlsx", false))
{
    // 获取源文件中的第一个工作表
    WorksheetPart sourceWorksheetPart = sourceDoc.WorkbookPart.WorksheetParts.First();
    Worksheet sourceWorksheet = sourceWorksheetPart.Worksheet;
}

// 创建目标Excel文件
using (SpreadsheetDocument targetDoc = SpreadsheetDocument.Create("target.xlsx", sourceDoc.DocumentType))
{
    // 复制源文件的工作簿部分到目标文件
    WorkbookPart targetWorkbookPart = targetDoc.AddWorkbookPart();
    sourceDoc.WorkbookPart.CopyPartTo(targetWorkbookPart);

    // 添加一个新的工作表部分到目标文件的工作簿
    WorksheetPart targetWorksheetPart = targetWorkbookPart.AddNewPart<WorksheetPart>();
    using (Stream stream = targetWorksheetPart.GetStream())
    {
        sourceWorksheetPart.Worksheet.Save(stream);
    }

    // 更新目标文件的工作簿引用
    targetWorkbookPart.Workbook = new Workbook();
    targetWorkbook.AddWorksheet(new Worksheet(targetWorksheetPart));
}