Auteur de questions

Question

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 .

Toutes les réponses

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 MSDNFSF@microsoft.com.