Hello KANISH S
Sure, here are two Azure services that are suitable for handling heavy load Excel calculations:
- Azure Functions. Azure Functions are serverless compute services that allow you to run code without provisioning or managing servers. This makes them a good choice for handling large numbers of concurrent requests, as you only pay for the resources that you use. Azure Functions can be used to execute Excel calculations, and they can be scaled up or down as needed to meet the demands of your application.
- Azure Batch. Azure Batch is a service that allows you to run large-scale batch jobs. This makes it a good choice for handling complex Excel calculations that require a lot of processing power. Azure Batch can be used to run Excel calculations on a cluster of virtual machines, and it can scale up or down as needed to meet the demands of your application.
Here is a table that summarizes the key features of Azure Functions and Azure Batch:
|Scales up or down automatically
|Scales up or down manually
|Pay for the resources that you use
|Pay for the number of jobs that you run
|Supported by all languages that run on .NET Core
|Supported by .NET Core, Java, Python, and R
|Ease of use
|Easy to get started with
|More complex to set up
Ultimately, the best Azure service for handling heavy load Excel calculations will depend on your specific requirements. If you need a scalable and cost-effective solution, then Azure Functions is a good choice. If you need a more powerful solution that can handle complex Excel calculations, then Azure Batch is a good choice.
I hope this helps! Let me know if you have any other questions.