Create Excel template using C3

Question

We have a requirement to create the Excel template with the below requirements: 

1. Give the unique ID for each column.
2. Need to add the predefined formulae in a certain column, and if the user enters the value in the related column, the calculation should happen.
3. We need to hide the formulae from the cell.
4. The need to add the background colour to the cell depends on certain limits of the value. If the limit is 4-5 and the user enters 6, then the background colour of the cell should be red.
5. Add one button or rectangle in Excel, and after clicking the button, it should ask you to select the date range and call the API, which is deployed in the Azure cloud.
6. It should perform certain validations before calling the API. 

We are using.Net 6. as a target framework in our web API project. Could you please provide some options or the code reference to achieve this functionality?