Mirror Part of a Sheet on other spreadjs

Mirror Part of a Sheet on other spreadjs

Posted by: m.holland-moritz on 29 September 2021, 10:03 am EST

• 

  m.holland-moritz

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 September 2021, 10:03 am EST

  Hello Team,
  
  I am working with the Designer Components on my Website. My Client is loading his excel file into the Designer, afterwards he can choose to click, my custom function, which opens a Dialog window. This window is on top of the designer, so the client can’t see his own sheet and data in the sheet. Scrolling is disabled aswell, as long as the dialog is open.

  My idea is, to mirror the Column my client is working with atm and the columns left and right to this one into another component, opened in a custom Panel, which is only visible, when this dialog is opened.

  Is there an easy way to mirror the data from the designer, to a normal different spreadjs sheet?

  Best regards,
  
  Maik

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 September 2021, 6:54 am EST

  Hi Maik,

  Yes, you may mirror the data from one spreadjs workbook to another easily using the fromJSON()/toJSON(), fromJSON method serializes the workbook into JSON which could be imported into spreadJS workbook using the fromJSON() method.

  API references:
  
  • fromJSON: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Workbook~fromJSON.html
  
  • toJSON: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Workbook~toJSON.html

  Regards
  
  Sharad

• 

  m.holland-moritz

  • Post Options:
  • Link
    Copy

  Posted 7 October 2021, 8:21 am EST

  Worked for me, Thank you.

  Regards
  
  Maik