Issue - High Processing time of APIs - Need optimization

Aspose.Cells Product Family
1

Hi,

I am using Aspose.Cells for my application. While optimising the reponse time of my application, I noticed that following methods in Aspose.Cells is consuming significant amount of time.

  • Cells cells = namedRange.getCells( )
  • Cell cell = cell[rowIndex][columnIndex]
  • String cellName = cell.getName( )
  • cell.setR1C1Formula( )
  • cell.setFormula( )

I had gone through the suggestions and best practices that is there in your documentation. But, they are majorly around "How to use the APIs effectively".

I am more interested in reducing the processing time.

Please suggest me how to go about it.

Thanks,
Malay

2

I am attaching the statistics for a transaction.

3

Hi Malay,

Thanks for the statistices.

Could you create a sample console application to show the performance issue and post it here. We will check it and try to optimize in code (if needed) soon.

And by the way which version of Aspose.Cells for Java you are using, kindly try the latest verison 1.9.4.

Thank you.