Aspose.Cells.Merge() performance issues

Aspose.Cells Product Family
1

I have been working on performance profiling for a particular project and found an anamoly. It appears that a particular RDL report generates it much quicker in HTML than it does in Excel. Normally, if the difference is a second or two, which isn't a problem to us. However, in this case we can render an HTML version of the report in 60 seconds, as opposed to the Excel version in about 220.

After running the Visual Studio 2010 Sampling profiler, we found that the bottleneck was in the Aspose.Cells.Cells.Merge() method (which took up 67% of the samples). I was wondering could this method be doing that would cause such a degradation in performance. Thank you.

2

Hi,

Thanks for providing us details.

Do you use Aspose.Cells for Reporting Services product and which version you are using? If so, did you try our latest version v1.7.0, kindly try it.

If you still find the issue, kindly do post your sample RDL file here, we will check it soon.

Thank you.

3

Thank you for your response. No, currently we are not using Aspose.Cells for Reporting Services. We are using Aspose.Cells for .NET, which allows use to use a customized RDL engine for rendering reports. However, I will look at this library as possible alternative.

4

Hi,

How are you using Aspose.Cells for .NET as a customized engine for your RDL reports?