title: Export to excel with large memory stream using c#
body: <p>I am using this code</p>
  
  <pre><code> using (XLWorkbook wb = new XLWorkbook())
              {
                  wb.Worksheets.Add(ds);
                  wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
                  wb.Style.Font.Bold = true;
                  HttpContext.Current.Response.Clear();
                  HttpContext.Current.Response.Buffer = true;
                  HttpContext.Current.Response.Charset = "";
                  HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                  HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename= EmployeeAndOrderReport.xlsx");
                  using (MemoryStream MyMemoryStream = new MemoryStream())
                  {
                      wb.SaveAs(MyMemoryStream);
                      MyMemoryStream.WriteTo(HttpContext.Current.Response.OutputStream);
                      HttpContext.Current.Response.Flush();
                      HttpContext.Current.Response.End();
                  }
              }
  </code></pre>
  
  <p>Its working fine But when i am exporting large record set its showing out of memory exception..why its showing like this??</p>