Export huge data to Excel

Export huge data to Excel

Posted by: fidori123456789 on 28 July 2019, 11:21 pm EST

• 

  fidori123456789

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 July 2019, 11:21 pm EST

  Our team is facing the problem. We using the wijmo,grid,xlsx.FlexGridXlsxConverter.save funciton to export FlexGrid data to Excel with 10K Row and 50 Column. However, We using includeCellStyles set to true. When download file with Chorme: 45 min / 1 file .

  How to improve performance when output file.
  
  Our JavaScript versions are as follows:
  
  jQuery: 2.13
  
  Wijmo: 5.20191.606
  
  JsZip: 2.5.0
  
  Bootstrap: 3.3.1

  Thank and best regards !

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 29 July 2019, 7:10 am EST

  Hi,

  This is expected behavior in case of large datasets as the grid takes time to process the data and convert it to the workbook. Since the conversion of the grid to workbook needs access to DOM, it cannot be processed in a separate thread other than UI. We are sorry but you cannot improve performance while exporting large datasets to excel.

  Regards,
  
  Ashwin