How to: Copy Worksheets within a Workbook

• Apr 08, 2019

Important

You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use these examples in production code. Refer to the DevExpress Subscription page for pricing information.

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/spreadsheet-document-server-api-e4339

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"))