EPPlus克隆工作表

Question

我希望能够通过编程的方式克隆我的Excel模板文件中的工作表。当使用NPOI库时，可以使用以下代码：

    HSSFWorkbook workbook = new HSSFWorkbook(fs, true);
    workbook.CloneSheet(1);

我想知道EPPlus中是否有与ExcelWorkbook等效的东西。我希望能够复制整个ExcelWorksheet以保留我的格式和值，而不仅仅是手动复制每个单元格或单元格范围。

- Bùi Đức Khánh

Answer 1

尝试使用 ExcelWorksheets.Copy 方法：

public ExcelWorksheet Copy(ExcelWorkbook workbook, string existingWorksheetName, string newWorksheetName)
{
    ExcelWorksheet worksheet = workbook.Worksheets.Copy(existingWorksheetName, newWorksheetName);
    return worksheet;
}

- SpruceMoose

Answer 2

首先打开两个工作簿，然后可以添加整个工作表： (例如：从workbook_1复制-> workbook_2)

FileInfo existingFile1 = new FileInfo(path_of_workbook_1);
using (ExcelPackage package = new ExcelPackage(existingFile1 ))
{
     FileInfo existingFile = new FileInfo(path_of_workbook_2);
     using (ExcelPackage package_0 = new ExcelPackage(existingFile))
     {
         ExcelWorksheet worksheet0 = package_0.Workbook.Worksheets["Original Sheet"];
         package.Workbook.Worksheets.Add("Copied Sheet", worksheet0);
     }
}

- TK_18