Sep 6, 2012 at 4:50 PM
Edited Sep 6, 2012 at 6:48 PM
Hello, I am creating a spreadsheet in vb.net used within a web application. Everything works great except it appears I am running out of memory.
With each use of library, I can see the memory continue to grow until memoryallocation errors start.
I believe the code is pretty straightforward. I have tried calling the Dispose methods as well but that has no affect.
Am I doing something wrong or missing something?
Also, this is .Net 3.5 (might be the version I am using?????)
Using wb As New XLWorkbook()
wb.EventTracking = XLEventTracking.Disabled
Dim resp = Response
resp.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
resp.Charset = ""
Using memoryStream As New MemoryStream()
Catch ex As Exception
Label_Status_Msg.Text = "***** ERROR: Problem creating Excel Sheet *****" + ex.Message.ToString()