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.