Does SpreadJS provide an event or a callback function for binding spreadJson

Does SpreadJS provide an event or a callback function for binding spreadJson

Posted by: hghanta on 10 November 2020, 12:38 am EST

• 

  hghanta

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 November 2020, 12:38 am EST

  We are trying to bind a very large workbook( up to 100K records )to the spread control. Does spreadJS provides an event or callback function, so that we can use that to show the loader?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 10 November 2020, 8:59 am EST

  Hi,

  You may use setDataSorce method for the required functionality. Please refer to the following code snippet and attached sample that demonstrates the same.

  this.spinner.show();
      setTimeout(() => {
        sheet.setDataSource(this.getData(100000));
        this.spinner.hide();
      }, 1000);
  

  sample: https://stackblitz.com/edit/ngx-spinner-demo-supord?file=src/app/app.component.ts
  
  API Reference:
  
  setDataSource: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~setDataSource.html

  Regards
  
  Avinash