How to: Copy Worksheets within a Workbook

• Nov 13, 2018

This example demonstrates how to create a copy of an existing worksheet. To do this, follow the steps below.

• Create an empty worksheet in a workbook. For example, call the WorksheetCollection.Add method.
• Access the newly created worksheet object and call its Worksheet.CopyFrom method with the source worksheet object passed as a parameter.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-e4655

WorksheetActions.cs

// Add a new worksheet to a workbook.
workbook.Worksheets.Add("Sheet1_Copy");

// Copy all information (content and formatting) to the newly created worksheet 
// from the "Sheet1" worksheet.
workbook.Worksheets["Sheet1_Copy"].CopyFrom(workbook.Worksheets["Sheet1"]);

WorksheetActions.vb

' Add a new worksheet to a workbook.
workbook.Worksheets.Add("Sheet1_Copy")

' Copy all information (content and formatting) to the newly created worksheet 
' from the "Sheet1" worksheet.
workbook.Worksheets("Sheet1_Copy").CopyFrom(workbook.Worksheets("Sheet1"))