Results 1 to 2 of 2
  1. #1
    Hastur78 is offline Member
    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0

    Default Out of memory writing a 50k+ file

    Hello,

    During the process of writing a large xlsx file, with more than 50k rows, an out of memory happens.
    Is there any way to reduce the memory consumption during the file writing?

    Thank you

    Antonio

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,997
    Rep Power
    19

    Default Re: Out of memory writing a 50k+ file

    This is where I question the wisdom of a 50000 row spreadsheet...
    :)

    POI (and pretty much every Java-Excel framework) needs to hold the workbook in memory, and this is the cause of the problem. There's not a great deal you can do about it. If it's only crashing on the write have you considered giving it a bit more memory? SOunds like you are right on the edge of what it needs to do its job.

    Of course that's not terribly scalable, but then neither is Excel.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Replies: 1
    Last Post: 08-02-2012, 03:01 AM
  2. Replies: 14
    Last Post: 07-15-2011, 05:22 AM
  3. Replies: 1
    Last Post: 02-27-2010, 01:29 AM
  4. Replies: 3
    Last Post: 05-09-2009, 11:31 PM
  5. Serialization - writing/reading to memory
    By ajeeb in forum Advanced Java
    Replies: 3
    Last Post: 01-27-2009, 03:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •