System.OutOfMemoryException for big Excel worksheet in .NET

Hi all,


We are facing troubles with a recently installed Aspose server.
It’s
a windows server 2003 Std, with 3GB of RAM, and it has 2 pagefiles (on
for each unit, c: and d:) as big as we can configure in the OS, 4 GB.

the client use it to protect excel worksheets.
The issue is shown in this part of the ProtectSheet.log file

2/9/2010
4:12:11 PM: Início do
processo :114

2/9/2010 4:12:21 PM: ERRO no downloadFileXls: at System.Net.WebClient.DownloadData(String address)

at ProtectSheet.SheetProtection.downloadFileXls() - InnerException: System.OutOfMemoryException: Exception of type System.OutOfMemoryException was thrown. Message: An exception occurred during a WebClient request. -

2/9/2010 4:12:21 PM: Fim do processamento: IdEvent:114 - IdLib:3db8d888-d2d3-4bb9-8e79-9d9f6f0e96b8 - IdDoc:47 - NmDoc:Curvas_BIU UST.xls - CodAct:1 - CodResult:2 - MsgRetorno: at System.Net.WebClient.DownloadData(String address)

at ProtectSheet.SheetProtection.downloadFileXls() - InnerException: System.OutOfMemoryException: Exception of type System.OutOfMemoryException was thrown. Message: An exception occurred during a WebClient request.



Please, any comments will be appreciated!
Thanks in advance.

This message was posted using Email2Forum by ShL77.

Hi,

Thank you for considering Aspose.

As you are using an old version of Aspose.Cells, you may face some memory issues in opening some large excel files. Please try the attached latest version of Aspose.Cells. In this version we have enhance the performance and reduce the memory consumption in opening large excel files. If you still face any problem, please share your template file and sample code here to reproduce the issue. We will check it soon.

Thank You & Best Regards,

The problem begin when the size of the worksheets is superior to 20MB.

I hope you could help us.

We were waiting for your response.
Thanks!


This message was posted using Email2Forum by ShL77.

Hi,

Thank you for considering Aspose.

If you are still facing OutOfMemory Exception with the provided latest version (in my previous post) then you may need to allocate more memory to the IIS server. Please see the following link for more details about how to increase the memory allocated to IIS.

http://jesperen.wordpress.com/2007/05/23/understanding-aspnet-memory/

If you still face any problem, please share your template file and sample code here to reproduce the issue. We will check it soon.

Thank You & Best Regards,