When loading a very big Excel file (using the MemoryPreference setting, it is > 100MB) I get the following message:
System.OutOfMemoryException: Exception of type ‘System.OutOfMemoryException’ was thrown.
at System.IO.MemoryStream.set_Capacity(Int32 value)
at System.IO.MemoryStream.EnsureCapacity(Int32 value)
at System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at .(Stream , Stream )
…
There is enough memory on the system, but probably not enough contiguous memory. Microsoft has solved this problem by using Microsoft.IO.RecyclableMemoryStreamManager. See this article: http://www.philosophicalgeek.com/2015/02/06/announcing-microsoft-io-recycablememorystream/ and the github repository for it: https://github.com/Microsoft/Microsoft.IO.RecyclableMemoryStream
Aspose is critical for us but it fails to load large files. Using the Microsoft Memory Stream instead of System.IO.MemoryStream drastically reduces the potential of running into OutOfMemory exception.
Can you please use it or something like it to allow us to large big files with Aspose?