“I have a requirement to dynamically convert Excel formulas into corresponding C# logic while reading an Excel sheet. Can anyone provide ideas or approaches to achieve this?
I attempted to dynamically convert Excel formulas to C# code. The result I achieved was converting an Excel formula like
IF(AND(” + InitialValue + ” > 0, ” + InitialValue + ” <> ” + DownPayment + “), -1 * Financial.Pmt(” + LoanRate + ” / 12, ” + LoanTermInYears + ” * 12, ” + InitialValue + ” – ” + DownPayment + “), 0) into its equivalent C# logic