How to improve performance of GC.Excel with large excel?

How to improve performance of GC.Excel with large excel?

Posted by: duy.nguyen on 19 August 2023, 11:57 am EST

• 

  duy.nguyen

  • Post Options:
  • Link
    Copy

  Posted 19 August 2023, 11:57 am EST

  Dear Supporter,
  
  We bought GrapeCity Documents for Excel, Java Edition v6 Developer Unlimited.

  We have a big excel files with thousands of columns, rows, and formulas (file size is about 28Mb). It took more than 4 minutes to calculate by using GC.Excel Java.

  When I open a task manager, I see that the app only consumed the memory about 300Mb. How to make GC.Excel Java use more memory to speed up the calculation?
  
  It would be helpful if any recommendation.

  Thanks alot
  
  Duy Nguyen

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 August 2023, 11:49 pm EST

  Hello Duy Nguyen,

  Apologies for the inconvenience caused.
  
  We are discussing this case with the development team and will get back to you as soon as we get any update from their end.
  
  [Internal Tracking ID: DOCXLS-8757]

  In the meantime, we request you to please share your Excel file so that we can investigate it on our end.

  If your file contains some confidential data then you can open a support ticket on our portal and share the file there.
  
  https://www.grapecity.com/my-account/my-support

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2023, 5:51 am EST

  Hello,

  We have created a private support case on the given link. Please continue the thread there only to avoid the confusion:

  https://www.grapecity.com/my-account/my-support/case/6bc95302-d140-ee11-bdf3-000d3a4e0eeb

  Regards,
  
  Prabhat Sharma.