Currently I’m implementing Aspose Cells in .NET application which uses an excel template for calculations. Once the web application is launched, at a button click event, the excel template is instantiated at run time and all specific data is written to it. Once this is complete, the calculated result values are read from it and displayed on the front end.
Since this application will be consumed by several users concurrently, how can we handle this in a multi user environment. The documentation provides some alternatives:
Load 1 file and then create new instances per user
Load 1 file, create 1 instance shared between users, (semaphores or synchronization necessary)
Load 1 file, create pool of instances shared between users (10 instances synchronized and shared between users).
Could you illustrate each with an example, since the site does not have enough examples on this topic.
Thanks & Regards,