This example demonstrates how to compute the formulas using ICalcData in Vb.Net.
The ICalcData object can be integrated into CalcEngine by passing it through constructor. Now, you can compute the expressions or equations using CalcEngine.
The ParseAndComputeFormula method of CalcEngine is used to evaluate the formulas using the values from ICalcData object by cell references.
Dim calcData As CalcData = New CalcData()
Dim engine As CalcEngine = New CalcEngine(calcData)
Dim formula As String = "SUM (A1,B1)"
Dim result As String = engine.ParseAndComputeFormula(formula)