I am currently using Aspose 8.3 version for .NET and trying to read calculated values from the file into my object which will then display on the front end. I have been using timers to monitor the time taken to perform these and compared it with our previous solution which had humungous workaround code.
Surprisingly the workaround code took an average of 3-4 seconds to read the values where Aspose version of the code took an average of 10-11 seconds. I was simply reading teh calculated values from Aspose using workSheet.cells["CellNumber"].value.
Could you suggest how we can speed this up since this is impacting the overall calculation time. I've tried using the Workbook.Settings.CreateCalcChain = false; and Workbook.Settings.MemorySetting = MemoryPreference.
Please could you suggest an alternative to this to help us reduce some time reading the calculated values.
Thanks & Regards,