Copy sheet(s) from one workbook to another

Copy sheet(s) from one workbook to another

Posted by: niels on 4 September 2024, 6:46 am EST

• 

  niels

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 September 2024, 6:46 am EST - Updated 4 September 2024, 6:51 am EST

  Is it possible to copy sheet(s) from one workbook to another?
  
  See the dialog screenshot. It looks like the dialog in Excel, but I don’t know how to open two workbooks in FpSpread and copy/move sheets from one workbook to the other.

  

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 5 September 2024, 2:40 am EST

  Hello Niels,

  Apologies but it is not possible to load multiple workbooks in the spread designer.
  
  To copy the sheet from one workbook to another, you can use the following code:

  SheetView  sheetFromWorkbook1 = fpSpread1.Sheets[0];
  //Copy sheet to workbook2
  fpSpread2.Sheets.Add(sheetFromWorkbook1);
  

  Regards,
  
  Prabhat Sharma.

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 5 September 2024, 3:38 am EST

  Thanks Prabhat, that helps. I will implement in my own code.