Redirect to another worksheet

Redirect to another worksheet

Posted by: jerome on 22 April 2020, 12:59 pm EST

• 

  jerome

  • Post Options:
  • Link
    Copy

  Posted 22 April 2020, 12:59 pm EST

  Hi,

  Is there a way to redirect to another sheet dynamically? Initially, I have two worksheets ( Sheet A and B). From Sheet A, I go to Sheet B then from here I have a bootstrap modal with OK button. I just want to redirect it to Sheet A once I clicked the OK button.

  Your kind assistance would be graciously accepted. Thanks in advance.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 23 April 2020, 4:39 am EST

  Hi Jerome,

  You may use the ‘setActiveSheet’ or ‘setActiveSheetIndex’ method to achieve the required functionality. Please refer to the following code snippet:

  spread.setActiveSheet("Sheet1");
  

  You may also refer to the following sample demonstrating the same: https://codesandbox.io/s/suspicious-gould-zx8py

  For more information please refer to the following API references
  
  • setActiveSheet: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Workbook~setActiveSheet.html
  
  • setActiveSheetIndex: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Workbook~setActiveSheetIndex.html

  Regards

• 

  jerome

  • Post Options:
  • Link
    Copy

  Posted 23 April 2020, 10:33 am EST

  This is great! Thank you so much for your assistance.