Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Remarks

The CopySheet method is intended to allow for copying of sheets from one position to another within a single workbook. To copy content from a worksheet in one workbook to worksheet in another workbook, use the Worksheet.CopyPaste

All of the settings, configuration, and values on the original worksheet will be both preserved on the original worksheet and copied to the new worksheet. If there are any formulas in the worksheet that is copied that reference that worksheet, they will be updated to reference the new worksheet instead. Formulas on the original worksheet and on other worksheets will not be affected.

Introducedin
8.2
8.2

Copysheet was extended to support copying worksheets between workbooks for XLSX and XLSM files.

Example
Code Block
csharp
csharp
titleC#
sheets.CopySheet(ws1//An example of copying worksheets between workbooks
ExcelApplication xla = new ExcelApplication();
Workbook wbSource = xla.Open("sourceWorkbook");
Workbook wbDest = xla.Open("destWorkbook");

//Copy a worksheet from the source workbook into the destination workbook
//Insert the copy at the beginning of the workbook
Worksheet wsToCopy = wbSource.Worksheets[0];
wbDest.Worksheets.CopySheet(wsToCopy, 0, "Sheet2"wsToCopy.Name);
Code Block
vbnet
vbnet
titlevb.net
sheets.CopySheet(ws1'An example of copying worksheets between workbooks
Dim xla As ExcelApplication = new ExcelApplication()
Dim wbSource As Workbook = xla.Open("sourceWorkbook")
Dim wbDest As Workbook = xla.Open("destWorkbook")

'Copy a worksheet from the source workbook into the destination workbook
'Insert the copy at the beginning of the workbook
Dim wsToCopy As Worksheet = wbSource.Worksheets(0)
wbDest.Worksheets.CopySheet(wsToCopy, 0, "Sheet2")wsToCopy.Name)