Performance impact in Creation of Excel file with Huge data Records ( 1 lak records) RRS feed

  • Question

  • Hi

    we are using the openxml  sdk in building the excel file at runtime which was consuming bit high memory with normal load of around 100 records and it takes close to 1 min - 3 min time intervals based on the load. Now we need to support the file generation with 1 lak records data and we see a huge spike in the memory and this is blocking the other operations.. 

    is there any settings which can help us on file generation with less memory consumption even on huge data insertions into excel .



    Thanks, Manoj

    Tuesday, May 29, 2018 9:55 PM

All replies

  • Hello Manoj Mathe,

    How do you design your application? What's your code? 

    By the way, what is  "lak"? Is it a special unit?

    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Wednesday, May 30, 2018 10:04 AM