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%