none
Memory issue/Performance issue when creating/opening huge Excel 2007 files RRS feed

  • Question

  • Hi,

    Do you have any solution for the below described probelm
    http://stackoverflow.com/questions/1310384/how-to-effectively-buffer-and-flush-stream-in-open-xml-sdk

    When creating/opening an Excel 2007 file either by using OpenXMLSDK 2.0 or IO.Packaging resulting is consumption of more memory in RAM(opening 8MB of excel file is taking more than 1GB of RAM)

    Many Thanks in advance for your quick response.

    -VR
    Tuesday, November 24, 2009 3:43 AM

All replies

  • Hi, venkat9980

    Thanks for your question.

    The consumption of RAM not only depends the size of excel file, but also depends on the content of this excel file. If the data inside are almost the same, the compress rate of the file would be high. In this case more RAM are needed.

    And also would be please provide more details about your scenario? If you do not have to load all the DOM at once, maybe OpenXmlReader or OpenXmlWriter would help you with your jobs. 

    Thanks,
    Raymond

    Tuesday, November 24, 2009 8:52 AM