We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Performance issues with Worksheet.Cells.Find with older .NET framework (like 4.5.2)

Hi,

We noticed big performance difference in Worksheet.Cells.Find when using newer Aspose.Cells with older .NET framework, for example on a machine with .NET v.4.5.2 and using the same Excel files the timings in our logs are: 638 and 686 milliseconds while on another machine with .NET v.4.6.2 the timings in our logs are: 139 and 141 milliseconds.
Our code is looking like this:

private static void StripFormulas(Workbook workbook, Type excelFunctionType)
{
Cell cell = null;
object cellValue = null;
FindOptions findOptions = new FindOptions();
findOptions.LookInType = LookInType.OnlyFormulas;
findOptions.RegexKey = true;

foreach (var worksheet in workbook.Worksheets)
{
cell = worksheet.Cells.Find(ExcelFunctionNames.RegexForSearching(excelFunctionType), cell, findOptions);
------------------
------------------


Was there any change in Aspose.Cells which makes Worksheet.Cells.Find run so slow on older .NET framework versions ?

Best regards,
Aurelian Iordache
Software Developer
IBM Romania

Hi Aurelian,


Thank you for contacting Aspose support.

Could you please confirm if the two mentioned machines have similar processing capabilities? Moreover, could you please recheck the scenario by changing the Target Framework version of the test project on any of the mentioned machines? If you still see such vast difference in performance, please provide us an executable sample application along with all its dependencies (resources, assemblies) so we could evaluate the case on our side. If required, we will pass the same to the product team for thorough investigation.