I am using ASP.NET with vb script in my project.
1. In my code
dim wb = New XLWorkbook (Filename)
If the file is large in size (95000 records and the file size is around 6.5 MB), it throws out of memory excepion. But the memory is not released unless I logout and log in again. How do I get around this ?
2. I tried creating multiple workbooks from the same table by splitting them into different workbooks. But after I Save the first workbook with save as, the out of memory exception is thrown again. Is there a way to close the workbook or exit it so
that the next workbook will not face memory issues ?