C# – How to copy a single Excel worksheet from one workbook to another?

by

You could also use the Sheet.Copy() method.

Basically, Sheet.copy copies the sheet, and will automatically create a new workbook at the same time.

Try adding the following lines to your code, after your call to Worksheets.get_Item:

// Copies sheet and puts the copy into a new workbook
sheet.Copy(Type.Missing, Type.Missing);

// Sets the sheet variable to the copied sheet in the new workbook
sheet = app.Workbooks[2].Sheets[1];

Here’s the reference for the Copy() function as well:
MSDN Link

More Related Contents:

  1. How do I properly clean up Excel interop objects?
  2. Write Array to Excel Range
  3. Excel Interop – Efficiency and performance
  4. Exception from HRESULT: 0x800A03EC Error
  5. A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
  6. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  7. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  8. Microsoft.Office.Interop.Excel really slow
  9. Excel interop: _Worksheet or Worksheet?
  10. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  11. Resources for learning c# Excel interop [closed]
  12. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  13. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  14. Printing Excel using Interop
  15. .Net Excel Interop Deleting a worksheet
  16. Reading Excel files from C#
  17. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  18. Using Excel OleDb to get sheet names IN SHEET ORDER
  19. Format an Excel column (or cell) as Text in C#?
  20. How to write some data to excel file(.xlsx)
  21. How to export a JQgrid data to Excel using c#?
  22. Restore a minimized window of another application
  23. Which blocking operations cause an STA thread to pump COM messages?
  24. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  25. Add offset to IntPtr
  26. How to know if a cell has an error in the formula in C#
  27. keybd_event along with PostMessage win32 not working when Visual Studio has focus (or any application run as admin)
  28. Interoperating between Matlab and C#
  29. Using ExcelDataReader to read Excel data starting from a particular cell
  30. EPPlus – LoadFromCollection – Text converted to number

Leave a Comment