System.Out.OfMemory Exception in Copying Worksheets Sheets

Hi ,

PFA the P1.xlsx. There are 30 similar excels like this one. And While Copying worksheets the system throws System out of Memory Exception. The Application consumes maximum Memory while copying Woksheets.

Problem Description:

While Copying All the Worksheets from the 30 different Excels the The application throws System outof Memory Exception. Kindly Replicte the P1.xlsx such that you have 30 different Excels.And Copy all these 30 Different Exccels to One Workbook(Programatically) and it throws System .out of memory Exception while copying all the worksheets to One workbook.

Appreciate your help in this regard.

Thanks,

Abdul R Sha.

Hi,


Please create a sample console Application with v7.0.3.x, zip it and post it here to show the issue with the template files, we will check it soon. If we found the issue, we logged it to our Issue tracking system.

Thank you.

Hi ,

Have attached the TestAspose.zip which contains the console application.

Working of the Code:

The code takes Input as excel files from a specific location(C:\\TestExcels) . And then copies all the Excel worksheets to One Particular Workbook(Destination.xlsx). So while copying the Worksheet to workbook the system throws outof Memory Exception.

Note :

Kindly Have 30 Different Excels in TestExcels Folder.Have already attahced p1.xlsx .copy it 30 times to have 30 different Excels in that folder.

Thanks.

Abdul R Sha.

Hi,


Well, your input file contains richly formatted worksheet that has charts. drawing shapes, tables, data etc. When you copy it 30 times, now when you copy each sheet in 30 different files to be merged in the output Excel file, it will surely demand huge memory resources and the the output file would be also a huge one. It may also take some time to complete the task. Make sure that you have sufficient resources to perform the big big process.

Also, give it a try our latest fixed version: please download: Aspose.Cells for .NET v7.0.3.4