How to: Copy Worksheets between Workbooks

• Nov 14, 2018
• 2 minutes to read

Important

The Universal Subscription or an additional Document Server Subscription is required to use this example in production code. Please refer to the DevExpress Subscription page for pricing information.

This example demonstrates how to add an existing worksheet to a new workbook. To do this, access a Worksheet object that specifies a worksheet into which you want to copy another worksheet 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

// Create a source workbook.
Workbook sourceWorkbook = new Workbook();

// Add a new worksheet.
sourceWorkbook.Worksheets.Add();

// Modify the second worksheet of the source workbook to be copied.
sourceWorkbook.Worksheets[1].Cells["A1"].Value = "A worksheet to be copied";
sourceWorkbook.Worksheets[1].Cells["A1"].Font.Color = Color.ForestGreen;

// Copy the second worksheet of the source workbook into the first worksheet of another workbook.
workbook.Worksheets[0].CopyFrom(sourceWorkbook.Worksheets[1]);

WorksheetActions.vb

' Create a source workbook.
Dim sourceWorkbook As New Workbook()

' Add a new worksheet.
sourceWorkbook.Worksheets.Add()

' Modify the second worksheet of the source workbook to be copied.
sourceWorkbook.Worksheets(1).Cells("A1").Value = "A worksheet to be copied"
sourceWorkbook.Worksheets(1).Cells("A1").Font.Color = Color.ForestGreen

' Copy the second worksheet of the source workbook into the first worksheet of another workbook.
workbook.Worksheets(0).CopyFrom(sourceWorkbook.Worksheets(1))