Best way to destroy and rebuild a new Spreadsheet instance

Best way to destroy and rebuild a new Spreadsheet instance

Posted by: davide.vago on 21 August 2019, 4:31 am EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 21 August 2019, 4:31 am EST

  Good morning/afternoon,

  I’m currently trying to rebuild programmatically a new spreadsheet instance.
  
  Given 2 variables: spreadInstance as type GC.Spread.Sheets.Workbook
  
  and the activeSheet as the type coming from getActiveSheet

  What’s the best way to wipe out the full instance, including the event listeners attached in order to rebuild a new one from scratch?

  I’ve been trying the method: destroy and reset both of them don’t really remove completely the objects from these 2 variables.

  Thanks in advance

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2019, 4:21 am EST

  Hi Davide,

  Using the destroy() method of spread Workbook is the recommended approach to destroy a spread instance. Please let us know the exact issues you encountered while using the destroy() method.

  Regards
  
  Sharad