This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 10%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Hi,
I created a web job to generate a excel with OpenXml SAX approach.
While creating the excel I am facing an "out of memory exception in writer.WriteStartElement(new Cell(), attributes)" on 130,000th row with 32 columns each. As per the logs I didn't used more than 40% of the available memory but still I am facing this issue.
Plan : Isolated 2 with 7gb RAM
App service : .net version : core 3.1, Platform : 64 bit.
App Service : memory working set (Max) = 1.1 GB
App service plan memory consumption percentage : always less than 40%
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Thanks for asking question! You may capture the memory dump in your azure app service and analyze the dump to narrow down issue.
Refer to this tutorial for getting a full memory dump. Remote debugging with visual studio would be helpful here.
Check this SO thread might helps.
If issues remains request you to please send an email to AzCommunity[at]Microsoft[dot]com referencing this issue, we would like to work closer with you on this matter.
Just checking in to see if you have chance to see below response.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 55.00000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Issue can be related with a known issue in Open-XML SDK with SAX and Net Core: