Copy a range of cells to another document

Copy a range of cells to another document

Posted by: Fabrice.Mainguene on 3 April 2024, 12:38 am EST

• 

  Fabrice.Mainguene

  • Post Options:
  • Link
    Copy

  Posted 3 April 2024, 12:38 am EST

  Hi,

  I need to copy and paste the content, style, formulas, etc. of a cell range from one spreadjs zone to another to create a document with pieces of another document programmatically.
  
  Is there an easy way to do that?

  Thanks

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 3 April 2024, 5:45 pm EST

  Hi,

  If you want to copy within a single worksheet, you could you the copyTo method: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#copyto

  And if you want to copy/paste across worksheets, you could use the clipboardPaste command: https://developer.mescius.com/spreadjs/api/modules/GC.Spread.Sheets.Commands#clipboardpaste

  Let me know if you face any issues.

  Regards,

  Ankit

• 

  Fabrice.Mainguene

  • Post Options:
  • Link
    Copy

  Posted 3 April 2024, 6:46 pm EST

  Thanks for your reply, but copying within the same document is not the point.

  I have two documents open in two different spreadjs areas and I want to copy by programming some cells from one document to another

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2024, 6:21 pm EST

  Hi,

  Currently, copy/ paste functionality is not supported in the SpreadJS across different workbooks. It is because across different workbooks for pasting the formulas, the context is different, and we have to consider many factors like duplicate sheet names, custom names, structure reference and so on.

  Suppose you have two workbooks “WB1” and “WB2” and you want to copy from “WB1” to “WB2”, you could perform the following.

  1. From the Sheet of “WB1” form which you want to copy the content, take the sheet’s json using “toJSON()” method.

  2. Add a new sheet in “WB2” (you could also hide the new sheet), use the fromJSON() method on the Worksheet and load the json that you get from Step1.

  3. Use the “clipboardPaste” command to copy from the new sheet to the sheet you want to copy.

  References:

  “clipboardPaste” command: https://developer.mescius.com/spreadjs/api/modules/GC.Spread.Sheets.Commands#clipboardpaste

  fromJSON method: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#fromjson

  toJSON method: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#tojson

  WorkSheet Class: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#constructor

  Let me know if you face any issues.

  Regards,

  Ankit