I have to port excel file which business guys are using to calculate final price to C# so I can later use this algorithm in Asp.Net application. This is something I will be doing not for the first time, but today it hit me. Maybe Excel can export to C#. I don't care if it will look ugly, but this is still something to start with.
Is there some Excel plugin where I could mark some input and output cells and this add-it would export it to C#?
Edit
Our client have Excel file where employes can modify some fields and see final price in another field. Excel file doesn't have any VB, but uses standard mathematical functions functions to calculate the price.
Imagine excel file used to calculate live insurance price.
- Excel file has empty cells company employer has to fill: client age, bad habits, insurance price, insurance period, discount and so on
- Excel file has many cells with constants. Constants are most likely coeficient (like price coefficient for number of years insurance contract is signed for for. The more years the less is the price)
- Excel file has many cells with intermediate values
- Excel file have one output cell with final insurance price for the whole period
What I have to do is to port calculations made with excel file to C#.