Copy Excel Worksheets

VBC#

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

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

' Select first worksheet in the workbook
Dim 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")

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

Copy Excel Worksheets

The code example above shows how to use IronXL to duplicate and copy WorkSheets within and between Excel WorkBooks. Copy and paste sheets to and from other workbooks. Create duplicate sheets within the same workbook.

The CopySheet method is used to duplicate a worksheet within the same workbook or spreadsheet. The name of the new worksheet is required as a parameter.

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.

You can download a file project from this link.