Copy Excel Worksheets

VB C#

from ironxl import *

# Load the first Excel workbook
first_book = WorkBook.Load("sample.xlsx")
second_book = WorkBook.Create()

# Select the first worksheet in the workbook
worksheet = first_book.DefaultWorkSheet

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

# Duplicate the worksheet to another workbook with the specified name
worksheet.CopyTo(second_book, "Copied Sheet")

# Save changes in the first workbook
first_book.Save()

# Save the second workbook with the copied worksheet
second_book.SaveAs("copyExcelWorksheet.xlsx")

Copy Excel Worksheets

The code example above shows how to use IronXL for Python to duplicate and copy WorkSheet objects within and between Excel WorkBook objects. You can copy sheets to and from other workbooks, or create duplicate sheets within the same workbook.

The CopySheet method duplicates a worksheet within the same workbook. The name for the new worksheet is required as a parameter.

Use the CopyTo method to copy a sheet to another workbook. A WorkBook object is required as the first parameter, followed by the name for the new worksheet.