Export to Excel- Speed issue

Export to Excel- Speed issue

Posted by: ankita on 8 May 2019, 2:37 pm EST

• 

  ankita

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 May 2019, 2:37 pm EST

  Hello,
  
  We are using Wijmo pure js.
  
  For a grid having 15k + plus record takes too much time(6min-10min) to export to excel.

  Is their a faster way to do?

  
  var GridName = "Management" + '.xlsx';
  wijmo.grid.xlsx.FlexGridXlsxConverter.save(MyGrid, { includeColumnHeaders: true, includeCellStyles: true }, GridName);
  
  

  Thank you.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 May 2019, 1:07 am EST

  Hello Ankita,
  
  We have tried this with the latest build 5.20191.605 and following is the observation for the following demo fiddle:
  
  https://jsfiddle.net/vw4Ljfc6/
  
  param: includeColumnHeaders, includeCellStyles
  
  Browser records param time (~)
  
  Chrome 15k true 15second
  
  Chrome 15k false 1.5second
  
  Chrome 30k true 31second
  
  Chrome 30k false 2.59second
  
  IE11 30k true 174seconds
  
  IE11 30k false 5.677 seconds

  Hence, to improve the performance, we may set the includeColumnHeaders and includeCellStyles to false.

  If the issue persists, please share the demo sample depicting your issue.

  Regards,
  
  Manish Gupta