複製Excel工作表

VB C#

using IronXL;

WorkBook firstBook = WorkBook.Load("sample.xlsx");
WorkBook secondBook = WorkBook.Create();

// Select first worksheet in the workbook
WorkSheet workSheet = firstBook.DefaultWorkSheet;

// Duplicate the worksheet to the same workbook
workSheet.CopySheet("Copied Sheet");

// Duplicate the worksheet to another workbook with the specified name
workSheet.CopyTo(secondBook, "Copied Sheet");

firstBook.Save();
secondBook.SaveAs("copyExcelWorksheet.xlsx");

Imports IronXL

Private firstBook As WorkBook = WorkBook.Load("sample.xlsx")
Private secondBook As WorkBook = WorkBook.Create()

' Select first worksheet in the workbook
Private workSheet As WorkSheet = firstBook.DefaultWorkSheet

' Duplicate the worksheet to the same workbook
workSheet.CopySheet("Copied Sheet")

' Duplicate the worksheet to another workbook with the specified name
workSheet.CopyTo(secondBook, "Copied Sheet")

firstBook.Save()
secondBook.SaveAs("copyExcelWorksheet.xlsx")

Install-Package IronXl.Excel

複製Excel工作表

The code example above shows how to use IronXL to duplicate and copy WorkSheets within and between Excel WorkBooks. 在其他工作簿中複製和貼上工作表。在同一工作簿中建立重複工作表。

The CopySheet method is used to duplicate a worksheet within the same workbook or spreadsheet. 新工作表的名稱是必要的參數。

Use the CopyTo method to duplicate a sheet to or from another workbook. A WorkBook is required as the first parameter and is followed by the name of the new worksheet.

你可以透過這個連結下載專案檔。